Zero records are fetching when using where statement in TPT

Tools & Utilities
Teradata Employee

Re: Zero records are fetching when using where statement in TPT

As I indicated, you have to write a script for this, not use Easy Loader.

We currently have a bug when using Easy Loader and the quotes are being stripped.

Thus, if you want to use a SELECT statement with embedded single-quotes, you will have to write a script.

(A TPT script, not a Perl script.)

-- SteveF
Enthusiast

Re: Zero records are fetching when using where statement in TPT

Hi,

After using LOCK TABLE MY_TABLE EXCLUSIVE

I have an update request

Then , I want to add something like RELASE LOCK from MY_TABLE after the update, in case of fail.

Is it possible in Teradata (14) please ?

Ghalia