Archives of the TeradataForum

Message Posted: Thu, 13 May 2004 @ 18:16:20 GMT

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

<-- Anonymously Posted: Thursday, May 13, 2004 13:45 -->

Missing single quotes around some of your items is causing the error... You had them around the 1st two, so I am assuming that you intended to do this in all instances.

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

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