Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Error in running a macro: INSERT Failed.
 
From:   JAMES PARK

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023