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-19
atp.SQL Object
Specify all values as strings. SQL null is represented by the JavaScript null
value.
transaction
You can provide a transaction object to protect the transaction performed by the
statement. The rules regarding when to specify transactions are the same as for
NonStop SQL/MP.
next(transaction)
This method, meaningful only if the statement type is SELECT, fetches one row into
the column_value property array. This method is equivalent to the SQL FETCH
operation.
This method returns the value false if there is a SQL error or there are no more
rows (sqlcode=100). Otherwise it returns the value true.
transaction
You can provide a transaction object to protect the transaction. The rules
regarding when to specify transactions are the same as for NonStop SQL/MP.
close(transaction)
For SELECT statements, the close() method closes the cursor. This method is
equivalent to the SQL CLOSE cursor operation. Open cursors are automatically
closed when ATP performs garbage collection occurs for the atp.SQL object.
However, the close() method lets you close the cursor in a timely way and allows
for a TMF transaction.
This method returns the value false if there is a SQL error; otherwise, it returns
the value true.
transaction
You can provide a transaction object to protect the transaction. The rules
regarding when to specify transactions are the same as for NonStop SQL/MP.
Note. ATP does not validate application data except to assure that adjacent data, for instance
an adjacent column, is not corrupted. Your application must validate input data for both type
and range. Invalid data will cause unpredictable results.