AS400 Data Packed Converting

[Paul Farry]

I'm having a serious amount of trouble interpreting some data in an AS400 database file. If I look at the Binary representation of the data in the AS400, I see (The values are vertical/columns) Example 1: 001 10F Now on the AS400 this = 1001 When I pull this data to Windows, I get Hex(01 00 1F) or 65567 Example 2: 000 01F Now on the AS400 this = 10 When I pull this data to Windows, I get Hex(00 01 0F) or 271 Example 3: 001 00F Now on the AS400 this = 1 When I pull this data to Windows, I get Hex(00 00 1F) or 31 Now the project at hand is build a utility that will extract this data, and populate a perform value analysis on this.. But I can't figure out an algorithm which will convert this so something useful. Has anyone got any clues about converting this?

[David Crow]

Don't you need to convert from EBCDIC to ASCII?

[Paul Farry]

I hope it's as simple as that. ALthough from the reading I've done.. EBCDIC isn't that easy to convert from. I could be due to the fact the AS400 (rpg) programmers don't really know how it(as400) packs the data, it just "is"

[David Crow]

Funny you should mention, as I work with an RPG programmer. His code runs on the AS/400, while mine runs on the PC (Windows). Whenever I send him data, it must be converted from ASCII to EBCDIC. Whenever he sends me data, it must be converted from EBCDIC to ASCII. I use a library provided by IBM that has a couple of convertors in it.