Open SQL Statement Step

After you open a database, use an Open SQL Statement step to select the set of data with which to work. An Open SQL Statement step returns a statement handle you can use in Data Operation steps.

Configuring the Step

Use the Edit Open SQL Statement dialog box in the TestStand Sequence Editor or in a TestStand User Interface to configure the Open SQL Statement step.

Step Properties

In addition to the common custom properties , the Open SQL Statement step type defines the following step properties:

  • Step.PageSize —The number of records in a page for the SQL statement.
  • Step.CommandTimeout —The amount of time, in seconds, TestStand waits while attempting to issue a command to the open database connection.
  • Step.CacheSize —The cache size for the SQL statement.
  • Step.MaxRecordsToSelect —The maximum number of records the SQL statement can return.
  • Step.CursorType —The cursor type the SQL statement uses.
  • Step.CursorLocation —Specifies where the data source maintains cursors for a connection.
  • Step.MarshalOptions —The marshal options for the updated records in the SQL statement.
  • Step.LockType —The lock type for the records the SQL statement selects.
  • Step.CommandType —The command type of the SQL statement.
  • Step.DatabaseHandle —The name of the variable or property that contains the database handle with which you open the SQL statement.
  • Step.StatementHandle —The numeric variable or property the step type assigned as the value of the SQL statement handle.
  • Step.SQLStatement —A string expression that contains the SQL command.
  • Step.NumberOfRecordsSelected —The numeric variable or property to which the step assigns the number of records the SQL statement returns.
  • Step.RequiresParameters —Specifies whether the SQL statement requires input or output parameters to execute. When this property is False , the step immediately executes the SQL statement. When this property is True , the step only prepares the SQL statement, and a subsequent Data Operation step must perform an Execute operation that defines the parameters for the statement.

See Also

Database Step Types