**isqlj ds**

1.as3:/u1/tiptop> isqlj ds
2.Q/查詢語言
3.C/選擇
4.copy_test
5.U/使用編輯器
6.delete 離開

=====unload語法=========================
unload to aed_ds1.txt
select * from ds1:aed_file
where aed03='2008' and aed04='12';

delete from ds:aed_file
where aed03='2008' and aed04='12';

load from aed_ds1.txt
insert into ds:aed_file;

========================================
unload to ima_ds1.txt
select * from ds1:ima_file
where ima901 BETWEEN '20081201' and '20081231';

delete from ds:ima_file
where ima901 BETWEEN '20081201' and '20081231';

load from ima_ds1.txt
insert into ds:ima_file;
arrow
arrow
    全站熱搜

    mosful 發表在 痞客邦 留言(0) 人氣()