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

17.5. Training operator

Lecture



  <prepare statement> :: =
    PREPARE <SQL statement name>
    FROM <SQL statement variable>
 <SQL statement variable> :: = <simple target specification>
 <preparable statement> :: =
   <preparable SQL data statement>
 |  <preparable SQL schema statement>
 |  <preparable SQL transaction statement>
 |  <preparable SQL session statement>
 |  <preparable implementation-defined statement>
 <preparable SQL data statement> :: =
   <delete statement: searched>
 |  <dynamic single row select statement>
 |  <insert statement>
 |  <dynamic select statement>
 |  <update statement: searched>
 |  <preparable dynamic delete statement: positioned>
 |  <preparable dynamic update statement: positioned>
 <preparable SQL schema statement> :: = <SQL schema statement>
 <preparable SQL transaction statement> :: = <SQL transaction statement>
 <preparable SQL session statement> :: = <SQL session statement>
 <dynamic select statement> :: = <cursor specification>
 <dynamic simple row select statement> :: = <query specification>
 <SQL statement name> :: = <statement name> |  <extended statement name>
 <extended statement name> :: = [scope option] <simple value specification>
 <cursor specification> :: =
   <query expression> [<order by clause>]
   [<updatability clause>]
 <updatability clause> :: =
    FOR {READ ONLY |  UPDATE [OF <column name list>]}
 <query expression> :: =
   <non-join query expression>
 |  <joined table>
 <query specification> :: =
    SELECT [<set quantifier>]
   <select list> <table expression>
 <set quantifier> :: = DISTINCT |  ALL 

Comment:

The PREPARE statement causes the compilation and construction of the execution plan of the SQL statement specified in the text form. After the successful execution of the PREPARE statement, the specified (literally or indirectly) name of this statement is associated with the prepared statement, which can then be used in the DESCRIBE, EXECUTE, OPEN CURSOR, ALLOCATE CURSOR and DEALLOCATE PREPARE statements. This association is maintained until the DEALLOCATE PREPARE statement is executed explicitly.


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