I am writing a fastload script to load a 13M files to a teradata table.
I received error
= FASTLOAD UTILITY VERSION 14.10.00.07 =
= PLATFORM LINUX =
= Copyright 1984-2015, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
**** 04:33:39 Processing starting at: Wed Aug 24 04:33:39 2016
**** 04:33:39 The request exceeds the length limit.
The maximum length is 1048500.
= Exiting =
**** 04:33:39 Total processor time used = '0.03 Seconds'
. Start : Wed Aug 24 04:33:39 2016
. End : Wed Aug 24 04:33:39 2016
. Highest return code encountered = '12'.
**** 04:33:39 FDL4818 FastLoad Terminated
The data file is 13MB and has 98751 rows.
I remember fast load can handle many more rows than this.
Kindly let me know how to load this file in one piece.
I believe the issue *might* be related to the delimiter.
The use of "\t" does not mean use the TAB character. We will look for the characters "\" followed by "t", and thus we keep reading until we get too much data.
Try this and see if it helps.:
SET RECORD VARTEXT "TAB";
Thanks for your reply. It works.
Another questions: if I have the delimiter as "DEL" or ^P or 0x10, how do I write "SET RECORD VARTEXT"?
Is there a mapping somewhere between the teradata delimiter and ascii?
The delimiter must be a printable character.
FastLoad does not support hex values.