OpenAPI User Guide > OpenAPI User Guide > Using Repeat Queries with OpenAPI > Repeat Query Parameters > Example: Repeat query using the $n = ~V marker
Was this helpful?
Example: Repeat query using the $n = ~V marker
The query from the previous section, if used as a repeat query would be:
select * from employee where dept = $0 = ~V and age > $1 = ~V
When implementing repeat queries, parameter values must be sent when the repeat query is defined, as well as when the query is invoked. Query text is not sent when a repeat query is invoked, but the parameters sent at invocation must be in the same order as when the repeat query was defined.
More information:
 
Last modified date: 11/09/2022