SQL Statement Tab

The SQL Statement tab contains the following options:

• Database Handle (Number) —The name of the variable or property that contains the database handle you obtain from an Open Database step. The variable or property is of the Number data type.
• Statement Handle (Number) —A variable or property to which the step assigns the value of the SQL statement handle. The variable or property is of the Number data type. If you leave the control blank, the step automatically releases the SQL statement handle after executing the step. You must release this handle by calling a Close SQL Statement step and using this handle value as the handle to close.
• SQL Statement —The SQL statement the step opens. You can specify the SQL statement as a literal string or as an expression TestStand evaluates at run time. Click Build to construct the SQL statement.
  Note

  • When you set the Command Type control on the Advanced tab to "Stored Procedure," specify the name of the stored procedure in quotes in the SQL Statement field.
  • You cannot use the Build button to edit an existing SQL statement expression .
• Build —Launches the Build SQL Select Statement dialog box, in which you can construct an SQL select statement.
• Number of Records Selected (optional) —A variable or property to which the step assigns the number of records the SQL statement returns. The variable or property is of the Number data type.
• Statement Requires Parameters —Specifies whether the SQL statement requires input or output parameters. If it does not require input or output parameters, the step immediately executes the SQL statement. If it does require input or output parameters, the step prepares only the SQL statement and a subsequent Data Operation step must perform an Execute Operation that defines the parameters for the statement.

See Also

Build SQL Select Statement dialog box

Structure Query Language (SQL)