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.
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
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