38.6.3 Important points
-
If the data length of an input data entry is greater than length set for the dynamic parameter, an error results. If the fractional seconds precision for the input data is longer than that for the dynamic parameter, the input data will be truncated.
-
If the data length of an input data entry is less than the length set for the dynamic parameter, the data is initialized to the value shown in the following table and then the data is assigned.
Table 38‒9: Data type of input data and the value after initialization No.
Data type of input data
Value after initialization
1
CHAR
Space (X'20')
2
INTEGER
0
3
SMALLINT
0
4
DECIMAL
0
5
DOUBLE PRECISION
0
6
DATE
0
7
TIME
0
8
TIMESTAMP
0
9
BINARY
0
10
ROW
0