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-17
atp.SQL Object
row_print_format
This property, if set, contains a string that describes the format in which to print
rows of a table. If you use this property, the next() method retrieves and prints a
row without placing the data in the column_value array and without requiring
your script to invoke print functions explicitly. This option reduces CPU and
memory use and can therefore greatly improve performance, especially if your script
retrieves and prints many rows of data (for example, more than 5000 rows).
The string follows C language printf conventions and can contain a combination
of text and HTML. Use the notation %s to represent the position of each column in
the format, regardless of the data type of the column in the table. For example:
s1.row_print_format="<tr><td>%s</td><td>%s</td><td>%s</td></tr>"
To include the symbol % in the output, use the notation %%.
variables (read-only)
This array contains the variable name of each variable (designated with ?) in the
SQL query. Subscripts are numeric.
cursor_name (read-only)
If the atp.SQL object represents a SELECT statement, this property contains the
cursor name. The atp.SQL execute() method establishes the name. All
SELECT statements have cursors, even if only one row is returned or expected. This
property has no significance for other types of SQL statements.
sqlcode (read-only)
This error number is set by the atp.SQL constructor and the execute(),
next(), and close() methods. Positive numbers are warnings (100 is No More
Rows), negative numbers are errors, and 0 means success. For descriptions of the
errors, see the NonStop SQL/MP manual set.
filesystem_error (read-only)
This property contains an operating-system error number. The value is set by the
atp.SQL constructor and the execute(), next(), and close() methods.
sqlca (read-only)
This text representation of the SQLCA structure is set by the atp.SQL constructor
and the execute(), next(), and close() methods. This structure contains
human-readable diagnostic information, including a text error message. See the
NonStop SQL/MP manual set for detailed information about the SQLCA structure.