DSXchange

Difference between RawLength and Len function?

As far as i know RawLength function operates on Raw Data type and Len function operates on String data type.But i do not know what is meant by Raw Data type?Could anybody provide any sample data for Raw Data type to understand Raw Data type?

RawLength() returns number of bytes of data from a raw ( VarBinary/Binary ) data column. Len() returns number of characters - which can vary depending upon the encoding you use to store character data ( Single Byte or double byte etc) for a column.

In DataStage BASIC (and therefore in sequences) you have ByteLen() rather than RawLength(). There is also LenDP() which is the length of a string in terms of the number of character positions needed to display it, catering primarily for double width characters encountered in some Asian character sets.
囍