Logo

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


Before using this online manual

Introduction

Chapter 1 What is the DB Access Class Library?
  1.1 What is the DB Access Class Library?
  1.2 Kinds of Databases Supported
  1.3 Mode of Connection
    1.3.1 Local Access 
    1.3.2 Remote Access
  1.4 Hierarchical Relationships among Classes

Chapter 2 Configuring the DB Access Class Library
  2.1 How to configure the DB Access Class Library
  2.2 Configuring the Operating Environment
  2.3 Configuring the Database Environment
    2.3.1 Database Environment Configuration Dialog Box

Chapter 3 Developing Applications
  3.1 Creating Programs
  3.2 Compiling Programs
  3.3 Linking Objects
  3.4 Executing Applications

Chapter 4 Examples of Using the DB Access Class Library
  4.1 Use a Recordset
    4.1.1 Create an object of the FJDB-SESSION class
    4.1.2 Connect to a database
    4.1.3 Create a bind table to handle data in the recordset
    4.1.4 Reference data using a recordset
      4.1.4.1 Data Reference Example (Using a recordset to reference data) 
    4.1.5 Update data using a recordset
      4.1.5.1 Data Update Example (Using a recordset to update data) 
  4.2 Use an Object of the FJDB-COMMAND Class 
    4.2.1 Create a bind table to handle dynamic parameters
    4.2.2 Execute an SQL statement by using an object of the FJDB-COMMAND class
      4.2.2.1 Data Update Example (Using an object of the FJDB-COMMAND class to execute an SQL statement)
  4.3 Execute an SQL Statement Directly
    4.3.1 Execute an SQL statement to update data
  4.4 Procedure Pertaining to Error Information (Exception Object)
  4.5 Object Recovery Procedure

Chapter 5 Logging Feature
  5.1 About Logging Feature
  5.2 Log format
  5.3 Log Types
  5.4 Logging Procedure

Chapter 6 DB Access Library API Reference
  6.1 Classes
    6.1.1 FJDB-SESSION Class
    6.1.2 FJDB-DATABASE Class
    6.1.3 FJDB-COMMAND Class
    6.1.4 FJDB-RECORDSET Class
    6.1.5 FJDB-ERROR Class
  6.2 Methods
    6.2.1 ADD-NEW-RECORD Method
    6.2.2 BEGIN-TRAN Method
    6.2.3 BIND-FIELDS Method
    6.2.4 BIND-PARAMETERS Method
    6.2.5 COMMIT-TRAN Method
    6.2.6 CREATE-COMMAND Method
    6.2.7 DELETE-RECORD Method
    6.2.8 EDIT-RECORD Method
    6.2.9 EXECUTE-COMMAND Method
    6.2.10 EXECUTE-SQL Method
    6.2.11 GET-AT Method
    6.2.12 GET-BOOKMARK Method
    6.2.13 GET-CLASS-NAME Method
    6.2.14 GET-CODE Method
    6.2.15 GET-COUNT Method
    6.2.16 GET-EDIT-MODE Method
    6.2.17 GET-MESSAGE Method
    6.2.18 GET-METHOD-NAME Method
    6.2.19 GET-NAME Method
    6.2.20 GET-NATIVE-ERROR-CODE Method
    6.2.21 GET-NEXT Method
    6.2.22 GET-RECORD-COUNT Method
    6.2.23 GET-SEVERITY Method
    6.2.24 GET-SQL Method
    6.2.25 GET-SQLSTATE Method
    6.2.26 IS-BOF Method
    6.2.27 IS-BOOKMARKABLE Method
    6.2.28 IS-EOF Method
    6.2.29 IS-SCROLLABLE Method
    6.2.30 IS-UPDATABLE Method
    6.2.31 MOVE-FIRST Method
    6.2.32 MOVE-LAST Method
    6.2.33 MOVE-NEXT Method
    6.2.34 MOVE-PREVIOUS Method
    6.2.35 OPEN-DATABASE Method
    6.2.36 OPEN-RECORDSET Method
    6.2.37 REFRESH-RECORDSET Method
    6.2.38 ROLLBACK-TRAN Method
    6.2.39 SET-BOOKMARK Method
    6.2.40 SET-NAME Method
    6.2.41 UPDATE-RECORD Method
  6.3 Methods for Creating Bind Tables
    6.3.1 NEW Method
    6.3.2 REGISTER Method
    6.3.3 REGISTER-VARYING Method
    6.3.4 REGISTER-LARGE-DATA Method
    6.3.5 REGISTER-INDICATOR Method
    6.3.6 REGISTER-VARYING-INDICATOR Method
    6.3.7 REGISTER-LARGE-DATA-INDICATOR Method
  6.4 Creating an Object
    6.4.1 Creating an Object of the FJDB-SESSION Class
    6.4.2 Creating an Object of the FJDB-DATABASE Class
    6.4.3 Creating an Object of the FJDB-COMMAND Class
    6.4.4 Creating an Object of the FJDB-RECORDSET Class

Chapter 7 Multithreading
  7.1 Operations in a Multithreading Environment
  7.2 Compiling a Multithread Program

Chapter 8 Unicode
  8.1 Operations in a Unicode Environment
  8.2 Compiling a Unicode Program Unicode

Chapter 9 Data Type Relationships between DBMS and COBOL
  9.1 Representation Formats of DBMS and COBOL Data Types
    9.1.1 SymfoWARE
    9.1.2 Oracle
    9.1.3 SQL Server
  9.2 Scopes of Variables Support
    9.2.1 SymfoWARE
    9.2.2 Oracle
    9.2.3 SQL Server

Chapter 10 Sample Codings Using Methods Provided
  10.1 Sample Codings Using the MOVE-LAST and GET-RECORD-COUNT Methods
  10.2 Sample Codings Using the GET-EDIT-MODE and IS-BOF Methods
  10.3 Sample Codings Using the GET-BOOKMARK,SET-BOOKMARK,MOVE-PREVIOUS Methods
  10.4 Sample Codings Using the BEGIN-TRAN,COMMIT-TRAN,ROLLBACK-TRAN Methods
  10.5 Sample Codings Using the REFRESH-RECORDSET,EDIT-RECORD Methods
  10.6 Sample Codings Using the GET-SQL Method
  10.7 Sample Codings Using the GET-NAME,SET-NAME,IS-SCROLLABLE,ISUPDATABLE, and IS-BOOKMARKABLE Methods
  10.8 Sample Codings Using the GET-AT,GET-COUNT,GET-MESSAGE,GET-SQLSTATE,GET-CODE,
GET-NATIVE-ERROR-CODE,GET-SEVERITY,GET-CLASS-NAME, and 
GET-METHOD-NAME,GET-NEXT Methods
  10.9 Sample Codings Using the REGISTER-VARYING Method
  10.10 Sample Codings Using the REGISTER-LARGE-DATA Method
  10.11 Sample Codings Using the REGISTER-INDICATOR Method
  10.12 Sample Codings Using the REGISTER-VARYING-INDICATOR Method
  10.13 Sample Codings Using the REGISTER-LARGE-DATA-INDICATOR Method

Chapter 11 Notes on Using the DB Access Class Library
  11.1 Notes on Updating Rows in a Recordset
  11.2 Notes on a Bind Table
  11.3 Notes on Using SymfoWARE
  11.4 Notes on Using Oracle
  11.5 Notes on Using SQL Server
  11.6 Notes on Creating a Multithread Program
  11.7 Notes on Creating a Unicode Program

Chapter 12 Messages

Glossary