SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-22
SQLSADISPLAY
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
INT .EXT
is a pointer to the SQLSA structure. The TAL compiler automatically declares the
SQLSA structure when you specify the INCLUDE SQLSA directive.
sqlca^ input
INT .EXT
is a pointer to the SQLCA structure. The TAL compiler automatically declares the
SQLCA structure when you specify the INCLUDE SQLCA directive. The SQLCA
structure contains the procedure name and line number of the SQL statement that
set the SQLSA. If you omit the SQLCA name, the display does not contain the
procedure name and process name of the caller.
out^file^number input
INT
is the output file number. If you omit this value or set it to a negative value,
SQLDADISPLAY displays information at your home terminal. NonStop ignores this
parameter if detail^params specifies sequential I/O (SIO).
detail^params input
INT .EXT
determines whether the application uses SIO or Enscribe I/O (which is the default)
to write to the output file. detail^params points to a structure with this declaration:
STRUCT detail^params;
BEGIN
STRING sio;
INT .EXT out^fcb^1;
INT .EXT out^fcb^2 ;
END;
The fields in the detail^params structure are:
CALL SQLSADISPLAY ( sqlsa^ ! i
, [ sqlca^ ] ! i
, [ out^file^number ] ! i,o
, [ detail^params ] ) ; ! i