Archives of the TeradataForum

Message Posted: Wed, 15 Jul 2009 @ 21:00:34 GMT

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

Your insert statement doesn't have a column definition, so it's probably not choking on the number of columns that you specified. It should have a column definition like:

     insert into DB.LOAD_SIMUL (NO_TRY, REQUEST, DTS, DTE)
     SELECT something is wrong at this place
     1
     , SUBSTRING(QueryText,9,7)
     ,StartTime
     ,LastRespTime
     from DBC.QryLog
     where Username = 'dummy'
     and StartTime between '2009-07-13 14:54:00.00' and '2009-07-13 15:32:00.00';

Also, REQUEST is a keyword.

iv

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