DB2 for iSeries中十六进制值转EBCDIC的方法咨询

Got it, let's tackle your EBCDIC conversion problem step by step. First, your initial SQL attempt didn't work because CODEBASE(37) isn't the right approach for character encoding conversion in DB2—let's fix that first.

DB2 SQL Solution #

Assuming your column stores binary data (the raw bytes like F9F9F9F9 rather than a string of hex characters), you can use CAST with the correct EBCDIC CCSID (IBM's character set identifier). CCSID 37 is the standard EBCDIC encoding for US English, where F9 maps directly to the character 9.

Use this query:

SELECT CAST(your_column AS CHAR(4) CCSID 37) FROM your_table;

• Adjust CHAR(4) to match the length of your binary data (each hex pair is 1 byte, so F9F9F9F9 is 4 bytes → CHAR(4)).
• If your column stores hexadecimal strings (like the literal text 'F9F9F9F9'), first convert the string to binary with HEXTOBIN, then cast to EBCDIC:

  SELECT CAST(HEXTOBIN(your_column) AS CHAR(4) CCSID 37) FROM your_table;
  

COBOL Alternative (in case that expired link was COBOL-focused) #

If you're working with COBOL on a mainframe, handling EBCDIC conversion is straightforward since COBOL uses EBCDIC by default for character data.

Case 1: Data is a hex string (e.g., 'F9F9F9F9')

05  HEX-STRING-IN       PIC X(8).       // Stores the 8-character hex string
05  BINARY-DATA         PIC X(4) COMP-X.// Holds converted binary bytes
05  EBCDIC-RESULTS      PIC X(4).       // Will hold '9999'

* Convert hex string to binary
MOVE FUNCTION HEXTOBIN(HEX-STRING-IN) TO BINARY-DATA
* Move binary to EBCDIC character field
MOVE BINARY-DATA TO EBCDIC-RESULTS

Case 2: Data is already raw binary bytes

If you're reading directly from a file or database column that contains the raw F9F9F9F9 bytes, just move the binary data to a character field:

05  RAW-BINARY-DATA     PIC X(4) COMP-X. // Raw EBCDIC bytes
05  EBCDIC-CHARACTERS   PIC X(4).       // Output: '9999'

MOVE RAW-BINARY-DATA TO EBCDIC-CHARACTERS

Both methods will correctly map each EBCDIC byte to its corresponding character—so F9F9F9F9 becomes 9999 as you expected.

内容的提问来源于stack exchange，提问作者AskMe