DESCRIBE — obtain information about a prepared statement or result set
DESCRIBE [ OUTPUT ]prepared_nameUSING [ SQL ] DESCRIPTORdescriptor_nameDESCRIBE [ OUTPUT ]prepared_nameINTO [ SQL ] DESCRIPTORdescriptor_nameDESCRIBE [ OUTPUT ]prepared_nameINTOsqlda_name
DESCRIBE retrieves metadata information about the result columns contained in a prepared statement, without actually fetching a row.
prepared_nameThe name of a prepared statement. This can be an SQL identifier or a host variable.
descriptor_nameA descriptor name. It is case sensitive. It can be an SQL identifier or a host variable.
sqlda_nameThe name of an SQLDA variable.
EXEC SQL ALLOCATE DESCRIPTOR mydesc; EXEC SQL PREPARE stmt1 FROM :sql_stmt; EXEC SQL DESCRIBE stmt1 INTO SQL DESCRIPTOR mydesc; EXEC SQL GET DESCRIPTOR mydesc VALUE 1 :charvar = NAME; EXEC SQL DEALLOCATE DESCRIPTOR mydesc;
DESCRIBE is specified in the SQL standard.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.