Contents
!
A
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
$, using with XFD directives
4GL_COMMIT_COUNT ACUFH environment variable
4GL_IGNORED_SUFFIX_LIST ACUFH configuration variable, DB2 and
4GL_ILLEGAL_DATA ACUFH configuration variable
access permissions, granting for database tables
accounts
setting up user for Database Connector for MSSQL
setting up user for Oracle
ACCTFIL file
Activator utility
ACUFH configuration file variables, COMMIT_COUNT
ACUFH configuration variables
4GL_IGNORED_SUFFIX_LIST
4GL_ILLEGAL_DATA
A_DB2_DATASOURCE
A_DB2_LOGIN
A_DB2_PASSWD
A_MSSQL_LOCK_DB
A_MSSQL_LOGIN
A_MSSQL_PASSWD
A_ORA_DATABASE
Database Connector for DB2
Database Connector for MSSQL
Database Connector for Oracle
DEFAULT_HOST
DEFAULT_HOST filesystem
filename_HOST
filename_HOST filesystem
FILE_TRACE
ORA_LOGIN
ORA_PASSWD
USER_PATH
WHERE constraint
XFD_MAP
XFD_MAP_RESETS
A_CONFIG environment variable
A_DB2_DATASOURCE ACUFH configuration variable
A_DB2_LOGIN ACUFH configuration variable
A_DB2_PASSWD ACUFH configuration variable
A_MSSQL_LOCK_DB ACUFH configuration variable
A_MSSQL_LOGIN ACUFH configuration variable
A_MSSQL_PASSWD ACUFH configuration variable
A_ORA_DATABASE ACUFH configuration variable
case conversions in data
changing database functions
checking the MSSQL server table
CICS, and MSSQL server
CICS conversion tutorials
COBOL
COMMIT verb
database interaction
mapping DB2 data to
matching COBOL fields to database fields
preparing and compiling programs
COBOL code and hyphens
COBOL data, invalid
COBOL I/O translation
columns
forcing group items to become
mapping
COMMIT verb
COMMIT_COUNT ACUFH configuration file variable
COMMIT_COUNT environment variable
compatibility with databases
compiler errors
compiler warnings
compiling, preparing a COBOL program for
compiling with the CREATEXFD directive
compiling with the WHEN XFD directive
configuration file, creating
configured login, Oracle
conflicts between field names
conversions, upper and lower case
CREATEXFD directive
compiling with
naming differences and
creating large tables
creating XFDs
CTF, using to retrieve error messages
cursor caching in Oracle
data
accessing
DB2 types
existing
invalid database
invalid key
restructuring
data format conversion
data mapping, DB2 types to COBOL types
data searches
data sequencing
data sources, designating the host for DB2
Database Connector for DB2
ACUFH configuration variables
data types
decimal points and
designating the host data source
designating the host file system
filename interpretation
installation and setup
limits and ranges
mapping DB2 data to COBOL data
record locking
run-time errors
table and record locking
transactions
troubleshooting
Database Connector for MSSQL
ACUFH configuration variables
database table
designating the host file system
filename interpretation
getting started
installing on client
limits and ranges
overview
run-time errors
security
servers
setting up a user account
setting up the user environment
stored procedures
table locking
table ownership
troubleshooting
Database Connector for Oracle
ACUFH configuration variables
checking system parameters
configured login
database table
designating host file system
features
filename interpretation
getting started
installing on Windows
Instant Client
open_cursors parameter
Oracle file system limits
record locking
run-time errors
security
setting up the search path
setting up the user environment
setting up user accounts
table ownership
transactions
troubleshooting
Database Connectors
data format conversions
data sequencing
database concepts
databases supported
default behavior
getting started
how it works
matching COBOL fields to database fields
overview
record locking
summary
XFDs
Database Connectors and library routines
Database Connectors and XFDs
Database Connectors COBOL I/O translation, how it works
Database Connectors index naming conventions
Database Connectors licensing
Database Connectors run-time, how it works
Database Connectors SQL generation, how it works
database data, invalid
database functions, changing
database table
MSSQL
Oracle
database violations
databases
compatibility
data sequencing
existing files
field names
files
how the table is formed
interacting with COBOL
matching fields to COBOL
matching fields to numeric
matching fields to text
relational
tuning
upgrading
DATE XFD directive
DB2 ACUFH configuration variables, overview
DBA, responsibilities of
decimal points and Database Connector for DB2
DECIMAL_POINT environment variable
default behavior, Database Connectors
defaults, XFDs
DEFAULT_HOST ACUFH configuration variable
DB2 and
DEFAULT_HOST filesystem ACUFH configuration variable
definitions, record
designating host data source, DB2
designating host file system
DB2
Oracle
directives
CREATEXFD
duplicate field names
environment
setting up user for Database Connector for Oracle
setting up user for Database Connector for DB2
setting up user for Database Connector for MSSQL
environment variable, setting
environment variables
4GL_COMMIT_COUNT
A_CONFIG
COMMIT_COUNT
DECIMAL_POINT
error descriptions, extended
error messages
retrieving with CTF
retrieving with FILE_TRACE
errors
compile
DB2 run-time
extended descriptions for
run-time
run-time for MSSQL
existing database files
guidelines for accessing
overview
extended error descriptions
FD, creating
features, Oracle supported
field name aliases
field names
identical
long
fields
key
mapping
matching COBOL to database
matching numeric to database
matching text to database
File Error 35
File Error 39
file input and output
file systems
designating host for DB2
designating host for Oracle
host
indexed
file tracing, using to view SQL statements generated by run-time system
FILE XFD directive
filename translation
Database Connector for DB2
Database Connector for MSSQL
Database Connector for Oracle
filenames
hyphens in
hyphens, uppercase letters, and underscores in
lowercase letters in
lowercase letters, hyphens, and underscores in
underscores in
filename_HOST ACUFH configuration variable
DB2 and
filename_HOST filesystem ACUFH configuration variable
files
database
existing database
reUZE Developer
XFD
FILE_TRACE ACUFH configuration variable
FILLER definition
final name, XFDs
format, data conversion
forming the final XFD name
generic file handler
getting started
Database Connector for DB2
Database Connector for MSSQL
Database Connector for Oracle
group items
database table columns and
growth, planning ahead for
guidelines
existing database files
performance
host data source, designating for Database Connector for DB2
host file systems
designating for Database Connector for DB2
designating for Database Connector for Oracle
designating on Database Connector for MSSQL
hyphens
filenames
in COBOL code
in filenames
identical field names
illegal COBOL data
other
index naming conventions
indexed file systems
indexes
Database Connectors naming conventions for
tables and
input
installation, overview
installing
Database Connector for DB2
Database Connector for MSSQL on client
Database Connector for Oracle
Database Connector for Oracle on Windows
installing MSSQL
Instant Client, Oracle
interaction between databases and COBOL
interactive SQL
interface routines
interpreting filenames
invalid COBOL data
invalid database data
invalid key data
key data, invalid
key fields
KEY IS phrase
key layout
large tables, creating
library routines and Database Connectors
licensing Database Connectors
limits and ranges
DB2
MSSQL
Oracle
locking records
DB2
Oracle
locking tables, MSSQL
login, configured Oracle
long field names
lowercase letters in filenames
mapping
columns and records
DB2 data to COBOL
DB2 data types
files to an XFD file
XFD files
mapping VSAM files
matching, COBOL fields to database fields
matching numeric fields to database fields
matching text fields to database fields
MFTRACE_CONFIG environment variable
MFTRACE_LOGS environment variable
MSSQL, installing
MSSQL ACUFH configuration variables, overview
multiple indexes and tables
multiple record definitions
FILLER
OCCURS
overview
REDEFINES
NAME directive
NAME XFD directive
names
final XFD
identical field
long field
overview of XFD
names of fields
conflicts in
overview
naming conventions for indexes
naming indexes
new database files, overview
numeric fields, matching to database
OCCURS definition
OPEN OUTPUT, using to create stand-alone tables
open_cursors parameter
Oracle ACUFH configuration variables
Oracle Instant Client
ORA_LOGIN ACUFH configuration variable
ORA_PASSWD ACUFH configuration variable
output
overview
ACUFH configuration variables
Database Connectors
getting started
installation
multiple record definitions
XFDs
ownership of tables
Database Connector for MSSQL
Database Connector for Oracle
parameters, Oracle system
performance
compile errors
compile warnings
data searches
database interaction with COBOL
file input and output
guidelines
overview
planning ahead
restructuring data
reUZE Developer files
run-time errors for MSSQL
run-time errors in DB2
run-time errors in Oracle
tables and multiple indexes
transactions
planning ahead for growth
preparing a COBOL program
procedures
MSSQL
stored
programs, preparing and compiling COBOL
Query Analyzer
RDBMS (relational database management system)
readability of column names
record definitions
record locking
Database Connector for DB2
Database Connector for Oracle
Database Connectors
records
mapping
REDEFINES definition
relational database management system (RDBMS)
restructuring data
reUZE Developer files
routines, interface
run-time errors
Database Connector for DB2
Database Connector for MSSQL
Database Connector for Oracle
run-time module
run-time system errors
sample program, running
search path, setting up for Database Connector for Oracle
security
Database Connector for MSSQL
Database Connector for Oracle
sequencing of data
servers, MSSQL Server
setting up a search path for Oracle
setting up a user environment, Database Connector for MSSQL
setting up user accounts
Database Connector for MSSQL
Database Connector for Oracle
setting up user environment
Database Connector for DB2
Database Connector for Oracle
source code, using to build XFDs
sources, designating host data for DB2
SQL generation
SQL Server. See Database Connector for MSSQL
stored procedures
creating
upgrading
supported features, Oracle
syntax, XFD directives
system parameters for Oracle
systems
designating host file
designating host file for DB2
designating host file for Oracle
table locking
Database Connector for DB2
MSSQL
table ownership
Database Connector for MSSQL
Database Connector for Oracle
tables
database formation of
MSSQL database
multiple indexes and
Oracle database
TEXT fields, matching to database
tracing, turning on
transactions
DB2
guidelines
Oracle
translating, filenames in Database Connector for DB2
translating filenames, Database Connector for MSSQL
translation, COBOL I/O
translation of filenames, Database Connector for Oracle
transparent interface, how it works
troubleshooting
compile errors
compile warnings
data searches
Database Connector for DB2
Database Connector for MSSQL
Database Connector for Oracle
database interaction with COBOL
file input and output
guidelines
overview
planning ahead
restructuring data
reUZE Developer files
run-time errors for Database Connector for MSSQL
run-time errors in Database Connector for Oracle
run-time errors in Database Connector for DB2
tables and multiple indexes
transactions
truncated field names
tuning your database
types of data, DB2
underscores in filenames
upgrading databases
upgrading stored procedures
uppercase letters in filenames
USE GROUP XFD directive
user accounts
setting up for Connector for Oracle
setting up for Database Connector for MSSQL
user environment
setting up for Database Connector for DB2
setting up for Database Connector for MSSQL
setting up for Database Connector for Oracle
USER_PATH ACUFH configuration variable
USE_GROUP XFD directive
using Oracle database table
using the MSSQL database table
variables, configuration
warnings
compiler
database upgrades
WHEN XFD directive
compiling with
field names and
WHERE constraint
Windows, installing Database Connector for Oracle on
XFD (extended file descriptor) files
XFD directives
CREATEXFD
DATE
existing data and
FILE
introduction
NAME
syntax
USE GROUP
USE_GROUP
WHEN
XFD fields, summary
XFDs
building from source code
Database Connectors
defaults
defined
generating
mapping to other files
naming
overview
XFD directives and
XFD_MAP ACUFH configuration variable
XFD_MAP_RESETS ACUFH configuration variable