Technical data

DB (Subschema Description)
5. When you compile a program containing a DB statement, the resulting .OBJ
file includes the subschema date and time stamp assigned to the sub-schema-
name when it was inserted in Oracle CDD/Repository. At run time, the DBCS
finds the root file and binds the program to the subschema identified by sub-
schema-name. If the program does not contain the same date and time as
the subschema identified by sub-schema-name, then compile-time subschema
definitions may not be the same as the run-time definitions; therefore, an
exception condition occurs. This security check prevents your program from
accessing the database with obsolete subschema definitions.
6. If you include the FOR database-name clause, the DBCS determines if
database-name is a logical name or a file specification. If it is a partial file
specification, the default file type is .ROO.
7. If you omit the FOR database-name clause, the DBCS creates a database-
name from schema-name. The DBCS determines if schema-name is a logical
name. If it is, a translation is done to determine the database-name.If
schema-name is not a logical name, the DBCS creates a database-name by
appending .ROO to the first nine characters of schema-name.
8. If a separately compiled program in the run unit uses a stream, then all
separately compiled programs in the same run unit must use streams.
Otherwise, a run-time error occurs.
Technical Notes
• Table 3–1 describes the representation of data types in the Oracle CODASYL
DBMS data definition language (DDL) compiler and the HP COBOL for
OpenVMS Alpha, I64, or VAX compiler. Additionally, this table lists all data
types that can be specified using the DDL data definition language with the
corresponding COBOL data item picture. Note that COBOL does not have an
equivalent specification for some data types.
Table 3–1 HP COBOL and DDL Utility Data Type Equivalences
DDL COBOL
SIGNED BYTE (a)
UNSIGNED BYTE (a)
SIGNED WORD S9(4) COMP
UNSIGNED WORD (b)
SIGNED LONGWORD S9(9) COMP
UNSIGNED LONGWORD (b)
SIGNED QUADWORD S9(18) COMP
UNSIGNED QUADWORD (b)
SIGNED OCTAWORD (a)
UNSIGNED OCTAWORD (a)
FLOATING COMP-1
FLOATING COMPLEX (a)
D_FLOATING COMP-2 (/FLOAT=D on Alpha, I64,
VAX)
(continued on next page)
3–6 Data Division