Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 20:54:43 GMT
Does any one have idea on loading a data file with variable record lenght. The file is a comma delimted file and each field is packed in double quotes ie.,' " '. I cmae across a situation wherein some of the values in one of the fields are having comma inside the value and multilaod sees that as a separate field.
Is there any way to avoid such situation wiithout causing multiload to fail or reject the records as it thinks that the particular reocrd/field is larger than specified length.
Any suggestions or ideas are much appreciated.
Thanks for help in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|