SQL/MP Programming Manual for C

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
5-20
SQLSADISPLAY
node_number
is the node number of the system for which you are requesting information. The
default is the local system.
sql_version
is the SQL/MP software version for the specified system. For information about
versions of NonStop SQL/MP, see the SQL/MP Version Management Guide.
SQLSADISPLAY
The SQLSADISPLAY procedure displays the execution statistics of SQL statements in
tabular form.
Because the PREPARE statement continually redefines the fields of the SQLSA
structure during the execution of dynamic SQL statements, SQLSADISPLAY does not
display an SQLSA structure returned by a PREPARE statement.
sqlsa
is a pointer to the SQLSA structure. The C compiler automatically declares the
SQLSA structure when you specify the INCLUDE SQLSA directive.
sqlca
is a pointer to the SQLCA structure. The SQLCA structure contains the procedure
name and line number of the SQL statement that sets the SQLSA structure. The
#include <cextdecs(SQLGETSYSTEMVERSION)>
short SQLGETSYSTEMVERSION (
[ short node_number ] , /* i */
short *sql_version /* o */
);
Note. Although version 340 SQL/MP software supports the SQLGETSYSTEMVERSION
procedure, HP might not support this procedure in a future RVU. If you are running version 300
(or later) SQL/MP software, use the GET VERSION OF SYSTEM statement to return the
version of a system. For information about this statement, see the SQL/MP Reference Manual.
#include <cextdecs(SQLSADISPLAY)>
void SQLSADISPLAY (
short *sqlsa, /* i */
[ short *sqlca, ] /* i */
[ short output_file_number , ] /* i */
[ short *detail_params ] /* i */
);