How to read this packed decimal value

Abhijeet · Post by **Abhijeet** » Thu Dec 15, 2005 5:34 am

How should i read the following 3 byte value in a single field.The expected value is 000030

value hex{00 00 30} - binary data

I tried using decimal packed option but its giving me an error. Now if I append a byte hex{0f} at the end , then read it using decimal pack len- 7 its working ... but i dont want to append any thing explicitly. Is there any other way by which i can directly read it.

ArndW · Post by **ArndW** » Thu Dec 15, 2005 6:56 am

If your data is unsigned, then using the sdk function DataTypePicCompUnsigned ought to do the trick.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 15, 2005 3:15 pm

In parallel jobs you can declare the value to be hex. Someone (Vincent?) posted this undocumented trick some months back.

ArndW · Post by **ArndW** » Thu Dec 15, 2005 5:12 pm

I didn't realize that this was a PX post - sorry about that. As Ray stated, a hex value would work as this is just a binary representation of the internal format. You could also declare it as a CHAR(3) field and then take the value

Code: Select all

(Seq(In.Col[1,1])*(2**16))+(Seq(In.Col[2,1])*(2**8))+Seq(In.Col[3,1])