Load qouted data with delimiter chanrater in values

Tools
Fan

Load qouted data with delimiter chanrater in values

Hi,

Can we load the below data using Bteq/Mload 13.0 . Please suggest

3 columns with ',' as delimiter and enclosed by quotes with ',' and qoutes possible in values. Can escape the quotes in the values with another quote.

Values:

"abcdef","ghi,jkl","mn""o,p"

Thanks

1 REPLY
Teradata Employee

Re: Load qouted data with delimiter chanrater in values

Yes you can with MultiLoad. But not with version 13.0.

I believe the first version with the "quoted data" feature was 14.0.

The MultiLoad Reference Manual will have the commands necessary for this feature.

(As a side note, 13.0 is not a supported version of TTU.)

-- SteveF