1 year ago

#69147

test-img

krx

How to enquote the thr exported csv columns using Teradata Tdload utility?

I am using the Tdload utility of Teradata to extract data from database to a csv file. The syntax which I have used in the command line is:

tdload --SourceTdpid 192.168.xx.xxx --SourceUserName dbc --SourceUserPassword dbc --SourceTable Database.TableName--TargetTextDelimiter "|" --FileWriterFileSizeMax 10M --TargetFilename "file.csv" My_Unload_Job

which works fine, but I also want the columns within double quotes.

For example - 1234 should be "1234".

What additional attribute can be added to the command line syntax to achieve this?

teradata

0 Answers

Your Answer

Accepted video resources