Change TPT handling of zero-length strings

Tools & Utilities
mzs
Enthusiast

Change TPT handling of zero-length strings

The article "Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00" has a passing comment that there is a possibility to change TPT handling of zero-length strings:

"The user can specify how empty data values are to be handled:

  • They can be assigned NULL (the default, for backward compatibility).
  • They can be set to zero-length VARCHARs."

When I import a delimited file using TPT, I get NULLs in a table in place of zero-length strings in a file.  I searched through TPT documentation, but did not find any switch, or parameter to modify that behavior.  Has anyone managed to successfully do that? 

Thank you




Tags (2)
2 REPLIES
Teradata Employee

Re: Change TPT handling of zero-length strings

Check the TPT Reference for 14.00. It is clearly stated in the documentation for the Data Connector operator:

NullColumns='N' is the optional attribute setting you are looking for.

mzs
Enthusiast

Re: Change TPT handling of zero-length strings

oops, I work with TD 12.

thank you very much,  apparently this option is not available in TD 12, need to call Dr. Brown

Mike