Page 1 of 1
^Z characters
Posted: Mon May 11, 2015 2:50 am
by iskapalli
Hi,
my job is
sequential file -------> teradata connector stage.
we are getting control characters in the file. we are unable to load the data into the table apr from ^Z characters. we want to load ^Z characters also.
In the produciton job is failing. But in the development ^Z characters are loading.
could you please help me on that?
Posted: Mon May 11, 2015 2:07 pm
by ray.wurlod
What's different between the development and production environments?
Hint: "nothing" is not the correct answer.
Posted: Mon May 11, 2015 2:24 pm
by chulett
You aren't actually seeing "control-z" or
^Z characters
in your record data, are you? I'm assuming you mean the ^Z is all on its lonesome as the last line in your file. In that case it is a
EOF you can find in Windows/DOS files typically. They are
not part of the data.
So which is it? Can you post examples?
Posted: Mon May 11, 2015 6:11 pm
by iskapalli
thanks for your reply
one of the column in the file is comeing as 'PARK G^ZELL '.
Posted: Tue May 12, 2015 6:35 am
by chulett
Then I defer to Ray's question.
Posted: Sun Jun 21, 2015 10:05 pm
by iskapalli
thanks for your reply
both environment are same. Could you please let me know whether I need to check any environment variables?
Posted: Mon Jun 22, 2015 1:48 am
by Thomas.B
You can compare the 'DSParams' files from your projects to see which parameter is different.
The 'DSParams' files are on your projects folders, ex :
/opt/datastage/IBM/InformationServer/Server/Projects/ADMIN