Page 1 of 1
TimeStamp in CFF Stage
Posted: Fri May 11, 2007 9:56 am
by burrougs
We are in the process of converting from 7.0 to 7.5.2 and are experiencing problems with the CFF stage. We have NLS enabled in the project and we have chosen NLS map of EBCDIC. The data is viewable with the exception of a column that was a date timestamp on the mainframe. The data looks similar to this in the CFF stage
?a??a????. Can anyone help with this issue? Thanks, Sheila
Posted: Fri May 11, 2007 3:46 pm
by ray.wurlod
Experiment with the NLS map setting. The CFF stage can manage EBCDIC internally, so try ISO8859-1 as a start point. Try NONE, although I doubt that that would work.
Posted: Wed Jun 27, 2007 1:47 pm
by burrougs
I change the NLS setting on the CFF stage and also the job level but without success. When I changed it on the job level all field were unreadable. The format of the field coming in on the CFF stage is CHARACTER 26 scale 6, could this need to be adjusted or have any impact on the results.
Thanks, Sheila
Posted: Wed Jun 27, 2007 2:02 pm
by thamark
burrougs wrote:I change the NLS setting on the CFF stage and also the job level but without success. When I changed it on the job level all field were unreadable. The format of the field coming in on the CFF stage is CHARACTER 26 scale 6, could this need to be adjusted or have any impact on the results.
Thanks, Sheila
Is the other fields are showing correctly?
What is the COBOL Copybook defination for the field you are talking about?
You need to define column defination as Decimal, if Copybook defines it as PIC 9(X)....