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.10 EXECUTE-SQL Method

�¡Class

FJDB-DATABASE-class

�¡Function

Executes the SQL statement specified for a table.

�¡Syntax

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

�¡Object identifier

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

Specifies an object of the FJDB-DATABASE class.

�¡Argument

SQL[attribute:X(nn) nn is an area length]

Enters an update SQL statement directed at the database.

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-SQL method can be executed for a real or view table.

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

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

Contents Index