Data Build Manual

Source Record Descriptions File
Setting Up the Project Environment
3–10 099331 Tandem Computers Incorporated
Source Record
Descriptions
Table 3-2 shows valid options for the source record descriptions of input data types
supported by Data Build. Table 1-2 in Section 1, “Introduction to Data Build,” shows
data types that are not supported by Data Build.
Table 3-2. Valid Choices for Source Record Descriptions
Source Record
Description
COBOL
Data Type
DB2
Data Type
Data Description
PIC X(n)
PIC 9(n) w/o COMP
DISPLAY CHAR Character (including unsigned numeric)
display
PIC S9(n) w/o COMP DISPLAY Numeric display with sign leading separate
PIC X(n) VARCHAR Variable-length character (only for IXF
input data not to be coded by the user).
For non-IXF, VARCHAR can be handled
by user customization
PIC 9(n) COMP COMP
COMP-4
SMALLINT Half-word binary where n is less than 5
PIC 9(n) COMP COMP
COMP-4
INTEGER Full-word binary where n is greater than 4
PIC 9(n) COMP-3 COMP-3 DECIMAL IBM packed decimal
PIC X(10) DATE DATE Exploded date (yyyy-mm-dd)
PIC X(8) TIME TIME Exploded time (hh.mm.ss)
PIC X(26) TIMESTAMP TIMESTAMP Exploded date and time stamp
(yyyy-mm-dd-hh.mm.ss.nnnnnn)
NULLS An additional option with any of the above
options; indicates if the SQL column can
contain nulls
PIC X(n) NULLIND For a column that indicates if an
associated column contains nulls (SQL
only) where n is any valid PIC X value
Note If a COMP or COMP-3 field is greater than 9 digits, you must include an S in front of the 9 in the source
record descriptions; for example, PIC S9(11) COMP.
If you use the NULLS option with any of the above choices and your output is SQL, then that field can
contain nulls.
If you use the NULLIND option, then the name of this field is formed by appending a -I to the name of an
associated nullable column that has the NULLS option specified, for example:
03 FIELDA-I PIC X NULLIND.
03 FIELDA PIC 9(5) COMP NULLS.
Note that if the NULLIND field contains LOW VALUE (binary 0 in every character position), then the
associated column contains data. If it does not contain LOW VALUE, it indicates that the associated
column contains a null value regardless of the value in the associated column.