iTP Active Transaction Pages (iTP ATP) Programmer's Guide

ATP Objects, Properties, and Methods
iTP Active Transaction Pages (iTP ATP) Programmer’s Guide—522292-002
4-18
atp.SQL Object
statement_type (read-only)
This property contains a code indicating the type of SQL statement represented by
the atp.SQL object. The codes are:
This value comes from the SQLSA structure, which contains human-readable
statistics information related to the query or table. See the NonStop SQL/MP manual
set for detailed information about the SQLDA structure.
records_accessed (read-only)
This property contains a cumulative statistic for the atp.SQL object. The count
includes all tables used by the query. This value is aggregated from the SQLSA on
every SQL operation.
records_used (read-only)
This property contains a cumulative statistic for the atp.SQL object. Count
includes all tables used by the query. This value is aggregated from the SQLSA on
every SQL operation.
Methods
execute(value1, ...., transaction)
For SELECT statements, the execute() method opens a cursor. For other
statements, this method causes the execution of the other statements. This method is
equivalent to the SQL OPEN cursor operation.
This method returns the value false if there is a SQL error; otherwise, it returns
the value true.
value1, ...
Parameter values are substituted in order into the placeholders in the SQL
statement, as shown in atp.SQL Object Usage Considerations. There must be
one parameter for each placeholder; no defaults are defined. (If you don’t
specify one parameter for each placeholder, ATP displays an error message.)
Code Number SQL Statement
1 SELECT
2INSERT
3UPDATE
4 DELETE
5 DDL - any non-control statement, such as CREATE
6 CONTROL
7DCL
8GET