LOAD FORMAT DELIMITED IMPLICIT DECIMAL SCALE (LOAD_DEL_IMPLICIT_SCALE subsystem parameter)
The LOAD_DEL_IMPLICIT_SCALE subsystem parameter specifies how LOAD FORMAT DELIMITED processes decimal data when a decimal point is not specified.
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| Update: | option 37 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM LOAD_DEL_IMPLICIT_SCALE |
The following values are supported:
- NO
- LOAD FORMAT DELIMITED interprets decimal data, without a decimal point specified, with an implied decimal point after the rightmost digit of the number. NO is the default value.
- YES
- LOAD FORMAT DELIMITED interprets decimal data, without a decimal point specified, with an implied decimal point based on the scale specified in the field specification of the LOAD utility
Example
Assume that you run following LOAD utility statement with input string 1234567890.
LOAD FORMAT DELIMITED … (DEC1 POSITION(*) DECIMAL EXTERNAL(10,2) )The following table shows how the LOAD utility interprets the example input value based on the LOAD_DEL_IMPLICIT_SCALE subsystem parameter setting.
| LOAD_DEL_IMPLICIT_SCALE setting | How LOAD interprets the input value |
|---|---|
| YES | LOAD uses the scale of 2 from the field specification and interprets the number to load as 12345678.90. The resulting decimal value fits in the target column, and the LOAD succeeds. |
| NO | LOAD uses an implied decimal point at the end of the number and a scale of 2 and tries to load 1234567890.00. The resulting decimal value is too large for the target column, so LOAD issues message DSNU333I because the input value is out of range. |
