SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-3
SQLCADISPLAY
•
Disk process (DP2)
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.
output^file^number input
INT
is the output file number. If you omit this value or set it to a negative value,
SQLCADISPLAY displays information at your home terminal. In this case,
SQLCADISPLAY opens your home terminal, displays the message, and then
closes your terminal. NonStop ignores this parameter if detail^params specifies
sequential I/O (SIO).
output^record^length input
INT
defines the length in bytes of records to be written to the output file. The length
must be an integer value from 60 through 600. The default length is 79 bytes.
sql^msg^file^number input/output
INT
is the file number of the SQLMSG file. If you specify –1 on input, the system opens
the SQLMSG file and returns the resulting file number. If you specify a value other
than –1, the system uses that value as the file number of the SQLMSG file.
To improve the performance of a program that makes multiple calls to the
SQLCADISPLAY (or SQLCATOBUFFER) procedure, specify a variable containing
–1 on the first call, and then use the returned file number for subsequent calls. By
CALL SQLCADISPLAY ( sqlca^ ! i
, [ output^file number ] ! i
, [ output^record^length ] ! i
, [ sql^msg^file^number ] ! i,o
, [ errors ] ! i
, [ warnings ] ! i
, [ statistics ] ! i
, [ caller^error^loc ] ! i
, [ internal^error^loc ] ! i
, [ prefix ] ! i
, [ prefix^length ] ! i
, [ suffix ] ! i
, [ suffix^length ] ! i
, [ detail^params ] ) ; ! i