zOs/TX/VV71UNLJ
//YVVUNL01 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P001.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P001.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P002.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P003.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P004.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 1)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 1)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 2)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 2)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 3)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 3)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 4)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 4)
order by vv719002 asc
;
//YVVUNL02 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P005.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P005.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P006.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P007.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P008.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 5)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 5)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 6)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 6)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 7)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 7)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 8)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 8)
order by vv719002 asc
;
//YVVUNL03 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P009.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P009.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P010.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P011.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P012.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 9)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 9)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 10)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 10)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 11)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 11)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 12)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 12)
order by vv719002 asc
;
//YVVUNL04 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P013.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P013.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P014.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P015.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P016.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 13)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 13)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 14)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 14)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 15)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 15)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 16)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 16)
order by vv719002 asc
;
//YVVUNL05 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P017.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P017.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P018.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P019.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P020.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 17)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 17)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 18)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 18)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 19)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 19)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 20)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 20)
order by vv719002 asc
;
//YVVUNL06 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P021.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P021.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P022.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P023.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P024.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 21)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 21)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 22)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 22)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 23)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 23)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 24)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 24)
order by vv719002 asc
;
//YVVUNL07 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P025.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P025.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P026.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P027.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P028.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 25)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 25)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 26)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 26)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 27)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 27)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 28)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 28)
order by vv719002 asc
;
//YVVUNL08 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P029.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P029.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P030.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P031.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P032.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 29)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 29)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 30)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 30)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 31)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 31)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 32)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 32)
order by vv719002 asc
;
//YVVUNL09 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P033.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P033.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P034.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P035.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P036.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 33)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 33)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 34)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 34)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 35)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 35)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 36)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 36)
order by vv719002 asc
;
//YVVUNL10 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P037.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P037.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P038.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P039.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P040.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 37)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 37)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 38)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 38)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 39)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 39)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 40)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 40)
order by vv719002 asc
;
//YVVUNL11 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P041.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P041.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P042.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P043.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P044.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 41)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 41)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 42)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 42)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 43)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 43)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 44)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 44)
order by vv719002 asc
;
//YVVUNL12 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P045.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P045.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P046.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P047.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P048.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 45)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 45)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 46)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 46)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 47)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 47)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 48)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 48)
order by vv719002 asc
;
//YVVUNL13 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P049.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P049.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P050.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P051.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P052.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 49)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 49)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 50)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 50)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 51)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 51)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 52)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 52)
order by vv719002 asc
;
//YVVUNL14 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P053.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P053.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P054.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P055.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P056.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 53)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 53)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 54)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 54)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 55)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 55)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 56)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 56)
order by vv719002 asc
;
//YVVUNL15 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P057.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P057.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P058.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P059.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P060.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 57)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 57)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 58)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 58)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 59)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 59)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 60)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 60)
order by vv719002 asc
;
//YVVUNL16 JOB (CP00,KE50),
// 'CATALOG',MSGCLASS=T,TIME=1440,
// NOTIFY=&SYSUID,REGION=0M
//*MAIN CLASS=LOG
//P01 EXEC PGM=IKJEFT01,
// DYNAMNBR=200,
// TIME=99
//SYSTSIN DD *
DSN SYSTEM(DBOF)
RUN PROGRAM(DSNTIAUL) PARMS('SQL')
END
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSPUNCH DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P061.PUN,
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000),
// SPACE=(TRK,(1,1)),
// MGMTCLAS=COM#A064
//SYSREC00 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P061.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC01 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P062.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC02 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P063.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSREC03 DD DISP=(NEW,CATLG),DSN=DSN.VVUNL.DBOF.T719P064.UNL,
// SPACE=(CYL,(1000,500)),
// DCB=(RECFM=FB,BLKSIZE=31728),
// MGMTCLAS=COM#A064,DATACLAS=EYY0X
//SYSIN DD *
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 61)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 61)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 62)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 62)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 63)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 63)
order by vv719002 asc
;
select t.*
from oA1P.tvv719a1 t
where vv719002 > (select VV719002von
from A540769.TVV719Limits
where part = 64)
and vv719002 <= (select VV719002bis
from A540769.TVV719Limits
where part = 64)
order by vv719002 asc
;