Program Setup - IBM CICS Interface for Teradata

IBM CICS Interface for Teradata® Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
IBM CICS Interface for Teradata
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
nmw1695364801820.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
axu1470436513048
Product Category
Teradata Tools and Utilities

Execute the following BTEQ script to create the HUTestResults table:

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 COBOL PP2.