zOs/SQL/YVV326WX
$#@ 00010000
$** say "sql1='"$sql1"'" 00011000
$=cnt=1000 00020000
call sqlConnect dbof 00020100
m.timing_say = 1 00020200
call timing , , 'start' 00021000
call sqlUpdate 7, "delete from A540769.qzScanKey" , 00030000
"where partition_number = 2 " 00030100
call timing , , 'deleted' m.sql.7.updateCount 00030200
call sqlUpdate 7, "insert into A540769.qzScanKey" , 00031000
" (partition_number, temp_dbKey, OUT_IDSYMBOL_2) " , 00040000
" select 2, temp_dbKey, OUT_IDSYMBOL_2" , 00050000
"from A540769.qzScanKey where partition_number = 7 " , 00060000
"fetch first" $cnt "rows only" 00070000
call timing , , 'inserted' m.sql.7.updateCount 00071000
call sqlQuery 7, $sql1 00071100
do fx=1 while sqlFetch(7, ff) 00071200
/* say fx m.ff.instrumentId */ 00071300
end 00071400
call sqlClose 7 00071500
call timing , , 'selected' (fx-1) 00071600
call sqlUpdate 7, "delete from A540769.qzScanKey" , 00071700
"where partition_number = 2 " 00071800
call timing , , 'deleted' m.sql.7.updateCount 00071900
$ct $=-=/sql1/ 00072000
SELECT OUT_IDSYMBOL_2, INSTRUMENTID 00072300
,'CH ' 00072400
,ROWSTATUS_FLTSYMB 00072500
,SYMBOLCSFI,SYMBOLCH 00072600
,SYMBOLISIN 00072700
,SYMBOLUS 00072800
,SYMBOLGB 00072900
,SYMBOLDE,CATEGORYVDPS,CATEGORYCSGTA,CSSTATUSTYPE_FLTSYMB 00073000
,CSRISKINDIDSYMBOL,CSRISKINDSCHEMESYM,CSRISKINSTGRPIDSYM 00073100
,CSRISKINSGRPSCHSYM,CSRISKCURRENCY_I1,CSRISKCURRENCY_I2 00073200
,CSRISKCURRENCY_WS80,CSRISINSTRUMENT_CH 00073300
,CSRISKCOUNTRY_A2 00073400
,CSRISKCOUNTRY_WS80,UNDERINSTRUMENT_CH 00073500
,UNDERINSTRUMENT_ISIN 00073600
,UNDERINSTRUMENT_CSFI,ORIGINALISSUER_GK 00073700
,ISSUER_GK,COMMISSIONCODETYPE 00073800
,CSFUNDTYPE,NAME45_G,NAME45_E,NAME45_F,NAME45_I 00073900
,NAME45_N 00074000
,STATUSTYPE_ORG_ISSUER,INDUSTRYCS_ORG_ISSUER 00074100
,INDUSTRYTKBN_ORG_ISSUER 00074200
,INDUSTRYMSCI_ORG_ISSUER,SHORTNAME_G_ORG_ISSUER 00074300
,SHORTNAME_E_ORG_ISSUER,SHORTNAME_F_ORG_ISSUER 00074400
,SHORTNAME_I_ORG_ISSUER 00074500
,SHORTNAME_N_ORG_ISSUER,STATUSTYPE_ISSUER,INDUSTRYMSCI_ISSUER 00074600
,SHORTNAME_G_ISSUER 00074700
,SHORTNAME_E_ISSUER,SHORTNAME_F_ISSUER 00074800
,SHORTNAME_I_ISSUER,SHORTNAME_N_ISSUER,CSPRODUCTCATEGORY 00074900
,UPDATETIMESTAMP_INSTR,ISCSRISKASPECTOTC 00075000
,ISCSRISKASPECTCOMMODITIES 00075100
,ISCSRISKASPECTREALESTATE,ISCSRISKASPECTEM 00075200
,RISKINADVICEDSERVICE 00075300
FROM A540769.qzSCANKEY k 00075400
INNER JOIN OA1P.VVV_IDS_VINOP9000 00075500
ON OA1P.VVV_IDS_VINOP9000.INSTRUMENTID 00075600
= k.TEMP_DBKEY 00075700
WHERE k.PARTITION_NUMBER = 2 00075800
WITH UR 00075900
FOR FETCH ONLY 00076000
$/sql1/ 00085000
$#out 20140511 11:46:15 00085100
SQLCODE = 100, NOT FOUND: ROW NOT FOUND FOR FETCH, UPDATE, OR 00085200
DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE 00085300
sql = delete from A540769.qzScanKey where partition_number = 2 00085400
$#out 20140511 11:45:32 00085500
SQLCODE = 100, NOT FOUND: ROW NOT FOUND FOR FETCH, UPDATE, OR 00085600
DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE 00085700
sql = delete from A540769.qzScanKey where partition_number = 2 00085800
$#out 20140511 11:44:54 00085900
$#out 20140511 11:43:29 00086000
$#out 20140511 11:40:28 00087000