Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2012 @ 19:36:55 GMT

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

Dear esteemed DBAs,

Thank you always for taking time to read the questions and answer. TD 13.0 on Windows.

I've run below macro and gotten an error saying, "INSERT Failed. 3939. There is a mismatch between the number of parameters specified and the number of parameters required."

I counted the number of columns in 'Insert Into' and 'Select' and they are exactly same. I suspect the parameter 'days_back' causes the error. Could you tell me what I should change in this code?

     Replace Macro SYS_HIST.LoadDBQLTmp
      (days_back  integer)
      AS (
     /* Part of the Daily Process.  Loads DBQL Tmp Tables*/

     LOCKING TABLE DBC.DBQLOGTBL FOR ACCESS
     Insert into SYS_HIST.DBQLogTbl_Tmp
     (
      .
     .
     )
     Select
     .
     .
     From DBC.dbqlogtbl
     where cast(CollectTimeStamp as date) < current_date - :days_back;

     );

Thanks,

James Park
Database Specialist II

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