17.00 - Program Setup - IBM CICS Interface for Teradata

IBM CICS Interface for Teradata® Reference

prodname
IBM CICS Interface for Teradata
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2448-220K

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.