Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

EBCDIC_ISO88591

EBCDIC_ISO88591

Converts a binary value encoded in EBCDIC to a string value encoded in ISO-8859-1. If a second argument is not provided, it uses the EBCDIC 037 code page to perform the conversion. Valid second argument values are "037", and "1047".
To use the
EBCDIC_ISO88591
function, set the environment variable
INFA_ENABLE_BINARY_FUNCTIONS
to True or Yes.

Syntax

EBCDIC_ISO88591(
value1 [, value2]
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
value1
Required
Binary data containing EBCDIC characters.
value2
Optional
String containing one of "037" or "1047".

Return Value

String with the ISO-8859-1 equivalent of the EBCDIC encoded binary data.
NULL if the input is a null value.

Example

The following examples return a string value encoded in ISO-8859-1.
EBCDIC_ISO88591( BIN_EBCDIC )
BIN_EBCDID (Shown in Hex)
RETURN VALUE
0xC885939396
“Hello”
0xE696999384
“World”
NULL
NULL