Not a working sample, but some snippets and reminders. For each value to pass (your parameter marker you have to fill an SQL_VAR element in the array (DIM is just example). Use DS SQLVAR for this. SQLTYPE should have an integer value for each data type. The SQLLEN is the length of the used host variable, except for packed and zoned fields; those have the value (256 * number of digits) + number of decimals. A packed field, defined as 30 9 (9 decimals) get the length of: (256 * 30) + 9. SQLDATA gets the address of the host variable the value is stored. See the SQL Reference Manual, appendix C. Hopes this help. Regards, Carel Teijgeler
Code
Code
Comment