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.