Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2005 @ 18:21:29 GMT
I don't believe that it exists.
However, if the data is all ASCII, you could load the data into a single column table and then parse it in SQL or use sonething on your load machine to convert it into fixed width.
MLOAD (and FASTLOAD and FASTEXPORT) are based on the mainframe philosophy of predefined fixed width fields, not UNIX/Windows variable length fields.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|