Binary Packed Numbers

[Former Member]

We are taking records off of a MQseries. I am using the JMS adapter to take messages off the series. The problem I am having is that in these messages there are Binary Packed Numbers, I believe these numbers are in the format that IBM uses to store number more efficiently. I was wondering if anyone else has had this situation, and what they did to fix it.

[Former Member · Accepted solution]

I am getting the same parse error as that guy in your second link, which means this probably isn't solvable using the basic XI tools...

[Former Member · Accepted solution]

Hi Paul !!

Have you tried with different text encodings in the file adapter ??

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Regards,

Matias

[Former Member · Accepted solution]

Hi Paul !!

Just an idea.. in SAP documentation about text encoding, says:

"Check which other character sets are supported in the documentation for your Java runtime implementation"

I've this data:

CP 037 8-bit EBCDIC encoding form

CP 500 8-bit EBCDIC encoding form

UCS-2??

useful link: http://www.hwacha.net/charsets

Maybe there is another charset that works ok with BCD.

Regards,

Matias.

[Former Member]

actually, matias, do you know if there is a way to just send the data as bytes to the message mapping, or hex even?

[Former Member]

Yeah, that's the same thing I thought of doing yesterday. I don't think there is a direct solution for this, but I have a lot of options to try out now, so I'll mark this thread as answered.

[Former Member]

Hi Paul !!

Ok. Please if you have any interesting result, post it ! I want to know if it could be solved that way.

Good luck,

Regards,

Matias.

[Former Member]

yes i believe they are teh same thing, only these are the packed version, fitting two bytes worth of data into one. Here's a page about it that you can confirm it with http://academic.evergreen.edu/projects/biophysics/technotes/program/bcd.htm

[Former Member]

Hi Paul !!

Check this threads:

As far as I understand, you are dealing with a message type, where some fields are binary packed numbers..and you need to convert them, am I right? maybe the best way is to create an UDF to deal with this.

Regards,

Matias.

[Former Member]

Hi Paul !

Are you talking about Binary-coded decimals (BCD) ??

Regards,

Matias.