Archives of the TeradataForum

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

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

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