• User-defined data types cannot be specified in embedded variable declarations (that is, in embedded SQL declaration clauses).
• If the table column to be retrieved contains an abstract data type, no column can be specified in the selection expression of the SELECT statement.
• When embedded variables are specified in function arguments, the specifications must match the actual argument data types of the function used. If the embedded variable specifications and the argument data types in the function do not match, that function cannot be used.
  To determine the argument data types of a function, retrieve the SQL_ROUTINE_PARAMS dictionary table. For details about how to retrieve a dictionary table, see F.1 Examples of SQL statements for retrieval.
  

Note

An embedded variable cannot be used if the ROW data type is specified in a function argument.

When literals are used in function arguments, the literals must match the actual argument data types of the function used. For example, if the data type of a function argument is SMALLINT, and an integer literal is specified, the literal does not match the data type. If another function has the same name, the same number of arguments, and an argument with the integer type, that function may be used instead.

Literals cannot be used in function arguments that have one of the following data types specified:

• SMALLINT
• SMALLFLT
• CHAR
• NCHAR
• MCHAR
• DATE
• TIME
• TIMESTAMP
• INTERVAL YEAR TO DAY
• INTERVAL HOUR TO SECOND
• ROW
• BLOB
• BINARY