SYSIBM.SYSENVIRONMENT table

The SYSIBM.SYSENVIRONMENT table records the environment variables when an object is created.

Column name Data type Description Use
ENVID
INTEGER
NOT NULL
 Internal identifier of the environment. G
CURRENT_SCHEMA
VARCHAR(128)
NOT NULL
 The current schema. G
RELCREATED
CHAR(1)
NOT NULL
 The release when the environment information is created. SeeRelease dependency indicators for values. G
PATHSCHEMAS
VARCHAR(2048)
NOT NULL
 The schema path. G
APPLICATION_
ENCODING_CCSID
INTEGER
NOT NULL
 The CCSID of the application environment. G
ORIGINAL_
ENCODING_CCSID
INTEGER
NOT NULL
 The original CCSID of the statement text string. G
DECIMAL_POINT
CHAR(1)
NOT NULL
 The decimal point indicator:
C
Comma
P
Period
 G
MIN_DIVIDE_SCALE
CHAR(1)
NOT NULL
 The minimum divide scale:
N
The usual rules apply for decimal division in SQL
Y
Retain at lease three digits to the right of the decimal point after any decimal division.
 G
STRING_DELIMITER
CHAR(1)
NOT NULL
 The string delimiter that is used in COBOL string constants:
A
Apostrophe (')
Q
Quote (")
 G
SQL_STRING_
DELIMITER
CHAR(1)
NOT NULL
 The SQL string delimiter that is used in string constants:
A
Apostrophe (')
Q
Quote (")
 G
MIXED_DATA
CHAR(1)
NOT NULL
 Uses mixed DBCS data:
N
No mixed data
Y
Mixed data
 G
DECIMAL_
ARITHMETIC
CHAR(1)
NOT NULL
 The rules that are to be used for CURRENT PRECISION and when both operands in a decimal operation have a precision of 15 or less:
1
DEC15 specifies that the rules do not allow a precision greater than 15 digits
2
DEC31 specifies that the rules allow a precision of up to 31 digits
 G
DATE_FORMAT
CHAR(1)
NOT NULL
 The date format:
I
ISO - yyyy-mm-dd
J
JIS - yyyy-mm-dd
U
USA - mm/dd/yyyy
E
EUR - dd.mm.yyyy
L
Locally defined by an installation exit routine
 G
TIME_FORMAT
CHAR(1)
NOT NULL
 The time format:
I
ISO - hh.mm.ss
J
JIS - hh.mm.ss
U
USA - hh:mm AM or hh:mm PM
E
EUR - hh.mm.ss
L
Locally defined by an installation exit routine
 G
FLOAT_FORMAT
CHAR(1)
NOT NULL
 The floating point format:
I
IEEE floating point format
S
System/390® floating point format
 G
HOST_LANGUAGE
CHAR(8)
NOT NULL
 The host language:
  • ASM
  • C
  • CPP
  • IBMCOB
  • PLI
  • FORTRAN
 G
CHARSET
CHAR(1)
NOT NULL
 The character set:
A
Alphanumeric
 G
FOLD
CHAR(1)
NOT NULL
 FOLD is only applicable when HOST_LANGUAGE is C or CPP. Otherwise FOLD is blank.
N
Lower case letters in SBCS ordinary identifiers are not folded to uppercase
Y
Lower case letters in SBCS ordinary identifiers are folded to uppercase
blank
Not applicable
 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G
ROUNDING
CHAR(1)
NOT NULL
WITH DEFAULT
 The rounding mode that is used when arithmetic and casting operations are performed on DECFLOAT data:
C
ROUND_CEILING
D
ROUND_DOWN
F
ROUND_FLOOR
G
ROUND_HALF_DOWN
E
ROUND_HALF_EVEN
H
ROUND_HALF_UP
U
ROUND_UP
 G