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