Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 May 2004 @ 16:06:46 GMT


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


Subj:   Need help with 3706: Syntax Error
 
From:   Pattisapu, Hari

I am trying to create a audit log table for my process I am here with using this query which is failing due to the following error could any one help me with how i can accomplish this.

     SELECT 'BTEQ_INS', '&SYSDATE4', '&SYSTIME',
     'Database_name', 'Job name',
     &SYSINSCNT, &SYSUVCNT, &SYSETCNT, &SYSUPDCNT,
     &SYSDELCNT, &SYSRC, '&SYSUSER', 'Program name';

the following is the error

     Code = 3706.
     3706:  Syntax error: expected something between ',' and the end of the request.
     Output directed to Answer set window

Thanks



     
  <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