C.5.2 Limits and Ranges

The following limits exist for the Oracle 7.3 file system:

Note: If you are using a version of Oracle 8, the limits and ranges differ depending on the version.

Maximum indexed keysize 250 bytes Maximum number of fields per key 16 Maximum number of columns 254 Maximum length of a charfield 255 bytes

With the Acu4GL product, a maximum of 100 database tables can be open at one time by a single process; see the description of configuration variable MAX-CURSORS in section C.3 "Configuration File Variables" in this appendix.

Acu4GL for Oracle supports the following data types.

COBOL
to
Oracle
PIC X

CHAR
PIC X(n)

CHAR(n)
PIC X(n)

VARCHAR2 *
PIC X(n)

RAW(n) **
PIC 9(n)

NUMBER(n)
PIC 9(n)

RAW(n) **
PIC 9(n)V9(m)

NUMBER(n+m, m)
example: PIC999V99

NUMBER(5,2)

Oracle
to
COBOL
CHAR

PIC X
CHAR(n)

PIC X(n)
VARCHAR2

PIC X(n) *
DATE

PIC 9(6) or PIC 9(8)
NUMBER(n)

PIC 9(n)
NUMBER(n, m)

PIC 9(n-m)V9(m)
RAW(n)

PIC X(n) ** or PIC 9(n) **
example: NUMBER(4,3)

PIC9V999

* indicates that the VAR-LENGTH directive is required.

** indicates that the BINARY directive is required.

Internally, Acu4GL for Oracle makes use of VARCHAR to prevent key fields that are all spaces from being converted to null.

These Oracle data types are not currently supported:

LONG

LONG RAW

Other limits described in Appendix B of the ACUCOBOL-GT compiler Reference Manual apply.

COBOL	to	Oracle
PIC X		CHAR
PIC X(n)		CHAR(n)
PIC X(n)		VARCHAR2 *
PIC X(n)		RAW(n) **
PIC 9(n)		NUMBER(n)
PIC 9(n)		RAW(n) **
PIC 9(n)V9(m)		NUMBER(n+m, m)
example: PIC999V99		NUMBER(5,2)

Oracle	to	COBOL
CHAR		PIC X
CHAR(n)		PIC X(n)
VARCHAR2		PIC X(n) *
DATE		PIC 9(6) or PIC 9(8)
NUMBER(n)		PIC 9(n)
NUMBER(n, m)		PIC 9(n-m)V9(m)
RAW(n)		PIC X(n) or PIC 9(n)
example: NUMBER(4,3)		PIC9V999