Returns the return status from an ODBC stored procedure. The return status is an integer value that indicates whether a stored procedure failed and why it failed. See your ODBC data-source documentation for descriptions of the possible values for the return status.
Syntax
PROC-STATUS
Example
This procedure runs the stored procedure pcust and writes the results of the stored procedure into the ABL buffer, proc–text–buffer. The CLOSE STORED–PROCEDURE statement then retrieves the output parameters. The return status is written to the variable iStat and is displayed:
DEFINE VARIABLE iStat AS INTEGER NO-UNDO.
RUN STORED-PROCEDURE pcust (10, OUTPUT 0, OUTPUT 0).
FOR EACH proc-text-buffer:
DISPLAY proc-text-buffer.
END.
CLOSE STORED-PROCEDURE pcust iStat = PROC-STATUS.
DISPLAY stat.