Progress
DataServer for
Microsoft SQL Server
Guide


PROC–STATUS Function

SYNTAX

PROC-STATUS 

EXAMPLE

This procedure runs the stored procedure pcust and writes the results of the stored procedure into the Progress-supplied buffer, proc–text–buffer. The CLOSE STORED–PROCEDURE statement then retrieves the output parameters. The return status is written to the variable stat and is displayed as:

DEFINE VAR stat AS INTEGER.

RUN STORED-PROCEDURE pcust (10, OUTPUT 0, OUTPUT 0).
FOR EACH proc-text-buffer:
END.
CLOSE STORED-PROCEDURE pcust stat = PROC-STATUS.
  DISPLAY stat. 

NOTE: For descriptions of the possible values for the return status of a non-Progress stored procedure, see your non-Progress documentation.

SEE ALSO

CLOSE STORED–PROCEDURE Statement, PROC–HANDLE Function, RUN STORED–PROCEDURE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095