%ClearCursor meta-SQL element

Syntax

%ClearCursor({program,section,step,action | ALL})

Description

Use the %ClearCursor function to recompile a reused statement and reset any STATIC %Bind variables.

When you use the %ClearCursor function, remember that:

  • The function must be located at the beginning of the statement.

  • %ClearCursor can be the only function or command contained in the statement.

Parameters

Parameter Description

program

Specify the name of the Application Engine program containing the reused statement you want to recompile.

section

Specify the name of the section containing the reused statement you want to recompile.

step

Specify the name of the step containing the reused statement you want to recompile.

action

Specify one of the following values:

  • D: Do Select.

  • H: Do When.

  • N: Do Until.

  • W: Do While.

  • S: SQL.

ALL

Clear all cursors in the current Application Engine program.