#DateForumTypeThreadPost
3011 Mar 2014 @ 11:56 PDTToolsReplyFASTLOAD SCRIPT ISSUECurrently, FastLoad supports NULLIF character value up to 80 bytes.
2910 Mar 2014 @ 12:45 PDTToolsReplyFASTLOAD SCRIPT ISSUEHi Gans, Not sure about your question but if records in the input file, have a field with value '********' and you want to load it as a NULL, then you can use NULLIF clause in the DEFINE c...
2803 Mar 2014 @ 09:05 PSTToolsReplyfastload on linux As Dieter mentioned: related to AIX using big-endian while your Linux box is little-endian. You can do FastExport on Linux box (to obtain the file) as you already did on AIX box, then FastLoad the...
2703 Mar 2014 @ 08:53 PSTToolsReplyFast Export parallelismThe way FastExport works as: Data block contains exported records that DBS server distributes on the sessions. Normally, FastExport gets data blocks on the sessions in the round-robin fashion. Assu...
2603 Mar 2014 @ 08:44 PSTToolsReplyError in FastLoad ScriptAlso, check your data file, make sure the data records are in FastLoad format and in the endian of the test machine.
2531 Oct 2013 @ 02:37 PDTToolsReplywhat does UTY8709 mean in fastexport.The message UTY8709 is only displayed when there is a restart after all records have been exported.
2431 Oct 2013 @ 11:18 PDTToolsReplyFLoad error: Unable to obtain Data SignatureWhat is the output and error message you get? When you do copy and paste, do not use formatted editors like words or wordpad; but try to use vi, edit or note. For the original issue, you get erro...
2330 Oct 2013 @ 08:51 PDTToolsReplyFLoad error: Unable to obtain Data SignatureI just sent you my data file. Your file does not end with \n or \r\n, it's the reason you get the data signature error! Did you create your file by cut and paste the data in WordPad and save ...
2229 Oct 2013 @ 04:57 PDTToolsReplyFLoad error: Unable to obtain Data SignatureNikhilesh, You can use a hex editor and see the contents of your data file since od command is not available on your system. What is your email address? I will send you my data file and see if it...
2129 Oct 2013 @ 01:26 PDTToolsReplyFLoad error: Unable to obtain Data SignatureNukalanikhilesh, Check your data file again. It's very likely EOF is encountered before the end of record. Try "od -c table_data.txt", and check if it's ended with  \r\n or...
2028 Oct 2013 @ 02:52 PDTToolsReplyFLoad error: Unable to obtain Data SignatureHi Nikhilesh, Could you save the data file to a different file. Then recreate the file in ASCII using a text editor. Then rerun the script again. I tried to run your script using fasload 14.00 a...
1907 Oct 2013 @ 04:50 PDTToolsReplyProblem with Fastload and teradata 14.0 with a NULLIFHi Dan, Which version of FastLoad 14.0 are you running. FastLoad has a fix for it starting from 14.00.00.005 Thomas
1827 Sep 2013 @ 10:32 PDTToolsReplyFast Export and MLoad Balu, Please refer to Teradata Tools and Utilities Access Modules User Guide Thomas
1710 Sep 2013 @ 10:46 PDTToolsReplyFast Export and MLoad Balu, I think you can use NP AXMOD. MultiLoad reads from the NP and FastEXport writes to NP. You can use regular named pipe but restarts don't work. Thomas
1610 Sep 2013 @ 10:43 PDTToolsReplyFastload DateTime, TimestampYou can refer to the DEFINE command in the FastLoad Reference Manual, Item "Using ANSI/SQL DateTime Data Types" and "Table 30: ANSI/SQL DateTime Specifications" Thomas
1522 Aug 2013 @ 02:11 PDTToolsReplyTeradata Fastload has stopped workingEminent, PIOM is Data Connector. I suspect the problem is related to the environment and/or your Windows system, sometimes it's due drivers or other applications on your machine. If you goog...
1421 Aug 2013 @ 11:57 PDTToolsReplyTeradata Fastload has stopped workingEminent, Make sure that the dependencies (tdcli, cliv2, piom) are installed correctly on your machine and run your script again. If it still does not work, run fastload with "show versions;&...
1301 Jul 2013 @ 04:23 PDTToolsReplywhat does UTY8709 mean in fastexport.The message UTY8709 means UTY8709 Restart in progress, processing for this FastExport task has already been completed. Explanation: Informational message. Generated By: EXPORT Remedy: None.
1201 Jul 2013 @ 04:05 PDTToolsReplyfastload errors with define delimiters.Hi, You use: SET RECORD VARTEXT "|"; Your DEFINE command looks like you want to use UNFORMATTED :-(. If you DEFINE command as kusumayella provided, it should work! Please read the Fa...
1101 Apr 2013 @ 03:16 PDTToolsReplyusage of check point in fastloadHello, It is correct, resubmit the job is just enough. Make sure that the Error tables and the target tables are untouched (i.e. no drop Error Tables, or recreate the taget table). Thomas
1020 Mar 2013 @ 10:28 PDTToolsReplyRe: remove the CRLF in the fastexport generated fileBalu, You can write an outmod to validate and preprocess export data records from Teradata Database before writing them to files on the client system. Thomas
918 Mar 2013 @ 10:57 PDTToolsReplyFASTLOAD Error - Loading Fixed Length file to TableHi Kiranwt, You need to remove the character ':' in front of the fields defined in the DEFINE command, it will become: DEFINE EID(CHAR(1)), ENM(CHAR(5)), ECD(CHAR(2)), ESAL(CHAR(5...
805 Feb 2013 @ 10:34 PSTToolsReplyDuplicate rows in Fload while loading in a NOPI table?Barani_sachin, What happens on the DBS side is: The DBS has a special recovery scheme for NoPI table that throws away only duplicates from data that are resent due to a restart. There is no sort ...
704 Feb 2013 @ 02:22 PSTToolsReplyDuplicate rows in Fload while loading in a NOPI table?Barani_sachin, If there is a DBS restart, FastLoad reloads data from the last checkpoint, it does not effect dupicate rows loading processing. 
614 Jan 2013 @ 10:47 PSTToolsReplyMainframe VB piped input file - How to defineHi Koentje, Starting from 14.10, FastLoad support VARTEXT on mainframe. Thomas

Pages