EBCDIC_CHR scalar function

The EBCDIC_CHR function returns the character that has the EBCDIC code value that is specified by the argument.

Read syntax diagramSkip visual syntax diagramEBCDIC_CHR( expression)

The schema is SYSIBM.

expression
An expression that returns a BIGINT, INTEGER, or SMALLINT built-in data type value.

expression can also be a character string or graphic string data type. The string input is implicitly cast to a numeric value of DECFLOAT(34) which is then assigned to a BIGINT value.

The result of the function is a CHAR(1) string encoded in the SBCS EBCDIC CCSID (regardless of the setting of the MIXED option in DSNHDECP). If the value of expression is not in the range 0–255, the null value is returned.

The result can be null; if the argument is null, the result is the null value.

Example: Set hv with the Euro symbol "€" in CCSID 1140: 
   SET :hv = EBCDIC_CHR(159);  -- x'9F'
Set hv with the Euro symbol "€" in CCSID 1142: 
   SET :hv = EBCDIC_CHR(90);  -- x'5A'
In both cases, the "€" is assigned to hv, but because the Euro symbol is located at different code points for the two CCSIDs, the input value is different.