Creating EBCDIC/HEX values in Access 2000 tables

[Brad Mc]

I need to create a file from MS Access 2000 that will place EBCDIC/Hex values in the output record. This requirement is based upon the fact that the output file feeds into an IBM mainframe. I need to send high-values and low-values in the output record but can't seem to find a function which does this. The ToHex and Hex functions only generate the ASCII equivalent - not the true EBCDIC value. Any suggestions would be helpfull - And doing this in COBOL is not an option at this time

 

[Roger Carlson]

Take a look at the following Microsoft Knowledgebase article:

http://support.microsoft.com/defaul...port/kb/articles/Q216/3/99.ASP&NoWebContent=1


--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"The wonderful thing about Google is Google's a wonderful thing...

I need to create a file from MS Access 2000 that will place EBCDIC/Hex

values in the output record. This requirement is based upon the fact that
the output file feeds into an IBM mainframe. I need to send high-values and
low-values in the output record but can't seem to find a function which does
this. The ToHex and Hex functions only generate the ASCII equivalent - not
the true EBCDIC value. Any suggestions would be helpfull - And doing this
in COBOL is not an option at this time