Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: BTEQ Examples
 
From:   Mary Lou Arundell

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016