SQL Programming Manual for Pascal

NonStop SQL System Procedures

HP NonStop SQL Programming Manual for Pascal—528614-001

4-22

SQLSADISPLAY

The SQLSADISPLAY procedure displays the execution statistics of SQL statements.

However, SQLSADISPLAY does not display an SQLSA structure produced by a

PREPARE statement.

sqlsa input

EXTADDR

is a pointer to the SQLSA to be displayed. The SQLSA is included in the

program with the INCLUDE SQLSA directive.

sqlca input

EXTADDR

specifies the SQLCA that contains the procedure name and line number of the

SQL statement that set the SQLSA to be displayed. If the SQLCA name is not

included, the display will not contain the procedure name and process name of

the caller.

The SQLCA is declared automatically when you give the INCLUDE SQLCA

directive in the variable declarations part of the program.

out-file-num input

INT16

If you omit this value or set it to a negative value, SQLSADISPLAY displays

information at your home terminal. In this case, SQLSADISPLAY opens your

home terminal, displays the message, and then closes your terminal. NonStop

SQL ignores this parameter if detail_params specifies sequential I/O (SIO).

PROCEDURE SQLSADISPLAY TAL EXTENSIBLE

( sqlsa: EXTADDR;

OPTIONAL sqlca: EXTADDR;

OPTIONAL out_file_num: INT16;

OPTIONAL detail_params: EXTADDR );