Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Aug 2004 @ 17:00:41 GMT


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


Subj:   Question regarding EXPORT
 
From:   Agrawal, Saurabh

Hi,

I am trying to generate a SQL using a SQL as shown, through a JCL.

     //BTEQ01  EXEC PGM=BTQMAIN,REGION=4M
     //STEPLIB  DD  DSN=SYS1.NCRTDP.APPLOAD,
     //             DISP=SHR
     //         DD  DSN=SYS1.NCRTDP.TRLOAD,
     //             DISP=SHR
     //         DD  DSN=PM00.MISPROD.PLOAD,
     //             DISP=SHR
     //SYSUDUMP DD  SYSOUT=*
     //SYSOUT   DD  SYSOUT=*
     //SYSPRINT DD  SYSOUT=*,
     //             DCB=(LRECL=137)
     //SYSABEND DD  SYSOUT=*
     //SYSTERM  DD  SYSOUT=*
     //SYSIN    DD  DSN=UAGARS1.TERADATA.LOGON,DISP=SHR
     //         DD  *
         .EXPORT DDNAME = SQLOUT
         .FORMAT OFF
         .TITLEDASHES OFF
          SELECT
           'SELECT * FROM UAGARS1.RAJIV_OY1D;';
     */
     //SQLOUT  DD  DSN=NM00.UAGARS1.BTEQJCLA,
     //             DISP=(MOD,CATLG,DELETE),
     //             UNIT=MISPCK,
     //             SPACE=(CYL,(1,1),RLSE),
     //             DCB=(RECFM=FB,LRECL=80)
     //*-------------------------------------------

The output file is as shown:

     ********************************* Top of Data ***
     'SELECT * FROM UAGARS1.RAJIV_OY1D;'
     SELECT * FROM UAGARS1.RAJIV_OY1D;
     ******************************** Bottom of Data ***

I just want the 2nd statement and donot want the 1st statement. Can anyone help..? Do I need to put some more condition for my EXPORT...??


Thanks

Saurabh



     
  <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