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.)
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 ?