TPT Delimiter

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Enthusiast

TPT Delimiter

 

Below delimiter value is used in our TPT script. Could you please tell me what is value for this delimiter - \x002

 

varchar textdelimiter '\x002'

2 REPLIES
Apprentice

Re: TPT Delimiter

Hi,

On the face of it this is just a 5 character delimiter consisting of the characters: \ x 0 0 2

 

If the \x means anything special (although I can't find that feature documented in the TPT manuals) then it is likely that the 002 is a hex/octal representation of a character code. For ASCII characters the '002' is 'start of text' (aka STX).

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Enthusiast

Re: TPT Delimiter

 

Thanks Dave for the details.

 

Can we use hexadecimal characters as delimiters while exporting data from Teradata SQL assistant.

I can see , TAB etc  as possible delimiters available in SQL Assistant but how to use hexadecimal value.