CREATE SET TABLE d_eiadb.dqrs_base_data ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
cus_idr DECIMAL(11,0),
exception_no INTEGER,
exception_val VARCHAR(10) CHARACTER SET LATIN CASESPECIFIC,
date_added DATE FORMAT 'yyyy-mm-dd',
date_resolved DATE FORMAT 'yyyy-mm-dd',
number_of_months INTEGER,
staff_number DECIMAL(8,0))
PRIMARY INDEX ( cus_idr ,exception_no ,date_added );
112501605., 1
112501605., 1
112718384., 1
112706421., 1
198001800., 1
138500741., 1
112713438., 1
.logtable d_eiadb.temp_log;
.logon tdps/balasubramanianr,cricket52;
.begin export sessions 8;
Select substring(cast(cus_idr as char(10)) from 1 for 10)||',',
cast(count(*) as char(3))
from d_eiadb.dqrs_base_data
where cus_idr <= 232807215
group by 1;
.export outfile testdate.out mode record format text;
/* --unformat; */
/* .export outfile testdate.out format fastload mode indicator; */
.end export;
Thanks,