PX Sequential Files

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

psriva
Participant
Posts: 44
Joined: Fri Aug 11, 2006 8:40 am

Post by psriva »

Fixed width
ps
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Then, as noted earlier, any null field value that you supply must have the same width as the field would if it contained a non-null value. For example if the field is Char(4), then an acceptable null field value might be "####" or something of that kind (even four spaces). The null field value property informs DataStage when reading this file that, if the indicated value is encountered, to import NULL. Or, when writing to the file, when NULL is received on the input link, to write this value into the field.
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