All Forums Tools
chk32 14 posts Joined 11/13
27 Aug 2015
TPT10508: RDBMS error 3707: expected some thing bet 'UDFCALLNAME' keyword between the 'USING' keyword and the 'DELETE' keyword.

Hi All,
 
I am facing with the below TPT error. I am not sure where to correct the code.

 

**** 18:42:33 TPT10508: RDBMS error 3707: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between the 'USING' keyword and the 'DELETE' keyword.

Define Job DeleteJob
Description 'DelesData'
(
Define Operator Update_Operator
Description 'TPT  Update Operator'
Type Update
Schema *
Attributes
(integer maxsessions = 12
,integer minsessions = 2
,integer maxdecimaldigits = 38
,varchar targettable = 'TableA'
,varchar tdpid = 'tspid'
,varchar username = 'Loonid'
,varchar userpassword = 'password'
,varchar errortable1 = 'TABLEET'
,varchar errortable2 = 'TABLEUV'
,varchar logtable = 'TABLELT'
,varchar worktable = 'TABLEWT'
,varchar workingdatabase = '{LogDB}'
);
 
 
APPLY
(
'DELETE FROM TableA WHERE Process_Date <= ''20150101'';'
)
 To Operator ( Update_Operator [1] );
);

 
Please help in resolving issue.  
Thanks in advance

 

Glass 225 posts Joined 04/10
27 Aug 2015

You can try adding 
VARCHAR DeleteTask = 'Y'
to your attributes.
 
 
Rglass

chk32 14 posts Joined 11/13
01 Sep 2015

Thanks Glass it worked for me.. 
 
One more clarification pls..
In my above code only one errortable is generated even though i declared two errortables(errortable1,errortable2).
Why is it happening. I have a similar TPT along with export operator it is generating two errortables. Could you please help me in understanding this.

feinholz 1234 posts Joined 05/08
01 Sep 2015

The DELETE task in the Update operator is an Application Phase operation only.
And thus, only the UV error table is needed.
On a regular import task, 2 error tables are needed (one for the Acquisition Phase and one for the Application phase).

--SteveF

chk32 14 posts Joined 11/13
01 Sep 2015

Thanks Steve

You must sign in to leave a comment.