11.4.1 Data types of variables usable in remote database access

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

ClassificationData type
Numeric dataINT[EGER]
SMALLINT
DEC[IMAL]
FLOAT
SMALLFLT
Character dataCHAR[ACTER]
VARCHAR
National character dataNCHAR
NVARCHAR
Mixed character dataMCHAR
MVARCHAR
Large-object dataBLOB

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.