Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2000 @ 22:58:37 GMT

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

Here's a sample from my library.

     //JOB CARD
     //*
     //NCR4700 JCLLIB ORDER=S37TD3.PROCLIB         < where your BTEQ proc lives
     //*
     //JB01 EXEC TDSBTEQ
     //LOG  DD  DSN=S47DBA.BTEQ.LIB(CTLACCAD),     < We log on from a library member.
     //         DISP=SHR                           < login member looks like this:
     //SYSPRINT DD SYSOUT=*                        < .LOGON = 2/userid,password;
     //REGIST   DD DSN=some.file.name,
     //            DISP=(,CATLG,DELETE),
     //            UNIT=SYSDA,
     //            SPACE=(TRK,(30,15),RLSE),
     //            DCB=(LRECL=160,RECFM=FB)
     //SYSIN DD *
        /* indent your comments */
        /* the .RUN could be replaced with the instream login statement */
     .RUN DDNAME=LOG;
     .EXPORT DATA DDNAME = REGIST;
      SELECT
            regular SQL statement
      ;
     LOGOFF;
     /*
     //

Hope this is useful.

Mary Lou Arundell
Database Systems Analyst
University of Cincinnati

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