#DateForumTypeThreadPost
912 May 2009 @ 09:06 PDTToolsReplyHow to skip data errors during fastload?BTW, the NOSTOP option only works for VARTEXT record formats. It does NOT work for the binary formats.
821 Apr 2009 @ 03:46 PDTToolsReplyDifference between text format and unformat in mloadTEXT data format consists of 'n' bytes of data, followed by an end-of-record marker (usually 0x0a), also known as '' (newline character).UNFORMATTED data format consists of raw data, and MultiLoad ...
716 Mar 2009 @ 01:55 PDTToolsReplyFastexport Format - For a comma sepated or a fixed width fiileFastExport does not support the output in delimtied format.
616 Mar 2009 @ 01:46 PDTToolsReplycan we use subquery in mload DELETE commandTry it out!There is nothing in the Client MultiLoad code that checks for a subquery, so if there is a restriction on that type of operation, then it would be a restriction from Teradata.
516 Mar 2009 @ 01:45 PDTToolsReplyfastload errorOk, I spoke with the FastLoad developer and the problem was fixed in TTU13.0.The fix was also backshipped to FastLoad 12.00.00.07 and also merged into the TTU13.0 code base.Therefore, if you are us...
411 Mar 2009 @ 04:07 PDTToolsReplyloading multiple files using multiloadI believe MultiLoad supports more than just 4 IMPORT statements.Another option to think about is TPT, which has the capability of reading entire diirectories of filesand sending them to an Update o...
311 Mar 2009 @ 04:01 PDTToolsReplyGetting error on Fastload..."nvalid state for Load"Apparently, you are attempting to re-run or resubmit a job that terminated previously for some reason.Please provide more detailed information about this so that I can help you out.The table exists...
220 May 2008 @ 06:33 PDTToolsReplyUsing TPT, how to specify a starting line when importing from a file.TPT does not have the ability to "skip" rows, and we are aware of that issue, and we are working on that.
120 May 2008 @ 06:31 PDTToolsReplyHow to use the the -S with tbuildtlogview is the tool to extract out the information from the TPT logs. Running TPT is not theexact same as running the traditional utilities such as FastLoad, where those utilities are madeup of si...

Pages