How to handle null if decimal fileds last byte received null

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rhaddur
Participant
Posts: 52
Joined: Mon Mar 13, 2006 7:33 am
Location: mumbai

How to handle null if decimal fileds last byte received null

Post by rhaddur »

The last byte of the EBCIDIC source filed ( EX. FIELD1 decimal 9,5) is null indicator,

Which will be hex "00" if a value is held,
and a "?" character (hex "6F") if the field is null.

example
1) There will be 5 decimal places.

So 1234.56789 will be held as hex "123456789C00" (including the null indicator).

2)
So 1234.5678? will be held as hex "123456789C6F" (including the null indicator).

How to handl this last byte null field in server job (case2)
Target field = Targer 9.5
Rhaddur
Post Reply