Acucorp, Inc.


BooksSearchIndex

Acu4GL User's Guide
Version 6.0

1: Acu4GL Overview

1.1 Welcome to Acu4GL
1.2 Document Overview
1.3 Accessing Data
1.3.1 Interface Routines
1.3.2 Data Dictionaries and Acu4GL
1.3.3 The ACUCOBOL-GT Web Runtime and Acu4GL
1.4 Database Concepts
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

Back to top

2: Getting Started

2.1 Getting Started
2.2 Technical Support
2.3 Installation
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

Back to top

3: Data Dictionaries

3.1 Data Dictionaries or XFDs
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

Back to top

4: Using Directives

4.1 Directives
4.2 Syntax
4.3 ALPHA
4.4 BINARY
4.5 COMMENT
4.6 DATE
4.7 FILE
4.8 NAME
4.9 NUMERIC
4.10 SECONDARY_TABLE
4.11 USE GROUP
4.12 VAR_LENGTH
4.13 WHEN

Back to top

5: Invalid 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

6: Working with COBOL

6.1 Preparing and Compiling Your COBOL Program
6.1.1 Approach One - Compiling With No Directives
6.1.2 Approach Two - Compiling With the WHEN Directive
6.1.3 Approach Three - Using Additional Directives
6.2 Creating File Descriptors and SELECT Statements

Back to top

7: New and Existing Databases

7.1 Databases
7.2 Default Behavior
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

Back to top

8: Compiler and Runtime Options

8.1 Compiler Options
8.1.1 -Fx
8.1.2 -Fa
8.1.3 -Fo
8.1.4 -F4
8.2 Runtime Configuration Variables
4GL_2000_CUTOFF
4GL_8_DIGIT_CUTOFF
4GL_COLUMN_CASE
4GL_COMMIT_COUNT
4GL_CONVERT_DATES
4GL_EXTRA_DB_COLS_OK
4GL_IGNORED_SUFFIX_LIST
4GL_ILLEGAL_DATA
4GL_JULIAN_BASE_DATE
DEFAULT_HOST
filename_HOST
XFD_DIRECTORY
XFD_MAP
XFD_MAP_RESETS
XFD_PREFIX

Back to top

9: Performance and Troubleshooting

9.1 Performance Issues
9.1.1 Guidelines
9.1.2 The WHERE Constraint
9.2 Troubleshooting
9.2.1 Compile-time Errors
9.2.2 Compile-time Warnings
9.2.3 Retrieving Runtime Errors
9.2.3.1 Method One - Using the "-x" Runtime Option
9.2.3.2 Method Two - Using the Debugger
9.2.3.3 Method Three - Using C$RERR

Back to top

10: General Questions and Answers

10.1 Introduction
10.2 Questions and Answers

A: Acu4GL for Informix Information

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.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 Performance
A.5 Acu4GL for Informix: Technical Tips
A.6 Acu4GL for Informix: Supported Features
A.7 Acu4GL for Informix: Limits and Ranges
A.8 Acu4GL for Informix: Runtime Errors
A.9 Acu4GL for Informix: Common Questions and Answers

Back to top

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.1 Acu4GL for Microsoft SQL Server Installation and Setup
B.2.2 Installing Acu4GL for Microsoft SQL Server 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.4 Acu4GL for Microsoft SQL Server Configuration File Variables
A_MSSQL_ADD_IDENTITY
A_MSSQL_ADD_TIMESTAMP
A_MSSQL_CURSOR_OPTION_1, A_MSSQL_CURSOR_OPTION_2, A_MSSQL_CURSOR_OPTION_3
A_MSSQL_DATABASE
A_MSSQL_DEADLOCK_LOOPS
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.6 Acu4GL for Microsoft SQL Server: Table Locking
B.7 Acu4GL for Microsoft SQL Server: Stored Procedures
B.7.1 Developer- or site-supplied stored procedures
B.7.2 Stored Procedures in Acu4GL for Microsoft SQL Server
B.8 Acu4GL for Microsoft SQL Server: Limits and Ranges
B.9 Acu4GL for Microsoft SQL Server: Runtime Errors
B.10 Acu4GL for Microsoft SQL Server: Common Questions and Answers

Back to top

C: Acu4GL for Oracle Information

C.1 Oracle Concepts Overview
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.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.6 Acu4GL for Oracle: Supported Features
C.7 Acu4GL for Oracle: Limits and Ranges
C.8 Acu4GL for Oracle: Runtime Errors
C.9 Acu4GL for Oracle: Common Questions and Answers

Back to top

