If you keep the array in binary, you can set up maps for various different
EBCDIC encodings. You also have to watch for packed characters in the IBM
world. I may have some code I worked on a few years ago in .NET. If I can
find it, I will post the methodology.
If you are focused on SQL Server, Patrick Altman and Ben Harrell wrote an
SSIS plug in that does the conversion.
BTW, if you do not know the maps, you can run a sample of the EBCDIC through
different mappings and determine which one has the least number of garbage
characters. This will not help with packed characters, but it will make
things readable. Ultimately, someone needs to map fields when you are
converting from EBCDIC, especially if you are working with various clients.
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
*************************************************
| Think outside the box!
|
*************************************************