^Z characters

iskapalli · Post by **iskapalli** » Mon May 11, 2015 2:50 am

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?

ray.wurlod · Post by **ray.wurlod** » Mon May 11, 2015 2:07 pm

What's different between the development and production environments?

Hint: "nothing" is not the correct answer.

chulett · Post by **chulett** » Mon May 11, 2015 2:24 pm

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?

iskapalli · Post by **iskapalli** » Mon May 11, 2015 6:11 pm

thanks for your reply

one of the column in the file is comeing as 'PARK G^ZELL '.

chulett · Post by **chulett** » Tue May 12, 2015 6:35 am

Then I defer to Ray's question.

iskapalli · Post by **iskapalli** » Sun Jun 21, 2015 10:05 pm

thanks for your reply

both environment are same. Could you please let me know whether I need to check any environment variables?

Thomas.B · Post by **Thomas.B** » Mon Jun 22, 2015 1:48 am

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