How to set '0x0001' as delimeter in tdload command?

Tools & Utilities

How to set '0x0001' as delimeter in tdload command?

I want to load a flat file which is divided by 0x0001 by tdload command to Teradata. You can find my two commds below.

But they both reported "length overflow the first row" .In my opinions, I dont's set delimeter corretly.

tdload -f filename \

-u user -p passwd -h server -t tablename \

--TargetWorkingDatabase dbname

-d SOH

OR 

tdload  --SourceFileName  filename \

 --SourceTextDelimiter 0x0001  \

--TargetUserName user  \

--TargetUserPassword passwd \

--TargetTdpId server \

--TargetTable tablename \

--TargetWorkingDatabase dbname\

In addition, Teradata version 14.

Tags (3)
1 REPLY
Teradata Employee

Re: How to set '0x0001' as delimeter in tdload command?

What version of TPT are you using?

-- SteveF