dbrpcsend

Sends a single stored procedure, a single remote stored procedure, or batch of stored procedures and/or remote stored procedures to SQL Server to be executed.

Syntax

RETCODE dbrpcsend ( PDBPROCESS dbproc );

where

dbproc

Is the DBPROCESS structure that is the handle for a particular workstation/ SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

Returns

SUCCEED or FAIL.

Remarks

After initializing and setting up each stored procedure using dbrpcinit and dbrpcparam, call dbrpcsend to send the stored procedure or batch of stored procedures to SQL Server. Then call dbsqlok before processing the stored procedure results. For more information about executing stored procedures using DB-Library functions, see "dbrpcinit."

See Also

dbnextrow, dbresults, dbretdata, dbretstatus, dbrpcinit, dbrpcparam, dbsqlok