Data Build Manual

DDL Input and Output (F2)
Running Data Build
099331 Tandem Computers Incorporated 4–13
If the output files have not been created and the input files already exist, follow these
steps:
1. Exit Data Build.
2. Edit the FUPDEFS file.
3. Add this statement at the beginning of the file:
allow n severe errors
where n is the number of input files. Without this statement, FUP will stop when
it tries to create an input file that already exists. The number n should be equal to
the number of input files that already exist.
4. Exit from the editor.
5. Purge any existing output files.
6. Create the output files by entering this command at the TACL prompt:
1> FUP /IN fupdefs , OUT $ s.#fupdef /
Because the input files already exist, FUP will generate an error for each input file.
7. Run Peruse to check the spooler location #FUPDEF for any errors generated when
creating the output files. Make sure the only errors are for the input files that
already exist. You can ignore those errors. If you find other errors, correct them
before continuing. See the File Utility Program (FUP) Reference Manual for more
information.
8. Restart Data Build and go to step F3.
Changing the NonStop SQL
Defaults for IXF
For IXF input, Data Build creates a NonStop SQL database with certain defaults.
These defaults are:
Entry-sequenced tables
Extents and maxextents
Buffered
No audit
No indexes
Non-partitioned tables
Common catalog
You can change the NonStop SQL defaults by changing the file ZZTABLES.
To change the defaults:
1. Start Data Build and on the CONFIGURE (F1) screen, specify an SQL conversion
for Option 1 and IXF for Option 3.
2. Run step F2, which will produce the ZZTABLES file.