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.