//A540769S JOB (CP00,KE50),'DB2 REO', 00000110
// MSGCLASS=T,TIME=1440, 00000210
// NOTIFY=&SYSUID,REGION=0M,SCHENV=DB2 00000310
//*MAIN CLASS=LOG 00000410
//S01 EXEC PGM=IKJEFT01,DYNAMNBR=200,TIME=99 00000910
//SYSTSIN DD * 00001010
DSN SYSTEM(DBOF) 00001110
RUN PROGRAM(DSNTEP2) PARMS('ALIGN(LHS)') PLAN(DSNTEP2) 00001210
//SYSTSPRT DD SYSOUT=* 00001310
//SYSPRINT DD SYSOUT=* 00001410
//SYSUDUMP DD SYSOUT=* 00001510
//SYSTERM DD DUMMY 00001610
//SYSIN DD * DISP=SHR,DSN=A540769.WK.SQL(TESTQMSL) 00001710
select count(*) from A540769.qzScanKey; 00001808
select current timestamp from sysibm.sysDummy1; 00001909
insert into A540769.qzScanKey 00002006
(partition_number, temp_dbKey, OUT_IDSYMBOL_2) 00002106
with s as 00002206
( 00002306
select instrumentId 00002406
from vdps2.VTINSTRFLATSYMBOLS 00002506
where mod(instrumentid, 999983) between 0 and 1000 00002608
order by mod(instrumentid, 999983) 00002708
) 00002808
select 7 , instrumentId, 'abc' || instrumentid 00002908
from s 00003008
; 00003108
select current timestamp from sysibm.sysDummy1; 00003208
commit; 00003308
;x; 00003408
select instrumentId 00003508
from vdps2.VTINSTRFLATSYMBOLS 00003602
order by mod(instrumentid, 999983) 00003705
fetch first 100 row only 00003805
with ur 00004002
; 00004105
select current timestamp from sysibm.sysDummy1; 00004205
;x; 00005005
select min(instrumentId), max(instrumentId) 00010000
from vdps2.VTINSTRFLATSYMBOLS 00020000
where instrumentid > 30000000 00021001
with ur 00030000