Lecture
<describe statement> :: =
<describe input statement>
| <describe output statement>
<describe input statement> :: =
DESCRIBE INPUT <SQL statement name> <using descriptor>
<describe output statement> :: =
DESCRIBE [OUTPUT] <SQL statement name> <using descriptor>
<using clause> :: = <using arguments> | <using descriptor>
<using arguments> :: =
{USING | INTO} <argument> [{<comma> <argument>} ...]
<argument> :: = <target specification>
<using descriptor> :: =
{USING | INTO} SQL DESCRIPTOR <descriptor name>
<target specification> :: =
<parameter specification>
| <variable specification>
<parameter specification> :: =
<parameter name> [<indicator parameter>]
<indicator parameter> :: = [INDICATOR] <parameter name>
<variable specification> :: =
<embedded variable name> [<indicator variable>]
<indicator variable> :: = [INDICATOR] <embedded variable name> Comment:
When the DESCRIBE statement is executed, the descriptor specified in the statement descriptor is filled with information describing either the result of a previously prepared SQL statement (if it is a select statement) or the number and types of parameters of the prepared statement. In <using descriptor> here it is supposed to write USING SQL DESCRIPTOR.
Comments
To leave a comment
Databases IBM System R - relational DBMS
Terms: Databases IBM System R - relational DBMS