Archives of the TeradataForum
Message Posted: Tue, 31 Jan 2012 @ 19:36:55 GMT
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; );
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|