How to specify TAB as a delimiter for TDLOAD

Tools
Enthusiast

How to specify TAB as a delimiter for TDLOAD

TDLOAD supports -d parameter to define a custom delimiter but I cannot figure out how to specify a tab delimited input file.

I've tried -d '\t', -d '\t' and -d '\u0009' without success.

Any pointers are appreciated.

Thanks.

Tags (1)
2 REPLIES
Teradata Employee

Re: How to specify TAB as a delimiter for TDLOAD

Try -d 'TAB'

-- SteveF
Enthusiast

Re: How to specify TAB as a delimiter for TDLOAD

Thanks so much. It worked!