Archives of the TeradataForum

Message Posted: Sun, 07 Nov 2004 @ 18:57:11 GMT

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

Thanks Michael , But please let me know how do I execute the following 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 in a MVS environment . Please make corrections if I am wrong in the syntax .

Here INPUT1 is a ddname for input and DATAIN is the ddname for output . I'm using BTQMAIN load library .

Thanks & Regards

Parijat Mukherjee

Accenture Bangalore DC

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