Null handling for CHAR + nullable field
Posted: Mon Feb 08, 2016 9:43 am
Hi,
I am reading pipe delimited file and loading data to Teradata by parsing data through schema file. (Generic job)
The job is failing with warnings, The input looks like below. (No NULL, No Space)
AAA||BBB|C|C
BBB||CCC|D|E
At target the datatype is CHAR(1) NULLABLE.
When I parse data through schema file for the second field, the job generates warnings.
I have tried adding APT_STRING_PAD_CHAR environment variable with values 0x0 and 0x20, but doesn't seem to be working.
PARAS: NULLABLE string[1];
Please help me to resolve this issue.
I am reading pipe delimited file and loading data to Teradata by parsing data through schema file. (Generic job)
The job is failing with warnings, The input looks like below. (No NULL, No Space)
AAA||BBB|C|C
BBB||CCC|D|E
At target the datatype is CHAR(1) NULLABLE.
When I parse data through schema file for the second field, the job generates warnings.
I have tried adding APT_STRING_PAD_CHAR environment variable with values 0x0 and 0x20, but doesn't seem to be working.
PARAS: NULLABLE string[1];
Please help me to resolve this issue.