Data Build Manual

Appendix D Tandem Reserved Words for IXF
Input
099331 Tandem Computers Incorporated D–1
Tandem products have reserved words that are not reserved in the source system. For
IXF input data only, Data Build provides the ZZRESRVD file as a mechanism for
overcoming this condition by adding a one-character suffix to Tandem reserved words
occurring in the input data, which gives them a new name that is not reserved.
The ZZRESRVD file contains a list of some of the words that are reserved on the
Tandem system, but which may be used as column or field names in input data from
the source system. For example, the Tandem reserved word DIVISION may be used
as a DB2 column name in an IBM source system. Following this example in the
ZZRESRVD file listed below, you can see that if the name DIVISION is used as a
column name in the IXF input data, Data Build adds a suffix of “X” to DIVISION,
making it DIVISIONX, and not a Tandem reserved word.
If the input data uses a Tandem reserved word that is not defined in the ZZRESRVD
file, an error will occur when running Data Build, most likely in the F4 step. If this
happens you must edit the ZZRESRVD file to add the reserved word that caused the
error, its context, and a one character suffix. Then restart Data Build at step F2.
The following is the ZZRESRVD file:
DATA BUILD
ZZRESRVD FILE
** ***** This table applies solely to IXF input. ***** **
** ***** ***** **
** This table is used to modify encountered table names **
** and column names, in those cases where that name may **
** conflict with reserved word requirements of COBOL85, **
** DDL, or NS/SQL. You can modify the contents of this **
** table as required. Lines beginning with a double **
** asterisk are ignored by DATABUILD. All other lines **
** are acted upon as described in the column headings. **
**
** NAME IF USED IN THIS CONTEXT ADD THIS SUFFIX
****************** *********************** ***************
CALL TABLE X
CODE COL X
DESC COL X
DIVISION COL X
PROCEDURE TABLE X
TIMESTAMP COL X
TYPE COL X
****************************************************************