db2 connect to ***db2 "DECLARE C1 CURSOR DATABASE *** USER *** using dba FOR select "CMPTTR_PD_INST_ID", "CLNDR_DT_ID", "CITY_ID", "SETT_BUSI_TP_ID", "PD_SPEC_TP_ID", "TSP_TP_ID", "ORGNL_CMPTTR_ACCS_NMBR", "CMPTTR_AREA_CD", ...
显示全部db2 connect to ***
db2 "DECLARE C1 CURSOR DATABASE *** USER *** using dba FOR select "CMPTTR_PD_INST_ID", "CLNDR_DT_ID", "CITY_ID", "SETT_BUSI_TP_ID",
"PD_SPEC_TP_ID", "TSP_TP_ID", "ORGNL_CMPTTR_ACCS_NMBR", "CMPTTR_AREA_CD",
"CMPTTR_ACCS_NMBR", "FRST_CALL_DT", "LAST_CALL_DT", "PRE_CALL_DT",
"LOST_DT", "ADD_F", "LOST_F", "EXIST_F", "ARRIVE_F", "CDR_DT", "CRTD_TMST"
, "LAST_UPDT_TMST", "WORK_DT" from BML.CMPTTR_PD_INST_DAILY_INFO where clndr_dt_id=20101231 and city_id='B' fetch first 100 rows only with ur"
db2 "LOAD FROM C1 OF CURSOR insert INTO BML.CMPTTR_PD_INST_DAILY_INFO"
db2 "commit"
db2 terminate
这是我的脚本load.sh
执行正常结束但是在表中却没有找到任何数据。
望大虾赐教一二，顺带讲解下load！
收起