#DateForumTypeThreadPost
6330 Aug 2016 @ 11:04 PDTToolsReplyFastExport Remove Binary/Indicator Values in Outmod Hi, There are some sample OUTMOD routines in Teradata FastExport manual(B035-2410) Appendix C. Thanks!  
6230 Aug 2016 @ 10:47 PDTToolsReplyError Table MloadHi, Here is related information on 2665: 2665 Invalid date. Explanation: This error occurs when date arithmetic is attempted on an invalid date. Generated By: AMP Steps. For Whom: End User....
6129 Aug 2016 @ 08:42 PDTToolsReplyError Table MloadHi, 1. Can you let us know the error code recorded in the error table? If it is in the Application Error Table, the column name is DBCErrorCode; If it is in the Acquisition Error Table, the colu...
6029 Aug 2016 @ 03:47 PDTToolsReplyMULTILOAD BUFFER ERROR!!! urgentHi, 1. Can you let us know the MultiLoad version and the Teradata Data Connector version? The Data Connector version could be obtained by issuing a ".version;" command using MultiLoad. ...
5911 Aug 2016 @ 01:35 PDTToolsReplyFastload error: I/O Error on File Open 34Hi, Glad to know that it worked after correcting the syntax error. It would be nice for FastLoad not to issue the misleading message which leads to a Teradata DataConnector related error. Teradata...
5804 Aug 2016 @ 02:40 PDTToolsReplyRecord count from worktable in mloadHi, Here is Locking summary during a MultiLoad job:  - Begin MLOAD Step    . Target table       - write lock    . Work table &...
5721 Jul 2016 @ 03:22 PDTToolsReplyFloat data type export using Fast ExportHi, This is not related to FastExport utility. We can see this using BTEQ too. Is it Okay to use some other data types like decimal? Here is an example:  BTEQ -- Enter your SQL request or ...
5613 Jul 2016 @ 10:36 PDTToolsReplyFastload - Error on piom GET ROW: 64Hi, There was a similar issue and it is fixed in Dataconnector 15.00.00.003 and above. Please try to use 15.00.00.003 and above versions of Dataconnector and let us know if there is still issues. ...
5512 Jul 2016 @ 03:00 PDTToolsReplyFastload - Error on piom GET ROW: 64Hi, 1. Can you let us know the Teradata Data Connector version? This could be obtained by issuing a ".show version;" command using FastLoad. The version will be followed "Teradata ...
5428 Jun 2016 @ 11:34 PDTToolsReplyFastExport : SET SESSION SEARCHUIFDBPATHHi, You can send the SQL after the LOGON statement and before .BEGIN EXPORT statement. Here is an example: .LOGTABLE fexplog; .LOGON <the tdpid>/<the user id>, <the user password&...
5311 May 2016 @ 05:08 PDTToolsReplyMulti Load UTY0006 Input error in the FIELD commandHi, Please share with me  the FastExport script and target table definition. I will take a further look. Thanks! For the time being, you can try to change the line to: .field IBNRSkadeestim...
5204 May 2016 @ 11:42 PDTToolsReplyIssues in Multiload, Insert and Update for Multiple tablesHi, Can you please provide the MultiLoad job output? If possible, can you share with me your target table definiation and the MultiLoad script/data file? Thanks!
5121 Mar 2016 @ 01:13 PDTToolsReplyVery large table loading fails with Fastload, what are other possible solutions? Here is the link to the patch server: http://tssprod.teradata.com:8080/TSFS/
5008 Mar 2016 @ 12:15 PSTToolsReplyMload failing when trying to load file with þ (thorn) as delimiterBTW, there is an additional blank space in-between field6" and the þ in your data file. The result could be a sightly different from non-addtional blank space. "field6" &thor...
4908 Mar 2016 @ 12:03 PSTToolsReplyMload failing when trying to load file with þ (thorn) as delimiterHi tonez01, I copied your 'þ' character and put the in mload script as the delimiter, and just used the ASCII session character set,       format vartext&nb...
4808 Mar 2016 @ 11:25 PSTToolsReplyhow to load different files using multiload into different tables.Hi Deepak, Yes, those 5 IMPORTs are processed sequentially. The MultiLoad job will terminate if loading one of the tables fails due to certain errors, the MultiLoad job could be re-submitted aft...
4715 Feb 2016 @ 01:27 PSTToolsReplyVery large table loading fails with Fastload, what are other possible solutions? Hi, Please install DataConnector 15.00.00.02 or 14.10.00.08 Efixes or later versions to resolve "empty file on read open" error for large files on Windows platform. Thanks!
4602 Feb 2016 @ 04:45 PSTToolsReplyMultiload failureHi, Regarding **** 07:06:54 UTY0805 RDBMS failure, 3807: Object 'BKP.customers1' does not exist. You need create the table first for MultiLoading. --Ivy.
4527 Jan 2016 @ 01:52 PSTToolsReplyMultiload + LDAPHi Tushar, The screen shot only has the MLOAD error and from this screen shot alone we don’t know what is going on. The LDAP mechanism all happens on the server side and minimally we need th...
4410 Sep 2015 @ 10:07 PDTToolsReplyDelete MLoad is giving errors - bad internal status - Delete Mload Started while Import Mload suspendedHi, It looks to me there is a prior MultiLoad job was suspended before you started the delete mload. You can try completing the prior MultiLoad job and then sunbmit the delete mload. If you stil...
4304 Sep 2015 @ 09:54 PDTToolsReplyhow to load different files using multiload into different tables.Hi, MLOAD could load up to 5 target tables, here is a pseudo MLOAD script to load data to 5 target tables using 5 data files: .BEGIN IMPORT MLOAD TABLES <target table 1>,<target table...
4226 Aug 2015 @ 12:10 PDTToolsReplymload error - glibc detected *** mload: free(): invalid next size (fast): 0x08171308Hi, In "/xx/xxx/bteq_logon.txt", there should be the LOGON statement and probably a LOGTABLE statement, Can you check if the LOGON statement ends with a semicolon, like, .LOGON <tdp...
4126 Aug 2015 @ 11:58 PDTToolsReplyfastload error "not enough fields in vartext data record number".Hi, I could succesfully execute the same flod script using the same data file from my side, please find the out listed below. Please double check if there are some extra characters in the data fi...
4015 Jul 2015 @ 01:55 PDTToolsReplyfast export and mload with unicode column type and valueHi, Since UTF8 is used, please double check if the size of the unicode column is tripled in the mload script. For example, if "Column3 char(10)" is specified in the target table, in mlo...
3904 Jun 2015 @ 03:18 PDTToolsReply2573 Invalid match tag foundHi, 2573 error will be returned if the match tag in the current parcel cannot be found. Can he try to do some clean up and run mload freshly(new logtable and new target table) to see if this erro...

Pages