DB Access Class Library for COBOL V1.0 API Reference - Microsoft(R) Windows(R) - - Microsoft(R) Windows NT(R) - - Microsoft(R) Windows(R) 2000 -

Contents Index

Chapter 6 DB Access Library API Reference

6.2 Methods

6.2.9 EXECUTE-COMMAND Method

�¡Class

FJDB-COMMAND-class

�¡Function

Executes the SQL statement defined on an object of the FJDB-COMMAND class.

The stored procedure can be executed by using an EXECUTE-COMMAND method for an object of the FJDB-COMMAND class having a CALL statement defined.

�¡Syntax

INVOKE COMMAND-A "EXECUTE-COMMAND" USING ROW-COUNT  RETURNING RET-CODE.

�¡Object identifier

COMMAND-A [attribute:OBJECT REFERENCE FJDB-COMMAND]

Specifies an object of the FJDB-COMMAND class.

�¡Argument

ROW-COUNT [attribute:S9(9) COMP-5]

A count of the number of rows that have been updated is returned.

�¡Return value

RET-CODE [attribute:S9(9) COMP-5]

Returns a value of 0 if the method ends normally; otherwise, returns an error code.

�¡Explanation

The EXECUTE-COMMAND method can be executed for a real or view table.

The EXECUTE-COMMAND method cannot be executed when a SELECT statement is defined as an object of the FJDB-COMMAND class.

Once an ADD-NEW-RECORD or EDIT-RECORD method is issued, an EXECUTE-COMMAND method cannot be issued to the same database before an UPDATE-RECORD method is issued.

The EXECUTE-COMMAND method cannot be executed for the same resource while the recordset is being used. (See "11.1 Notes on updating recordset rows.")

If dynamic parameters are specified, they are loaded with values when the EXECUTE-COMMAND method is executed.

Contents Index