Developing Portable Applications : 2. Achieving Transparency and Portability : Repeated Queries : Repeated Query Format
 
Share this page                  
Repeated Query Format
To use a repeated query, preface the query statement with the keyword repeated.
Example: (in embedded SQL)
exec sql repeated insert into table2 (col1, col2) values (:ivar,:cvar);
Note:  Repeated queries are only available in embedded SQL, OpenROAD, and Open API user interfaces.