Code: |
UNLOAD CNTLCARDS DB2LOAD 'LOG NO REPLACE ENFORCE NO'
SHRLEVEL CHANGE DIRECT NO SELECT * FROM Table A WHERE col1 = 'X' OR Col2 < CURRENT DATE + 60 DAYS |
Code: |
OR Col2 < CURRENT DATE + 60 DAYS
@ |
Code: |
//STEP0100 EXEC PGM=IKJEFT01 //SYSTSPRT DD SYSOUT=*,DCB=BLKSIZE=121 //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(XXXX) RUN PROGRAM(DSNTIAUL) - PLAN(DSNTIAUL) - PARMS('SQL') - LIB('XXXX.RUNLIB.LOAD') //SYSREC00 DD DSN=YOUR UNLOAD FILE, // DISP=(NEW,CATLG,DELETE), // UNIT=SYSDA, // SPACE=CYL,(1,1),RLSE) //SYSPUNCH DD SYSOUT=* //SYSIN DD * SELECT * FROM Table A WHERE col1 = 'X' OR Col2 < CURRENT DATE + 60 DAYS /* |
Code: |
SELECT * FROM Table A WHERE col1 = 'X' OR Col2 < (SELECT DATE(CURRENT DATE + 60 DAYS) FROM SYSIBM.SYSDUMMY1) |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours