In order to use a variable during access to a remote database, its data type must be supported by the distributed client facility. Table 11-6 lists the data types of variables that are supported by the distributed client facility.
Table 11-6 Data types of variables supported by distributed client facility
Classification | Data type |
---|---|
Numeric data | INT[EGER] |
SMALLINT | |
DEC[IMAL] | |
FLOAT | |
SMALLFLT | |
Character data | CHAR[ACTER] |
VARCHAR | |
National character data | NCHAR |
NVARCHAR | |
Mixed character data | MCHAR |
MVARCHAR | |
Large-object data | BLOB |
Variables of the following data types are not supported by the distributed client facility and cannot be used: date data type (DATE), time data type (TIME), date interval data type (INTERVAL YEAR TO DAY), time interval data type (INTERVAL HOUR TO SECOND), and ROW.