SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-6
SQLCADISPLAY
suffix^len input
INT
specifies the length of the suffix string to append to each output line; the length can be
an integer value from 1 through 15. If you include the suffix parameter, you must also
include this parameter. If you omit the suffix parameter, you must also omit this
parameter.
detail^params input
INT .EXT
determines whether the program uses sequential SIO (SIO) or Enscribe I/O (which
is the default) for writing to the output file. The parameter 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;
sio
specifies whether sequential I/O is used; sio can have these values:
Y Use sequential I/O; ignore output^file^number.
N Do not use sequential I/O; write to output^file^number.
outfcb1
specifies the first output file control block if sio is enabled.
outfcb2
specifies the second output file control block if sio is enabled. To use outfcb2,
assign it a value greater than 0.
Guidelines
Follow these guidelines when you call the SQLCADISPLAY procedure:
•
NonStop SQL returns errors as negative numbers and warnings as positive
numbers.
•
If there is no text for an error number, NonStop SQL displays:
No error text found.
The $SYSTEM.SYSTEM.SQLMSG file contains the error text for SQL messages. If
you receive this message, your version of the SQLMSG file might not match the
version of the SQL executor.