DOUBLE QUOTES as string delimiters in source file

Tools & Utilities

DOUBLE QUOTES as string delimiters in source file

HI,

I am trying to upload a flat file exported from db2 into teradata using mload. However, the flat file has character fields enclosed in double quotes. This is causing an issue while uploading as mload returns an error which says that the data item is too large. How can I handle the double quotes in the mload script.

Kindly Advice.

Thanks in advance

Hari Menon
1 REPLY
SN
Enthusiast

Re: DOUBLE QUOTES as string delimiters in source file

hi,

two options I can think of...

1. Use INMOD and format the data before it passes on the data to MLoad
2. or try SUBSTR with INDEX/LENGTH options in MLoad script if you can extract just the data without the quotes.

HTH,