1 Acu4GL Overview
1.1 Welcome to Acu4GL
1.2 Document Overview
1.3 Accessing Data
1.3 Accessing Data
1.3.1 Interface Routines
1.3.2 Data Dictionaries and Acu4GL
1.3.3 The ACUCOBOL-GT Plug-in and Acu4GL
1.4 Database Concepts
1.4 Database Concepts
1.5 How Acu4GL Works
1.5 How Acu4GL Works
1.5.1 What Is a Transparent Interface?
1.5.2 Data Dictionaries and Mapping
1.5.3 Steps to Follow
1.5.4 Summary
2 Getting Started
2.1 Getting Started
2.2 Technical Support
2.3 Installation
2.4 Using the sql.acu Program
2.4 Using the sql.acu Program
2.4.1 Running sql.acu From the Command Line
2.4.2 To Call sql.acu From a Program
2.5 The Demonstration Program
2.5 The Demonstration Program
3 Data Dictionaries
3.1 Data Dictionaries or XFDs
3.2 XFD Files
3.2 XFD Files
3.2.1 Understanding How the Database Table Is Formed
3.2.2 Defaults Used in XFD Files
3.2.3 Summary of Dictionary Fields
3.2.4 Identical Field Names
3.2.5 Long Field Names
3.2.6 Naming the XFD
4 Using Directives
4.1 Directives
4.2 Syntax
4.3 ALPHA Directive
4.4 BINARY Directive
4.5 COMMENT Directive
4.6 DATE Directive
4.7 FILE Directive
4.8 NAME Directive
4.9 NUMERIC Directive
4.10 SECONDARY_TABLE Directive
4.11 USE GROUP Directive
4.12 VAR_LENGTH Directive
4.13 WHEN Directive
5 Invalid Data
5.1 Illegal COBOL Data
5.1 Illegal COBOL Data
5.1.1 Invalid Key Data
5.1.2 Invalid Data Other Than Keys
5.2 Invalid Database Data
5.2 Invalid Database Data
6 Working with COBOL
6.1 Preparing and Compiling Your COBOL Program
6.1 Preparing and Compiling Your COBOL Program
6.1.1 Approach One
6.1.2 Approach Two
6.1.3 Approach Three
7 New and Existing Databases
7.1 Databases
7.2 Default Behavior
7.3 Existing Database Files
7.3 Existing Database Files
7.3.1 How Do I Match Existing Text Fields?
7.3.2 How Do I Match Existing Numeric Fields?
7.3.3 Field Names
7.3.4 Index Names
8 Compiler and Runtime Options
8.1 Compiler Options
8.1 Compiler Options
8.1.1 -Fx Option
8.1.2 -Fo Option
8.2 Runtime Configuration Variables
8.2 Runtime Configuration Variables
4GL_2000_CUTOFF
4GL_8_DIGIT_CUTOFF
4GL_COLUMN_CASE
4GL_CONVERT_DATES
4GL_EXTRA_DB_COLS_OK
4GL_IGNORED_SUFFIX_LIST
4GL_ILLEGAL_DATA
4GL_JULIAN_BASE_DATE
A4GL_COMMIT_COUNT
DEFAULT_HOST
filename_HOST
XFD_DIRECTORY
XFD_MAP
XFD_MAP_RESETS
9 Performance and Troubleshooting
9.1 Performance Issues
9.1 Performance Issues
9.1.1 Guidelines
9.1.2 The WHERE Constraint
9.2 Troubleshooting
9.2 Troubleshooting
9.2.1 Compile-time Errors
9.2.2 Compile-time Warnings
A Acu4GL for Informix Information
A.1 Getting Started with Acu4GL for Informix
A.1 Getting Started with Acu4GL for Informix
A.1.1 Installation of the Acu4GL for Informix Product
A.1.2 Installing the Acu4GL for Informix Product
A.1.3 Acu4GL for Informix: Designating a Database
A.2 Acu4GL for Informix and Filename Translation
A.2 Acu4GL for Informix and Filename Translation
A.3 Acu4GL for Informix Configuration File Variables
A.3 Acu4GL for Informix Configuration File Variables
A_INF_DUPLICATE_KEY
A_INF_NO_TRANSACTION_ERROR
A_INFORMIX_ERROR_FILE
DATABASE
INF_LOGIN
INF_PASSWD
MAX_CURSORS
A.4 Informix 7.2 and 7.3 Performance
A.4 Informix 7.2 and 7.3 Performance
A.5 Acu4GL for Informix: Technical Information
A.5 Acu4GL for Informix: Technical Information
A.5.1 Acu4GL for Informix: Supported Features
A.5.2 Acu4GL for Informix: Limits and Ranges
A.6 Acu4GL for Informix: Troubleshooting
A.6 Acu4GL for Informix: Troubleshooting
A.6.1 Acu4GL for Informix: Runtime Errors
A.6.2 Acu4GL for Informix: Retrieving Errors
A.7 Acu4GL for Informix: Common Questions and Answers
A.7 Acu4GL for Informix: Common Questions and Answers
B Acu4GL for Microsoft SQL Server Information
B.1 Microsoft SQL Server Concepts Overview
B.2 Getting Started with Acu4GL for Microsoft SQL Server
B.2 Getting Started with Acu4GL for Microsoft SQL Server
B.2.1 Acu4GL for Microsoft SQL Server Installation and Setup
B.2.2 Installing the Acu4GL for Microsoft SQL Server Product on a Client Machine
B.2.3 Acu4GL for Microsoft SQL Server: Setting Up a User Account
B.2.4 Acu4GL for Microsoft SQL Server: Setting Up the User Environment
B.2.5 Acu4GL for Microsoft SQL Server: Designating the Host File System
B.3 Acu4GL for Microsoft SQL Server and Filename Translation
B.3 Acu4GL for Microsoft SQL Server and Filename Translation
B.4 Acu4GL for Microsoft SQL Server Configuration File Variables
B.4 Acu4GL for Microsoft SQL Server Configuration File Variables
A_MSSQL_ADD_IDENTITY
A_MSSQL_ADD_TIMESTAMP
A_MSSQL_CURSOR_OPTION_1
A_MSSQL_DATABASE
A_MSSQL_DEFAULT_CONNECTION
A_MSSQL_EXTRA_PROC
A_MSSQL_FAST_ACCESS
A_MSSQL_FORCED_INDEX
A_MSSQL_LOCK_DB
A_MSSQL_LOGIN
A_MSSQL_MAX_CHARACTERS
A_MSSQL_MAX_COLUMNS
A_MSSQL_NATIVE_LOCK_TIMEOUT
A_MSSQL_NO_COUNT_CHECK
A_MSSQL_NO_DBCLOSE
A_MSSQL_NO_DBID
A_MSSQL_NO_RECORD_LOCKS
A_MSSQL_NO_TABLE_LOCKS
A_MSSQL_NO_23_ON_START
A_MSSQL_NT_AUTHENTICATION
A_MSSQL_PACKETSIZE
A_MSSQL_PASSWD
A_MSSQL_ROWCOUNT
A_MSSQL_SELECT_KEY_ONLY
A_MSSQL_SKIP_ALTERNATE_KEYS
A_MSSQL_TRANSLATE_TO_ANSI
A_MSSQL_UNLOCK_ON_EXECUTE
A_MSSQL_USE_DROPDOWN_QUERIES
A_MSSQL_VISION_LOCKS_FILE
B.5 Acu4GL for Microsoft SQL Server: Using the Database Table
B.5 Acu4GL for Microsoft SQL Server: Using the Database Table
B.6 Acu4GL for Microsoft SQL Server: Technical Information
B.6 Acu4GL for Microsoft SQL Server: Technical Information
B.6.1 Acu4GL for Microsoft SQL ServerL: Table Locking
B.6.2 Acu4GL for Microsoft SQL Server: Stored Procedures
B.6.3 Acu4GL for Microsoft SQL Server: Limits and Ranges
B.7 Acu4GL for Microsoft SQL Server: Troubleshooting
B.7 Acu4GL for Microsoft SQL Server: Troubleshooting
B.7.1 Acu4GL for Microsoft SQL Server: Runtime Errors
B.7.2 Acu4GL for Microsoft SQL Server: Retrieving Errors
B.8 Acu4GL for Microsoft SQL Server: Common Questions and Answers
B.8 Acu4GL for Microsoft SQL Server: Common Questions and Answers
C Acu4GL for Oracle Information
C.1 Oracle Concepts Overview
C.2 Acu4GL for Oracle Installation and Setup
C.2 Acu4GL for Oracle Installation and Setup
C.2.1 Windows Installation Steps for the Acu4GL for Oracle Product
C.2.2 UNIX Installation Steps for the Oracle Acu4GL Product
C.2.3 Installing the Product
C.2.4 Acu4GL for Oracle: Checking System Parameters
C.2.5 Acu4GL for Oracle: Setting Up a User Account
C.2.6 Acu4GL for Oracle: Setting Up the User Environment
C.2.7 Acu4GL for Oracle: Designating the Host File System
C.2.8 Acu4GL for Oracle: Setting Up the Search Path
C.2.9 Acu4GL for Oracle: Handling Transactions
C.3 Acu4GL for Oracle and Filename Translation
C.3 Acu4GL for Oracle and Filename Translation
C.4 Acu4GL for Oracle Configuration File Variables
C.4 Acu4GL for Oracle Configuration File Variables
A_ORA_DEFER_CLOSE
A_ORA_DUPLICATE_KEY
A_ORACLE_ERROR_FILE
A_ORA_HINTS
COMMIT_COUNT
MAX_CURSORS
ORA_LOGIN
ORA_PASSWD
USE_INVALID_CURSOR_LOGIC
USER_PATH
C.5 Acu4GL for Oracle: Using the Database Table
C.5 Acu4GL for Oracle: Using the Database Table
C.6 Acu4GL for Oracle: Technical Information
C.6 Acu4GL for Oracle: Technical Information
C.6.1 Acu4GL for Oracle: Supported Features
C.6.2 Acu4GL for Oracle: Limits and Ranges
C.7 Acu4GL for Oracle: Troubleshooting
C.7 Acu4GL for Oracle: Troubleshooting
C.7.1 Acu4GL for Oracle: Runtime Errors
C.7.2 Acu4GL for Oracle: Retrieving Errors
C.8 Acu4GL for Oracle: Common Questions and Answers
C.8 Acu4GL for Oracle: Common Questions and Answers
D Acu4GL for ODBC Information
D.1 ODBC Concepts
D.1 ODBC Concepts
D.1.1 What is ODBC?
D.1.2 Origins of ODBC
D.1.3 Restrictions
D.1.4 ODBC Structure
D.2 Acu4GL for ODBC Installation and Setup
D.2 Acu4GL for ODBC Installation and Setup
D.2.1 Installation
D.2.2 Installation of Acu4GL for ODBC
D.2.3 Acu4GL for ODBC: Setting Up Data Sources
D.2.4 Acu4GL for ODBC: Setting Up the User Environment
D.2.5 Acu4GL for ODBC: Designating the Host File System
D.2.6 Acu4GL for ODBC: Designating the Host Data Source
D.3 Acu4GL for ODBC and Filename Translation
D.3 Acu4GL for ODBC and Filename Translation
D.4 Acu4GL for ODBC Configuration File Variables
D.4 Acu4GL for ODBC Configuration File Variables
A4GL_MAX_DATE
A4GL_MIN_DATE
A_ODBC_COMMIT_ON_BEGIN
A_ODBC_DATASOURCE
A_ODBC_ERROR_MAP_FILE
A_ODBC_LOCK_METHOD
A_ODBC_LOGIN
A_ODBC_NO_NULL_COLUMNS
A_ODBC_PASSWD
A_ODBC_PRINT_LOG
A_ODBC_QUOTE_IDENTIFIERS
A_ODBC_UNSIGNED_TINYINT
A_ODBC_USE_CHAR_FOR_BINARY
A_ODBC_USE_SPACE_IN_DATES
D.5 Acu4GL for ODBC: Technical Information
D.5 Acu4GL for ODBC: Technical Information
D.5.1 Acu4GL for ODBC: Record and Table Locking
D.5.2 Acu4GL for ODBC: Limits and Ranges
D.5.3 Acu4GL for ODBC: Driver Requirements
D.5.4 Acu4GL for ODBC: Data Type Mapping
D.6 Acu4GL for ODBC: Troubleshooting
D.6 Acu4GL for ODBC: Troubleshooting
D.6.1 Acu4GL for ODBC: Runtime Errors
D.6.2 Acu4GL for ODBC: Retrieving Errors
D.6.3 Acu4GL for ODBC: Native SQL Errors
D.7 Acu4GL for ODBC: Common Questions and Answers
D.7 Acu4GL for ODBC: Common Questions and Answers
E Acu4GL for Sybase Information
E.1 Sybase Concepts Overview
E.2 Getting Started with Acu4GL for Sybase
E.2 Getting Started with Acu4GL for Sybase
E.2.1 Sybase RDBMS Installation
E.3 Acu4GL for Sybase Installation
E.3 Acu4GL for Sybase Installation
E.3.1 Installing the Acu4GL for Sybase Product for Use with a UNIX Client and
a UNIX or Windows NT Server
E.3.2 Installation Steps on the UNIX Client
E.3.3 Installation Steps on the UNIX or Windows NT Server
E.3.4 Installing the Acu4GL for Sybase Product for Use with a Windows Client
and a UNIX or Windows NT Server
E.3.5 Installation Steps on the UNIX Server Machine
E.3.6 Installation Steps on a Windows NT Server Machine - Windows Client
E.3.7 Installation Steps for a Windows Client
E.4 Acu4GL for Sybase Setup
E.4 Acu4GL for Sybase Setup
E.4.1 Acu4GL for Sybase: Setting Up a User Account
E.4.2 Acu4GL for Sybase: Setting Up the User Environment
E.4.3 Acu4GL for Sybase: Designating the Host File System
E.5 Acu4GL for Sybase and Filename Translation
E.5 Acu4GL for Sybase and Filename Translation
E.6 Acu4GL for Sybase Configuration File Variables
E.6 Acu4GL for Sybase Configuration File Variables
A_SYB_ADD_IDENTITY
A_SYB_ADD_TIMESTAMP
A_SYB_CURSOR_OPTION_1
A_SYB_DATABASE
A_SYB_DEFAULT_CONNECTION
A_SYB_EXTRA_PROC
A_SYB_FAST_ACCESS
A_SYB_FORCED_INDEX
A_SYB_LOCK_DB
A_SYB_LOGIN
A_SYB_MAX_CHARACTERS
A_SYB_MAX_COLUMNS
A_SYB_NATIVE_LOCK_TIMEOUT
A_SYB_NO_COUNT_CHECK
A_SYB_NO_DBCLOSE
A_SYB_NO_DBID
A_SYB_NO_RECORD_LOCKS
A_SYB_NO_TABLE_LOCKS
A_SYB_NO_23_ON_START
A_SYB_PACKETSIZE
A_SYB_PASSWD
A_SYB_ROWCOUNT
A_SYB_SELECT_KEY_ONLY
A_SYB_SKIP_ALTERNATE_KEYS
A_SYB_TRANSLATE_TO_ANSI
A_SYB_UNLOCK_ON_EXECUTE
A_SYB_USE_DROPDOWN_QUERIES
A_SYB_VISION_LOCKS_FILE
E.7 Acu4GL for Sybase: Technical Information
E.7 Acu4GL for Sybase: Technical Information
E.7.1 Acu4GL for Sybase: Record and Table Locking
E.7.2 Acu4GL for Sybase: Stored Procedures
E.7.3 Acu4GL for Sybase: Limits and Ranges
E.8 Acu4GL for Sybase: Troubleshooting
E.8 Acu4GL for Sybase: Troubleshooting
E.8.1 Acu4GL for Sybase: Runtime Errors
E.8.2 Acu4GL for Sybase: Retrieving Errors
E.9 Acu4GL for Sybase: Common Questions and Answers
E.9 Acu4GL for Sybase: Common Questions and Answers
F Acu4GL for DBMaker Information
F.1 DBMaker Concepts Overview
F.1 DBMaker Concepts Overview
F.1.1 What Is DBMaker?
F.1.2 DBMaker Structure
F.1.3 DBMaker and Acu4GL Architecture
F.2 Acu4GL for DBMaker Installation and Setup for Windows and UNIX
F.2 Acu4GL for DBMaker Installation and Setup for Windows and UNIX
F.2.1 Acu4GL for DBMaker Installation Overview
F.2.2 Windows Installation Steps for the Acu4GL for DBMaker Product
F.2.3 UNIX Installation Steps for the Acu4GL for DBMaker Product
F.2.4 Acu4GL for DBMaker: Setting Up a User Account
F.2.5 Acu4GL for DBMaker: Designating the Host File System
F.2.6 Acu4GL for DBMaker: Designating the Host Database
F.3 Acu4GL for DBMaker and Filename Translation
F.3 Acu4GL for DBMaker and Filename Translation
F.4 Acu4GL for DBMaker Configuration File Variables
F.4 Acu4GL for DBMaker Configuration File Variables
A_DBM_COMMIT_ON_BEGIN
A_DBM_DATABASE
A_DBM_ERROR_MAP_FILE
A_DBM_LOCK_METHOD
A_DBM_LOGIN
A_DBM_NO_NULL_COLUMNS
A_DBM_PASSWD
A_DBM_QUOTE_IDENTIFIERS
A_DBM_UNSIGNED_TINYINT
A_DBM_USE_CHAR_FOR_BINARY
A_DBM_USE_SPACE_IN_DATES
F.5 Acu4GL for DBMaker: Technical Information
F.5 Acu4GL for DBMaker: Technical Information
F.5.1 Acu4GL for DBMaker: Record and Table Locking
F.5.2 Acu4GL for DBMaker: Limits and Ranges
F.5.3 Acu4GL for DBMaker: Data Type Mapping
F.6 Acu4GL for DBMaker: Troubleshooting
F.6 Acu4GL for DBMaker: Troubleshooting
F.6.1 Acu4GL for DBMaker: Runtime Errors
F.6.2 Acu4GL for DBMaker: Retrieving Errors
F.6.3 Acu4GL for DBMaker: Native SQL Errors
F.7 Acu4GL for DBMaker: Common Questions and Answers
F.7 Acu4GL for DBMaker: Common Questions and Answers
Glossary of Terms
Glossary of Terms
(c) Copyright Acucorp, Inc., 1994-2001. ALL RIGHTS RESERVED.
Acucorp, Acucobol, AcuBench, AcuConnect, AcuLaunch, AcuServer, AcuSQL, Acu4GL, and extend are trademarks of Acucorp, Inc. AcuODBC is a registered trademark of Acucorp, Inc. Acu4GL is protected by U.S. patent no. 5,640,550. Other brand and product names are trademarks or registered trademarks of their holders.