recordset

Command: RECORDSET

description:

run a SQL query and store the results as a recordset in memory. this recordset can be accessed and used by other commands such as the iterate command.

NOTE: large query results will fill up your local memory! be mindful of how much data you pull by using a TOP or LIMIT clauses in your SQL query.

also note that you should not create a recordset with the same name as a session variable because this will lead to incorrect parsing.

parameters:

• required - recordset name

behavior:

• SQL query will be executed
• query results will be stored in memory as a named recordset

examples:

 /*-recordset rs-*/
 select a, b from table_name limit 100;