TimeStamp in CFF Stage

burrougs · Post by **burrougs** » Fri May 11, 2007 9:56 am

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

ray.wurlod · Post by **ray.wurlod** » Fri May 11, 2007 3:46 pm

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.

burrougs · Post by **burrougs** » Wed Jun 27, 2007 1:47 pm

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

thamark · Post by **thamark** » Wed Jun 27, 2007 2:02 pm

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)....