Reading Unsigned Packed Decimals.

sanjumsm · Post by **sanjumsm** » Mon Jun 01, 2009 12:23 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 01, 2009 4:16 pm

You can mask the final byte with the BitAnd() function.

arjun_004 · Post by **arjun_004** » Mon Jun 01, 2009 6:02 pm

ray.wurlod wrote:You can mask the final byte with the BitAnd() function. ...

Hi Ray,

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 01, 2009 6:59 pm

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.