Errortables creation for Update operator in TPT

Tools & Utilities
Enthusiast

Errortables creation for Update operator in TPT

Hi All,

I have a TPT script with only update operator and with declared two error tables(errortable1,errortable2) but only one errortable2 is getting generated while run. why first error table is not generated.

I am using same tpt script along with export operator which generates two error tables.

Please help me in understanding that why my TPT with only update operator is considering only one error table even if I define two error tables.

Thanks in advance

 

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 = '{MaintBT}.{TBName}'
,varchar tdpid = '{tdp_to}'
,varchar username = 'Loonid'
,varchar userpassword = 'password'
,varchar errortable1 = 'TableA_ET'
,varchar errortable2 = 'TableA_UV'

,varchar logtable = 'TableA_LT'
,varchar worktable = 'Table_WT'
);

APPLY
(
'DELETE FROM TableA WHERE Process_Date <= ''20150101'';'
)
To Operator ( Update_Operator [1] );
);

 

2 REPLIES
Teradata Employee

Re: Errortables creation for Update operator in TPT

This was asked already in another thread, and answered:

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
Enthusiast

Re: Errortables creation for Update operator in TPT

Thanks Steve..