Data Definition Language (DDL) Reference Manual

DDL Compiler Commands
Data Definition Language (DDL) Reference Manual—529431-004
9-68
FUP
Only one FUP source code file can be open at a time. If you use the FUP command
when you already have a FUP source code file open, the DDL compiler closes the
current source code file before opening the new source code file.
If the FUP source code file source code file already exists and the exclamation point is
omitted, the DDL compiler appends the new FUP file-creation commands to the end of
the file. The DDL compiler does not replace any existing commands in the file.
You can change any file-creation command after it is written to the FUP source code
file by closing the file and then editing it using the EDIT program. You might need to
edit either of these attributes:
If you specify a file attribute with a value equal to the default in FUP, the DDL compiler
will not specify the attribute in the generated FUP source code.
DDL names alternate key files by appending a number, starting with 0, to the data file
name. If necessary, the DDL compiler truncates the file name so that the composite
name does not exceed eight ASCII characters. Thus, if a file named LONGFILE has 11
unique alternate keys, the DDL compiler generates 11 alternate key files named
LONGFIL0, LONGFIL1, and so forth through LONGFIL0.
Example 9-30 on page 9-68 shows an interactive session in which FUP source code is
generated from a record in the dictionary.
Attribute Reason for Change
File names The file names generated for ALTFILE and CREATE commands
might be unacceptable.
Alternate-key files The DDL compiler generates one file for all keys that are not unique
and one file for each unique alternate key. You can change this
mapping of keys to files.
Example 9-30. FUP Command (page 1 of 2)
DDL Input
34> DDL DICT
Run DDL and open dictionary.
!?FUP fupsrc !
Open FUPSRC; if file exists, purge existing data.
!OUTPUT RECORD customer.
Get record from dictionary, write FUP file-creation
commands to FUPSRC.
?NOFUP
Close FUPSRC.
!EXIT
Exit DDL.