Describing the Character Format

The input parameter column_value_mode describes the character format of the data that is being processed and is used in several of the function codes. The following table describes the meaning of the EXIT_FN_RAW_FORMAT, EXIT_FN_CHAR_FORMAT, and EXIT_FN_CNVTED_SESS_FORMAT format codes, per data type.

Table 8-15 column_value_mode_matrix Meanings

Data Type EXIT_FN_RAW_FORMAT EXIT_FN_CHAR_FORMAT EXIT_FN_CNVTED_SESS_FORMAT

Data Type	EXIT_FN_RAW_FORMAT	EXIT_FN_CHAR_FORMAT	EXIT_FN_CNVTED_SESS_FORMAT
`CHAR` `"abc`"	2-byte null indicator + 2-byte length info + column value 0000 0004 61 62 63 20	"abc" encoded in `ASCII` or `EBCDIC`. `NULL` terminated. Tailing spaces are trimmed.	"abc" encoded in user exit session character set. `NOT NULL` terminated. Tailing spaces are trimmed by default unless the `GLOBALS` parameter `NOTRIMSPACES` is specified.
`NCHAR` `0061 0062 0063 0020`	2-byte null indicator + 2-byte length info + column value. 0000 0008 00 61 0062 0063 0020	"abc" (encoded in `UTF8`) or truncated at the first byte, depending on whether `NCHAR` is treated as UTF-8. `NULL` terminated. Trailing spaces are trimmed.	"abc" encoded in user exit session character set. `NOT NULL` terminated. Tailing spaces are trimmed by default unless the `GLOBALS` parameter `NOTRIMSPACES` is specified.
`VARCHAR2` `"abc"`	2-byte null indicator + 2-byte length info + column value	"abc" encoded in `ASCII` or `EBCDIC`. `NULL` terminated. No trimming.	"abc" encoded in user exit session character set. `NOT NULL` terminated. No trimming.
`NVARCHAR2` `0061 0062 0063 0020`	2-byte null indicator + 2-byte length info + column value	"abc" (encoded in `UTF8`) or truncated at the first byte, depending on whether `NVARCHAR2` is treated as `UTF-8`. `NULL` terminated. No trimming.	"abc"encoded in user exit session character set. `NOT NULL` terminated. No trimming.
`CLOB`	2-byte null indicator + 2-byte length info + column value	Similar to `VARCHAR2`, but only output up to 4K bytes. `NULL` Terminated. No trimming.	Similar to `VARCHAR2`, but only output data requested in user exit session character set. `NOT NULL` terminated. No trimming.
`NCLOB`	2-byte null indicator + 2-byte length info + column value	Similar to `NVARCHAR2`, but only output up to 4K bytes. `NULL` terminated. No trimming.	Similar to `NVARCHAR2`, but only output data requested in user exit session character set. `NOT NULL` terminated. No trimming.
`NUMBER` `123.89`	2-byte null indicator + 2-byte length info + column value	"123.89" encoded in `ASCII` or `EBCDIC`. `NULL` terminated.	"123.89" encoded in user exit session character set. `NOT NULL` terminated.
`DATE` `31-May-11`	2-byte null indicator + 2-byte length info + column value	"2011-05-31" encoded in `ASCII` or `EBCDIC`. `NULL` terminated.	"2011-05-31" encoded in user exit session character set. `NOT NULL` terminated.
`TIMESTAMP` `31-May-11 12.00.00 AM`	2-byte null indicator + 2-byte length info + column value	"2011-05-31 12.00.00 AM" encoded in `ASCII` or `EBCDIC`. `NULL` terminated.	"2011-05-31 12.00.00 AM" encoded in user exit session character set. `NOT NULL` terminated.
`Interval Year to Month or Interval Day to Second`	2-byte null indicator + 2-byte length info + column value	NA	NA
`RAW`	2-byte null indicator + 2-byte length info + column value	2-byte null indicator + 2-byte length info + column value	2-byte null indicator + 2-byte length info + column value

CHAR

"abc"

2-byte null indicator +

2-byte length info

+ column value

0000 0004 61 62 63 20

"abc" encoded in ASCII or EBCDIC.

NULL terminated.

Tailing spaces are trimmed.

"abc" encoded in user exit session character set.

NOT NULL terminated.

Tailing spaces are trimmed by default unless the GLOBALS parameter NOTRIMSPACES is specified.

NCHAR

0061 0062 0063 0020

2-byte null indicator +

2-byte length info +

column value.

0000 0008 00 61 0062 0063 0020

"abc" (encoded in UTF8) or truncated at the first byte, depending on whether NCHAR is treated as UTF-8.

NULL terminated.

Trailing spaces are trimmed.

"abc" encoded in user exit session character set.

NOT NULL terminated.

Tailing spaces are trimmed by default unless the GLOBALS parameter NOTRIMSPACES is specified.

VARCHAR2

"abc"

2-byte null indicator +

2-byte length info +

column value

"abc" encoded in ASCII or EBCDIC.

NULL terminated.

No trimming.

"abc" encoded in user exit session character set.

NOT NULL terminated.

No trimming.

NVARCHAR2

0061 0062 0063 0020

2-byte null indicator +

2-byte length info +

column value

"abc" (encoded in UTF8) or truncated at the first byte, depending on whether NVARCHAR2 is treated as UTF-8.

NULL terminated.

No trimming.

"abc"encoded in user exit session character set.

NOT NULL terminated.

No trimming.

CLOB

2-byte null indicator +

2-byte length info +

column value

Similar to VARCHAR2, but only output up to 4K bytes.

NULL Terminated.

No trimming.

Similar to VARCHAR2, but only output data requested in user exit session character set.

NOT NULL terminated.

No trimming.

NCLOB

2-byte null indicator +

2-byte length info +

column value

Similar to NVARCHAR2, but only output up to 4K bytes.

NULL terminated.

No trimming.

Similar to NVARCHAR2, but only output data requested in user exit session character set.

NOT NULL terminated.

No trimming.

NUMBER

123.89

2-byte null indicator +

2-byte length info +

column value

"123.89" encoded in ASCII or EBCDIC.

NULL terminated.

"123.89" encoded in user exit session character set.

NOT NULL terminated.

DATE

31-May-11

2-byte null indicator +

2-byte length info +

column value

"2011-05-31" encoded in ASCII or EBCDIC.

NULL terminated.

"2011-05-31" encoded in user exit session character set.

NOT NULL terminated.

TIMESTAMP

31-May-11 12.00.00 AM

2-byte null indicator +

2-byte length info +

column value

"2011-05-31 12.00.00 AM" encoded in ASCII or EBCDIC.

NULL terminated.

"2011-05-31 12.00.00 AM" encoded in user exit session character set.

NOT NULL terminated.

Interval Year to Month or Interval Day to Second

2-byte null indicator +

2-byte length info +

column value

RAW

2-byte null indicator +

2-byte length info +

column value

2-byte null indicator +

2-byte length info +

column value

2-byte null indicator +

2-byte length info +

column value