Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 28 Feb 2006 @ 08:32:38 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Regarding Preprocessor2 on mainframe
 
From:   Ausanee Klaysuban

Hi,

I'm new customer in Teradata. Our site decided to choose teradata for implementing the new project for Enterprise datawarehouse instead of IBM- MVS. But right now, We have encontering the problem about JCL on the mainframe for PPBMAIN (teradata program on mainframe) after we installed it. Because it cannot work in our site. Fortunately, JCL of MLOAD, FASTLOAD, FASTEXPORT can work.

Now,Teradata technician is solving problem by tell me to modifying JCL for PPBMAIN, and submitting it in 2-3 times but it still has error occured.

Has anyone have a sample JCL for PPBMAIN which can work?

Or my JCL below is not correct, please help to verify.

     //DB25173A JOB (BATCH),ALLD,MSGLEVEL=(1,1),CLASS=A,
     //          MSGCLASS=X,NOTIFY=&SYSUID,REGION=4M,TIME=1440
     //*-------------------------------------------------------*/
     //PRECOMP  EXEC  PGM=PPBMAIN,
     //                 PARM='SQLCHECK NOSYNTAX'
     //STEPLIB    DD    DSN=SYSP.DBCAD.APPLOAD,DISP=SHR
     //                 DD    DSN=SYSP.DBCAD.TRLOAD,DISP=SHR
     //SYSPRINT DD    SYSOUT=*,
     //                 DCB=(LRECL=133,RECFM=FBA,BLKSIZE=1330)
     //SYSTERM  DD    DUMMY
     //SYSIN        DD    DISP=SHR,DSN=SYSP.DBCAD.SAMPLIB(PPCOBLB1)
     //SYSPUNCH DD    DSN=DB25173.COMPILER.INPUT,
     //                 UNIT=SYSDA,SPACE=(TRK,(5,5)),
     //                 DCB=(LRECL=80,RECFM=FB,BLKSIZE=3600),

     //                 DISP=(NEW,CATLG)

     //SYSUT1    DD UNIT=SYSDA,SPACE=(CYL,(5,2)),
     //                DCB=(LRECL=80,RECFM=FB,BLKSIZE=3600)
     /*
     **************************** Bottom of Data *********************

Any help or advice would be appreciated.


Regards,

Ausanee



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016