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.
Different results from CFF (EBCIDIC) stage between envs
Moderators: chulett, rschirm, roy
Steve, if you turn on $OSH_PRINT_SCHEMAS can you check whether the column datatype going into your CFF stage in the "bad" environment is signed or not - that would narrow down the search for a cause.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Actually its Ed (you know the one you worked with whom taught you all you know :D )
Actually resolved this finally - but had to
copy the original jobs
delete the originals
rename the jobs back
compile and run
So they get assigned new job numbers , repository objects etc
And came out as proper display numeric
Going to have to try to replicate the issue - but suspect that the format was originally Signed Numeric, got changed in the CFF stage recompiled and worked on DEv , but when moved to UAT and recompiled didnt
How mad is that
Actually resolved this finally - but had to
copy the original jobs
delete the originals
rename the jobs back
compile and run
So they get assigned new job numbers , repository objects etc
And came out as proper display numeric
Going to have to try to replicate the issue - but suspect that the format was originally Signed Numeric, got changed in the CFF stage recompiled and worked on DEv , but when moved to UAT and recompiled didnt
How mad is that
Sorry Ed, I must have equated the userid with size Since you soaked up all my knowledge, can I have some of it back please? A couple of hit-points would do me well right now.
Glad to hear that you've solved it, even though the solution was non-trivial.
Glad to hear that you've solved it, even though the solution was non-trivial.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>