You get a bonus - 1 coin for daily activity. Now you have 1 coin

17.7. Operator request query description of the prepared operator

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
If you have any suggestion, idea, thanks or comment, feel free to write. We really value feedback and are glad to hear your opinion.
To reply

Databases IBM System R - relational DBMS

Terms: Databases IBM System R - relational DBMS