38.6.2 Input data specification rules
-
Specify literals for the input data. For details about the description format of literals, see Description format of literals in the manual HADB SQL Reference.
-
An input data entry must end with a semicolon (;).
-
To assign the null value, specify NULL.
-
The maximum length of an input data entry is 64,000 bytes.
-
The type of literal that can be specified for an input data entry is determined by the data type assumed by the dynamic parameter. The following table shows the combinations that can be specified.
Table 38‒8: Combinations of the data type assumed by the dynamic parameter and the type of literal that can be specified for an input data entry Data type assumed by the dynamic parameter
Type of literal
Numeric literal
Character string literal
Date literal
Time literal
Time stamp literal
Binary literal#1
Numeric data
Y
N
N
N
N
Y
Character string data
N
Y
N
N
N
Y
Datetime data
DATE
N
Y#2
Y
N
Y
Y
TIME
N
Y
N
Y
TIMESTAMP
Y
N
Y
Y
Binary data
BINARY
N
N
N
N
Y
Y
VARBINARY
N
N
N
N
Y
Y
ROW
N
N
N
N
N
Y
- Legend:
-
Y: Can be specified.
N: Cannot be specified.
- #1
-
Either of the following can be specified for a binary literal:
• Hexadecimal character string literal
• Binary character string literal
The specification format for a hexadecimal character string literal is X'hexadecimal-character-string', and the specification format for a binary character string literal is B'binary-character-string'. When specifying the format, keep in mind the endian of the OS. The following shows specification examples:
Example of a hexadecimal character string literal: X'A000000000000000';
Example of a binary character string literal: B'01011100';
- #2
-
A character string literal that is specified in a predefined input representation can be specified. For details about the predefined input representations, see the topic Predefined character-string representations in the manual HADB SQL Reference.