InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 15:23:18 GMT20http://www.teradata.com/teradataforum/Topic7037-9-1.aspx//TS@0OBSS JOB (00754533,,,9999),'KANMANI',CLASS=9, <br>// NOTIFY=TS@0OB,MSGCLASS=T <br>/*RESOURCE TERADATA <br>//STEP010 EXEC PGM=BTQMAIN <br>//STEPLIB DD DSN=DB.TS.TERADATA.TDB.APPLOAD,DISP=SHR <br>// DD DSN=SYS2.DB.TDB.TRLOAD,DISP=SHR <br>//INFILE DD DSN=TS@0OB.RDR.BUILD.CTLCARD(DATA),DISP=SHR <br>//SYSPRINT DD SYSOUT=*,DCB=(RECFM=VBA,LRECL=137) <br>//SYSABEND DD SYSOUT=* <br>//SYSTERM DD SYSOUT=* <br>//SAVEDATA DD DSN=TS@0OB.CYCLE.TEST38,DISP=(NEW,CATLG), <br>// UNIT=TDSTG,SPACE=(TRK,(1,1),RLSE), <br>// DCB=(LRECL=80,RECFM=FB,BLKSIZE=800) <br>//SYSIN DD DATA,DLM=## <br>.IMPORT DATA DDNAME=INFILE <br>.EXPORT DATA DDNAME=SAVEDATA <br>.SET SESSIONS 1 <br>.SET ERROROUT STDERR <br>.SET ERROROUT STDERR <br>.LOGON C/KTHIAG2,KTHIAG2 <br>USING CYCLE_TYPE(CHAR(1)), <br>FILLER (CHAR(79)) <br>SELECT CYCLE_NUMBER FROM DMMKP_WORK.WORK_CURRENT_DAILY_CYCLE <br>WHERE CYCLE_TYPE =:CYCLE_TYPE; <br>.EXPORT RESET <br>.QUIT <br>This is my job.I get maxcc=0 but i dont get the o/p in the file.i have given 'D' in ts@0ob.rdr.build.ctlcard(data),i want where cycle_number='D'.<br>Pls tell wats the error in the query,why it is not woking.Tue, 03 Apr 2007 05:12:43 GMTkanmani