Data Definition Language (DDL) Reference Manual (G06.24+)

DDL Compiler Commands
Data Definition Language (DDL) Reference Manual—426798-002
9-78
OLDFUP_FILEFORMAT Command
CREATE EMPLOYE0
FUP output produced for EMPL.
OLDFUP_FILEFORMAT Command
The OLDFUP_FILEFORMAT command specifies file format 1 in all FUP source files.
The OLDFUP_FILEFORMAT command instructs the DDL compiler to:
•
Specify file format 1 in all FUP source files.
•
Specify file format 1 in all FUP alternate key files.
OLDFUP_FILEFORMAT Guidelines
The following points are guidelines for using the OLDFUP_FILEFORMAT command:
•
By default DDL does not mention the format of the file in FUP outputs.
•
The format specification of a file for a record is not stored in the DDL dictionary. If
the user compiles the records with a particular format command (using the
OLDFUP_FILEFORMAT, NEWFUP_FILEFORMAT, or NOFILEFORMAT
command) and stores the records in the dictionary, the user must use the same
commands while requesting FUP output of those records.
•
The format specification for both the alternate key and the main file is the same
(format 1 in this case).
•
DDL does not allow the user to define a record length greater than the maximum
allowed length. For format 1 files, the maximum allowed record length (assuming
the block size is 4096 bytes) is as follows.
If you attempt to define a record size greater than the above specified record sizes
DDL issues an error message.
OLDFUP_FILEFORMAT Example
In the following example, the DDL compiler generates statements in the FUP source
file to create a format 1 file:
20> DDL
?DICT
OLDFUP_FILEFORMAT
File type Record size (format 1 file)
Unstructured 4096 bytes
Entry-sequenced 4072 bytes
Relative 4072 bytes
Key-Sequenced 4062 bytes