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

ATP Examples
iTP Active Transaction Pages (iTP ATP) Programmer’s Guide—522292-002
F-4
General-Purpose Functions in ATP Examples
General-Purpose Functions in ATP Examples
Table 6-2 lists functions defined in the example scripts provided on the ATP CD. This
list isn’t complete: however, it includes the functions applicable to a wide range of
applications. You can copy and modify these functions for use in your own scripts.
Some functions are associated with specific objects defined in the examples. These
objects are not part of the standard ATP interface; they are on the product CD to give
you ideas for your own scripts.
File locations are relative to the directory /usr/tandem/atp.
Note. Compaq does not represent the ATP example programs as complete or suitable for
production use.
Table 6-2. Functions Defined in ATP Examples (page 1 of 3)
Function Name What It Does Where to Find It
The following functions are defined for the
SQLQuery object
doSQLClose Closes an SQL object and the
related transaction object, if
present. Reports an SQL
error if appropriate.
examples/sql_tools/explorer/isql.inc
doSQLColumnValue
(col)
Returns a value from the
SQL object column_value
array.
examples/sql_tools/explorer/isql.inc
doSQLError () Displays a message reporting
an SQL error.
examples/sql_tools/explorer/isql.inc
doSQLGetSQLcode
()
Returns the SQL error code. examples/sql_tools/explorer/isql.inc
doSQLNext () Reads an SQL table, stopping
when there are no more rows
or when an error occurs.
examples/sql_tools/explorer/isql.inc
doSQLPrintColumnV
alue (col)
Prints a value from the SQL
object column_values array.
examples/sql_tools/explorer/isql.inc
doTMFcommit () Commits a transaction and
reports an error if
appropriate.
examples/sql_tools/explorer/isql.inc
doTMFrollback () Rolls back a transaction and
reports an error, if
appropriate.
examples/sql_tools/explorer/isql.inc
SQLBuildExecute
(query)
Builds and executes an SQL
query, using parameters from
the request. Optionally
specifies a transaction.
examples/sql_tools/explorer/isql.inc
SQLError (stmt) Prints an SQL error. examples/sql/acct_list/acct_list.atp