Data Build Manual

Supported and Unsupported Data Types
Introduction to Data Build
099331 Tandem Computers Incorporated 1–3
Supported and
Unsupported
Data Types
Data Build supports data types that are typically found in business applications. The
data types not supported by Data Build are those used mainly in scientific and graphic
applications. You can customize Data Build to handle the unsupported data types.
Table 1-1 shows the COBOL and DB2 input data types supported by Data Build. Table
1-2 shows the COBOL and DB2 input data types that are not supported by Data Build.
Table 1-1. Supported Data Types
COBOL Data Type DB2 Data Type Data Description
DISPLAY CHAR Character display
Unsigned numeric display data
PIC S9(n) DISPLAY SIGN
SEPARATE
Numeric display with sign leading separate
VARCHAR Varying-length character
Supported for IXF input
User customization for non-IXF data
COMP-3 DECIMAL IBM Packed decimal
COMP
COMP-4
INTEGER Full-word binary; PIC 9(n) where n is
greater than 4
COMP
COMP-4
SMALLINT Half word binary; PIC 9(n) where n is less
than 5
DATE Exploded date (yyyy-mm-dd)
TIME Exploded time (hh.mm.ss)
TIMESTAMP Exploded date and time stamp
(yyyy-mm-dd-hh.mm.ss.nnnnnn)
Table 1-2. Unsupported Data Types
COBOL Data Type DB2 Data Type Data Description
COMP-1 FLOAT Short-precision floating point
COMP-2 FLOAT Long-precision floating point
LONG
VARCHAR
Long varying-length character
GRAPHIC Fixed-length graphic
VARGRAPHIC Varying-length graphic
LONG
VARGRAPHIC
Long varying-length graphic
PIC S9(n) DISPLAY
without COMP
without SIGN SEPARATE
Numeric display with embedded sign
PIC S9(n) DISPLAY
SIGN TRAILING SEPARATE
without COMP
Numeric display with sign trailing separate