Complex Flat file RECORD options

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
nynali
Participant
Posts: 31
Joined: Thu May 03, 2007 11:52 pm
Location: Hyderabad

Complex Flat file RECORD options

Post by nynali »

Hi,
I have NDMed a Mainframe file to UNIX in ASCII mode and this file contains PACKED numeric fields.
I am using this as input to Complex Flat file in DS.My doubt here is what should be record options for such files.
Like
What should be the Byte Order,Character Set,Data Format??
nynali
Edwink
Participant
Posts: 47
Joined: Sat Aug 19, 2006 4:57 am
Location: Chennai

Post by Edwink »

if the file is ordinaty txt file, data format should be Text.
Byte order set it as native-endian...
character set is also EBCDIC if data is in mainframe format..
please correct if m wrong...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You're wrong to generalize like that. The format could be anything. The CFF stage can handle many different formats. Reading the pertinent chapter in the manual, or the topics in on-line help, would be a good start point.
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