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.6 CREATE-COMMAND Method

�¡Class

FJDB-DATABASE-class

�¡Function

Creates an object of the FJDB-COMMAND class to represent an SQL statement in the database.

�¡Syntax

INVOKE DATABASE-A "CREATE-COMMAND" USING SQL COMMAND-A 
                                    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 SQL statement.
Each dynamic parameter appearing in the SQL statement is designated with a question mark (?).

(Sample entry)
"UPDATE S1.T1 SET A=? WHERE A=?"

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

Specifies an object variable to store the object of the FJDB-COMMAND class.

�¡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 object of the FJDB-COMMAND class created is executed by using either an EXECUTE-COMMAND or OPEN-RECORDSET command.

If a CALL statement is specified, an object of the FJDB-COMMAND class that can be executed by the stored procedure is created. Specify all parameters of the stored procedure as dynamic parameters.

�¡’�ˆÓ

With an Oracle database, the OUT and INOUT parameters cannot be specified as dynamic parameters in the SQL statement.

Contents Index