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.