![]() Previous |
![]() Next |
The SQL CLOSE command closes a SQL cursor. You use the SQL OPEN command in combination with other SQL commands to copy data from relational tables into analytic workspace objects as outlined in "Copying Relational Data into Analytic Workspace Objects".
Syntax
SQL CLOSE cursor
Parameters
The name of a cursor previously opened with a SQL OPEN statement.
Usage Notes
Redefining the Result Set
You can change the result set associated with a cursor by closing the cursor, setting the value of an OLAP DML input expression, and issuing a new SQL OPEN statement. You do not have to free the cursor and redeclare it.