framework/resources/Functional/cttas/cttas_08_wpby.sql

CREATE TEMPORARY TABLE temp_tbl_8wp PARTITION BY ( col_chr, col_bln )
AS
SELECT col_int, col_chr, col_vrchr1, col_vrchr2, col_dt, col_tim, col_tmstmp, col_flt, col_intrvl_yr, col_intrvl_day, col_bln 
FROM typeall_l;
SELECT COUNT(*) FROM temp_tbl_8wp;
DROP TABLE temp_tbl_8wp;