I have senario where i have to read the Unsigned Packed Decimal.
I am using the sequential file stage to read the binary files.
Its value is
22334
and its HEX Value is
0234
023F
If any signed value come in the input file then it should be treated as Null.
Like
0234
023C OR
0234
023D.
I am able to read all these value from the source file.
Can we identify the unsigned decimal value at the time of reading in the sequential file.?
Or after reading the signed value can we seperate in the transformer. ?
Thanks & Regards
Reading Unsigned Packed Decimals.
Moderators: chulett, rschirm, roy
Reading Unsigned Packed Decimals.
sanjeev kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,ray.wurlod wrote:You can mask the final byte with the BitAnd() function. ...
BitAnd() will compare the actual value in the input field.
1214
000F AND
1214
000C Are same becouse the have the same value.
Unsigned and Positve number have the same value.
I need to identify if any signed number comes in the Unsigned decimal.
field.
Thanks & Regards
Thanks & Regards
Arjun Kumar
Arjun Kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are only certain rightmost nybbles that you can get for a signed packed decimal number. That's why I suggested using BitAnd() function - to identify whether these are present.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.