Archives of the TeradataForum

Message Posted: Sun, 07 Nov 2004 @ 18:59:58 GMT

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

Hi ,

I am trying to perform a BTEQ export as :(BTEQ Script)

     .LOGTABLE LOAD_WORK.LOG_TABLE_CLPR_FE1;
     .RUN FILE LOGON1;
     .IMPORT DATA DDNAME=INPUT1;
     .EXPORT DATA  DATAIN ;
     USING (curryyy char(6))
     SELECT 'INSERT INTO xx.aggregate_table_'||
     cast((add_months(calendar_date, -1)
     (format 'yymm') (char(4))) as CHAR(4))
     from Sys_Calendar.CALENDAR where
     calendar_date (format 'yyyymmdd')(char(8))=:curryyy||'01';
     SELECT 'select * from xx.pp' ;
     .EXPORT RESET ;
     .RUN FILE=DATAIN;
     .LOGOFF ;

i am executing this file using a job step :

     //STEP1  JCLLIB ORDER=(RDWT.NBSP.NBS.PROCLIB)
     //JOBLIB  DD DSN=SYS3A.TERADATA.APPLOAD,DISP=SHR
     //        DD DSN=SYS3A.TERADATA.TRLOAD,DISP=SHR
     //MLOADRUN EXEC XPORT3,
     //          LOGON='RDWT.NBSP.PRVT.LOGON(EDW1LOAD)', /* logon file */
     //          SYSIN2='(BTEQ Script)',
     //          DATAIN1='RDWT.DSA.SORIN.TEST(TEST)',/* input file */
     //          DATAIN2='RDWT.DSA.SORIN.CE1' /* output file */

which expands the following proc :

     //XPORT3  PROC
     //MLOADSTP   EXEC PGM=BTQMAIN
     //SYSPRINT DD SYSOUT=*
     //SYSIN DD DSN=&LOGON,DISP=SHR
     //STEP2  EXEC PGM=XPORT
     //SYSUDUMP DD SYSOUT=I
     //SYSOUT   DD SYSOUT=I
     //SYSPRINT DD SYSOUT=*
     //LOGON1 DD DSN=&LOGON,DISP=SHR
     //DATAIN  DD  DSN=&DATAIN2,DISP=(MOD,CATLG,DELETE),
     //             DCB=(RECFM=FB,LRECL=1600,BLKSIZE=16000),
     //             SPACE=(CYL,(1000,1000),RLSE)
     //INPUT1   DD DSN=&DATAIN1,DISP=SHR
     //SYSIN    DD DSN=&SYSIN2,DISP=SHR

Now the poblem is on executing it gives error saying the syntax of .import is wrong , but I have read in the manuals as it is .Can some one urgently let me know how to correct this problem please suggest changes in any of these files .

Thanks & Regards,

Parijat

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