Program Setup - IBM CICS Interface for Teradata

IBM CICS Interface for Teradata Reference

Product
IBM CICS Interface for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2448
lifecycle
previous
Product Category
Teradata Tools and Utilities

Program Setup

Execute the following BTEQ script to create the HUTestResults table:

CREATE TABLE HUTestResults, FALLBACK
             (
             SourceOfRow         VARCHAR(30)  ,
             ROWNUMBER           INTEGER      ,
             col001              BYTE(4)      ,
             col002              BYTEINT      ,
             col003              CHAR(8)      ,
             col004              DATE         ,
             col005              DECIMAL(8,3) ,
             col006              FLOAT        ,
             col007              INTEGER      ,
             col008              SMALLINT     ,
             col009              VARBYTE(8)   ,
             col010              VARCHAR(15)
             )
        PRIMARY INDEX (SourceOfRow, ROWNUMBER) ;

COL001 and COL009 are not fetched during the select because their data types are BYTE and VARBYTE, respectively, and these data types are not supported by the PL/I PP2.