SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-14
SQLCATOBUFFER
•
NonStop SQL
•
FASTSORT program (SORTPROG process)
•
Sequential I/O (SIO) procedures
•
File system
•
NonStop Kernel operating system
•
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^buffer input/output
STRING .EXT
specifies the buffer name where SQLCATOBUFFER writes the error information.
output^buffer^length input
INT
specifies the length of output^buffer in bytes. This length must be:
•
An integer value from output^record^length through 600
•
A multiple of output^record^length
The recommended minimum length is 300 bytes.
CALL SQLCATOBUFFER ( sqlca ! i
, output^buffer ! i,o
, output^buffer^length ! i
, [ first^output^record ] ! i
, [ output^records ] ! o
, [ more ] ! o
, [ 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