Reading a sequential file from an EE job into a server job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

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

Post by ray.wurlod »

When a VarChar is stored within osh it carries its length as a prefixed binary number, the size of which is specified by "prefix". A two-byte unsigned integer (uint16 or unsigned SmallInt) can address a string whose length is up to 2^16 characters. Longer strings require larger prefixes. {prefix=4} handles string lengths up to 2^32 characters (4GB if single-byte character set).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

Thanks for the Ray, much appreciated.

Cheers
Post Reply