Determine input parameters

You can use the DESCRIBE and DESCRIBE INPUT to return input parameter information for a prepared statement before it is executed.

The DESCRIBE INPUT statement returns the number, data types, size of the values, and the name of the column or expression that the query returns. The DESCRIBE INPUT statement can return parameter information for the following statements:
  • INSERT using WHERE clause
  • UPDATE using WHERE clause
  • SELECT with IN, BETWEEN, HAVING, and ON clauses.
  • SELECT subqueries
  • SELECT INTO TEMP
  • DELECT
  • EXECUTE