**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;
全站熱搜