probelm reading signed packed data using CCF

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cknaga
Participant
Posts: 1
Joined: Mon Jun 19, 2006 9:09 am

probelm reading signed packed data using CCF

Post by cknaga »

The source file is a file that was created on a mainframe, tersed and ftp'd to an aix server. There it was untersed..Huge file 30m recs. The data is viewed using VIEW DATA from the output tab in the CFF stage.. Here things look good. When the job runs, warning occur with the signed decimal fields..From the message looks like things r shifting 1 byte with eaxh record. My thought was that is is related to the record delimter OxOa.. Tried adding that in the record delimiter without success.
Christine
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Can you just add a PIC X(001). to your column definition? Or is your picture of the data larger than the actual data?
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If the record delimiter really is 0x0A you can specify "UNIX newline" for this property. Or you can specify the three digit decimal code (010).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply