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 PreviousNext

UpChapter 4 Examples of Using the DB Access Class Library

4.2 Use an Object of the FJDB-COMMAND Class


A sample program that uses an object (recordset) of the FJDB-COMMAND class to manipulate data is provided along with coding instructions. For summary information on the programmed operation, see Data Update Example.

With an object of the FJDB-COMMAND class and a bind table, the user can repeatedly execute the same SQL statement by specifying only dynamic parameter values at run time. Using an object of the FJDB-COMMAND class saves time otherwise needed to compile the second and subsequent SQL statements.

The workflow of the program is shown below.
The programmed operations of Create an object of the FJDB-SESSION class and Connect to a database in this flow are similar to those described in Use a Recordset.


image



Down4.2.1 Create a bind table to handle dynamic parameters
Down4.2.2 Execute an SQL statement by using an object of the FJDB-COMMAND class

Contents Index PreviousNext

All Rights Reserved, Copyright (C) Alchemy Solutions Inc. 1998-2000