Archives of the TeradataForum

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

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

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>>