Guardian User's Guide

Using FUP for Advanced File Management
Guardian User’s Guide—425266-001
8-4
Creating Files Using DDL
Creating Files Using DDL
You can also create structured files with the Tandem Data Definition Language (DDL).
DDL is a data-management tool for describing large databases:
1. Describe the files in a DDL source schema.
2. Compile the schema with the DDL compiler to produce both a database dictionary
and a file containing FUP file-creation commands.
3. Run FUP, specifying the command file created by DDL as an IN file.
For more information about DDL, see the Data Definition Language (DDL) Reference
Manual.
Using the SET, SHOW, and CREATE Commands
When you start a FUP process, the default file-creation parameters are in effect. Use the
FUP SHOW command to display the current values of the parameters. If you enter the
SHOW command just after you start FUP, the initial default values are displayed:
The TYPE parameter determines the file type of a file. The default TYPE value is U (for
Unstructured). The EXT parameter determines the sizes of primary and secondary file
extents; the default extent sizes are 1 page each (a page is a unit of 2048 bytes).
MAXEXTENTS and BUFFERSIZE appear for DP2 files only. MAXEXTENTS
controls the maximum number of extents that can be allocated to a file. BUFFERSIZE
sets the size in bytes of the buffer used for unstructured files. (For information about
DP2 file attributes, see the File Utility Program (FUP) Reference Manual.)
If you enter the CREATE command at this point, you create an unstructured file whose
primary and secondary extent sizes are one page each:
10> FUP
-SHOW
TYPE U
EXT ( 1 PAGES, 1 PAGES )
MAXEXTENTS 16
BUFFERSIZE 4096
-CREATE FILE1
CREATED - $MANUF.FREDFILE.FILE1