Describing a Statement with Runtime Parameters
- EXECUTE FUNCTION (or EXECUTE PROCEDURE)
- INSERT
- SELECT (without an INTO TEMP clause)
- UPDATE
In HCL OneDB™, the IFX_UPDDESC environment variable, as described in the HCL OneDB Guide to SQL: Reference, must be set before you can use DESCRIBE to obtain information about an UPDATE statement.
- The data type of the column, as defined in the table
- The length of the column, in bytes
- The name of the column or expression
For a prepared INSERT or UPDATE statement, DESCRIBE returns only
the dynamic parameters (those expressed with a question mark (?
)
symbol). Using the OUTPUT keyword, however, prevents these from being
returned.
You can specify a destination for the returned information as a new or existing system-descriptor area, or as a pointer to an sqlda structure.
A system-descriptor area conforms to the X/Open standards.