Different results from CFF (EBCIDIC) stage between envs
Posted: Wed Sep 05, 2012 6:03 pm
Hi - dont know if anyone can help but have a strange issue that cant understand
Have a simple job that writes to a CFF stage (PX) as follows (EBCIDIC file on AIX env)
FIELD A - DISPLAY NUMERIC (4)
FIELD B - CHAR (3)
FIELD C - CHAR (10)
On one enviorment (Dev) it creates the file as expected e.g.
1234ABCXXXXXXXXXX
However on the other env (UAT) it appears as
123}ABCXXXXXXXXXX
The display numeric is presumably coming though as signed on the incorrect one
For info am running on UNIX (AIX) and getting the above results by using the dd conv=ascii command to check the results.
Originally had the issue on the dev env - but was solved by a recompile - presumed the binaries had got out of sync somehow with the Job - however tried the same on UAT and still get the incorrect format
I have checked both jobs and even bought back the jobs to same enviornment and done a compare - datastage says exactly the same - and checked the parallel layout on the CFF stage - again the same.
Any input gratefully recieved.
Have a simple job that writes to a CFF stage (PX) as follows (EBCIDIC file on AIX env)
FIELD A - DISPLAY NUMERIC (4)
FIELD B - CHAR (3)
FIELD C - CHAR (10)
On one enviorment (Dev) it creates the file as expected e.g.
1234ABCXXXXXXXXXX
However on the other env (UAT) it appears as
123}ABCXXXXXXXXXX
The display numeric is presumably coming though as signed on the incorrect one
For info am running on UNIX (AIX) and getting the above results by using the dd conv=ascii command to check the results.
Originally had the issue on the dev env - but was solved by a recompile - presumed the binaries had got out of sync somehow with the Job - however tried the same on UAT and still get the incorrect format
I have checked both jobs and even bought back the jobs to same enviornment and done a compare - datastage says exactly the same - and checked the parallel layout on the CFF stage - again the same.
Any input gratefully recieved.