Complex SQL, DIRECT YES

//UNLOAD   EXEC PGM=NGTUTIL,PARM='ssid,,NORESTART'          
//*                                                         
//UTPRINT   DD SYSOUT=*                                     
//SYSPRINT  DD SYSOUT=*                                     
//SYSTSPRT  DD SYSOUT=*                                     
//OBJREPRT  DD SYSOUT=*                                     
//*                                                         
//SYSIN     DD *                                           
 OUTPUT SYSREC  DSNAME hlq.OUTDATA.&TS..P&PART..T&TIME
 UNLOAD                                                   
   DIRECT YES                                             
      SELECT * FROM creator.table01                    
       WHERE COL01 IN                                     
         (SELECT col01 FROM creator.table02            
           WHERE col26 < CURRENT_DATE - 6 MONTHS)
/*