A tabela SYSENVIRONMENT registra as variáveis de ambiente quando um objeto é criado.
O esquema é SYSIBM.
The SYSENVIRONMENT table records the environment variables when an object is created.
The schema is SYSIBM.
| 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
- JAVA
- 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 |
| CREATEDTS |
TIMESTAMP(12) NOT NULL |
The time when the row was inserted. |
G |
| APPLCOMPAT |
VARCHAR(10) NOT NULL WITH DEFAULT |
The application compatibility level that is associated with this environment.
- function-level
- Specifies the application compatibility behavior of the function-level function level.
The equivalent function level or higher must be activated.
The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level. For example:
- V12R1M507
- Identifies compatibility with the current highest available function level, function level 507.
- V12R1M500
- Identifies compatibility with the function level that enables new function in the initial Db2 12 release, function level 500.
V12R1M500 is the same as V12R1.
- V12R1M100
- Identifies compatibility with the function level before you activate new function, after migration to Db2 12, function level 100.
V12R1M100 is the same as V11R1.
For a list of supported function-level values, see What's new in Db2 12 function levels.
- V11R1
- Specifies Db2 11 compatibility behavior.
- V10R1
- Specifies Db2 10 compatibility behavior.
|
G |
