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

17.8. Operator perform the prepared statement

Lecture



  <execute statement> :: =
    EXECUTE <SQL statement name>
  (<result using clause>]
  (<parameter using clause>]
 <result using clause> :: = <using clause>
 <parameter using clause> :: = <using clause> 

Comment:

The EXECUTE statement can be applied to any previously prepared SQL statement, except for <dynamic select statement>. If it is a <dynamic single row select statement> statement, then the EXECUTE statement must contain a <result using class> section with the INTO keyword. In any case, the number of actual parameters specified through using sections must match the number of formal parameters defined in the prepared SQL statement.


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