D: Acu4GL for ODBC Information

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.1 ODBC 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.4 Acu4GL for ODBC Configuration File Variables
4GL_MAX_DATE
4GL_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_STRICT_EQUAL
A_ODBC_UNSIGNED_TINYINT
A_ODBC_USE_CHAR_FOR_BINARY
A_ODBC_USE_SPACE_IN_DATES
D.5 Acu4GL for ODBC: Record and Table Locking
D.6 Acu4GL for ODBC: Limits and Ranges
D.7 Acu4GL for ODBC: Driver Requirements
D.8 Acu4GL for ODBC: Data Type Mapping
D.9 Acu4GL for ODBC: Troubleshooting
D.9.1 Acu4GL for ODBC: Runtime Errors
D.9.2 Acu4GL for ODBC: Native SQL Errors
D.10 Acu4GL for ODBC: Common Questions and Answers

Back to top

E: Acu4GL for Sybase Information

E.1 Sybase Concepts Overview
E.2 Getting Started with Acu4GL for Sybase
E.2.1 Sybase RDBMS 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: Setting Up a User Account
E.5 Acu4GL for Sybase: Setting Up the User Environment
E.6 Acu4GL for Sybase: Designating the Host File System
E.7 Acu4GL for Sybase and Filename Translation
E.8 Acu4GL for Sybase Configuration File Variables
A_SYB_ADD_IDENTITY
A_SYB_ADD_TIMESTAMP
A_SYB_CURSOR_OPTION_1, A_SYB_CURSOR_OPTION_2, A_SYB_CURSOR_OPTION_3
A_SYB_DATABASE
A_SYB_DEADLOCK_LOOPS
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.9 Acu4GL for Sybase: Record and Table Locking
E.10 Acu4GL for Sybase: Stored Procedures
E.10.1 Developer- or site-supplied stored procedures
E.10.2 Stored Procedures in Acu4GL for Sybase
E.11 Acu4GL for Sybase: Limits and Ranges
E.12 Acu4GL for Sybase: Runtime Errors
E.13 Acu4GL for Sybase: Common Questions and Answers

Back to top

F: Acu4GL for DB2 Information

F.1 DB2 Concepts Overview
F.2 Acu4GL for DB2 Installation and Setup
F.2.1 Windows Installation
F.2.2 UNIX Installation Steps for the Acu4GL for DB2 Product
F.2.3 Sample Configuration File
F.2.4 Acu4GL for DB2: Setting Up the User Environment
F.2.5 Acu4GL for DB2: Designating the Host File System
F.2.6 Acu4GL for DB2: Designating the Host Data Source
F.3 Acu4GL for DB2 and Filename Translation
F.4 Acu4GL for DB2 Configuration File Variables
A_DB2_COMMIT_ON_BEGIN
A_DB2_DATASOURCE
A_DB2_ERROR_MAP_FILE
A_DB2_LOCK_METHOD
A_DB2_LOGIN
A_DB2_PASSWD
A_DB2_STRICT_EQUAL
A_DB2_USE_CHAR_FOR_BINARY
F.5 Acu4GL for DB2: Record and Table Locking
F.6 Acu4GL for DB2: Limits and Ranges
F.7 Acu4GL for DB2: Data Type Mapping
F.8 Acu4GL for DB2: Runtime Errors
F.9 Acu4GL for DB2: Common Questions and Answers

Back to top

Glossary of Terms


BooksSearchIndex
© Copyright Acucorp, Inc., 1988-2003. All rights reserved.
AcuBench, AcuServer, and AcuSQL are trademarks of Acucorp, Inc. Acucorp, ACUCOBOL-GT, Acu4GL, AcuConnect, AcuODBC, and extend are registered trademarks of Acucorp, Inc. "The new face of COBOL" is a service mark of Acucorp, Inc. Acu4GL is protected by U.S. patent 5,640,550, and AcuODBC is protected by U.S. patent 5,826,076.
AIX, DB2, RS/6000, and Informix are registered trademarks of IBM in the United States. Microsoft and Windows are registered trademarks of Microsoft Corporation in the United States and/or other countries. Netscape and the Netscape N and Ship’s Wheel logos are registered trademarks of Netscape Communications Corporation in the U.S. and other countries. UNIX is a registered trademark of the Open Group in the United States and other countries. Oracle is a registered trademark, and Oracle 8i, Oracle 9i, Pro*C, Pro*COBOL, and SQL*Plus are trademarks or registered trademarks, of Oracle Corporation. Sybase is a trademark of Sybase, Inc. Other brand and product names are trademarks or registered trademarks of their respective holders.
E-01-UG-030501-Acu4GL-6.0