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.1 Classes

6.1.3 FJDB-COMMAND Class

”Methods

• BIND-PARAMETERS
• EXECUTE-COMMAND
• GET-NAME
• GET-SQL
• OPEN-RECORDSET
• SET-NAME

”Function

The FJDB-COMMAND class represents an SQL statement.

”Explanation

Objects of the FJDB-COMMAND class are created using the CREATE-COMMAND method or CREATE-OBJECT method in the FJDB-DATABASE class.

[Creating an object of the FJDB-COMMAND class]

(Using a CREATE-COMMAND method)

INVOKE DATABASE-A "CREATE-COMMAND" USING SQL COMMAND-A
                                    RETURNING RET-CODE.

For more information on creating an object of the FJDB-COMMAND class using a CREATE-COMMAND method, see CREATE-COMMAND Method.

iUsing a CREATE-OBJECT methodj

INVOKE FJDB-COMMAND "CREATE-OBJECT" USING SQL DSN UID PWD OPT ERROR-A
                                     RETURNING COMMAND-A.

For more information on creating an object of the FJDB-COMMAND class using a CREATE-OBJECT method, see Creating an Object of the FJDB-COMMAND Class.

Objects of the FJDB-COMMAND class contain an SQL statement, which can be executed by using an EXECUTE-COMMAND or OPEN-RECORDSET method.
When SQL statements varying only in parameter values are issued, the second and subsequent SQL statements can be executed using objects of the FJDB-COMMAND class without having to compile them.

Contents Index