PL/I host variables in SQL statements must be type compatible with the columns that use them:
- Numeric data types are compatible with each other. A SMALLINT, INTEGER, DECIMAL, or FLOAT column is compatible with a PL/I
host variable of BIN FIXED(15), BIN FIXED(31), DECIMAL(p,s), or BIN FLOAT(n), where 24 ≤ n ≤ 53.
- Character data types are compatible with each other. A CHAR or VARCHAR column is compatible with a fixed-length or varying-length
PL/I character host variable. When necessary, the Database Manager automatically converts a fixed-length character string
to a varying-length string or a varying-length string to a fixed-length string.
- Datetime data types are compatible with character host variables. A DATE, TIME, or TIMESTAMP column is compatible with a fixed-length
or varying-length PL/I character host variable.