can we use subquery in mload DELETE command

Tools
Enthusiast

can we use subquery in mload DELETE command

DELETE FROM Employee WHERE Term_date > (subquery)
1 REPLY
Teradata Employee

Re: can we use subquery in mload DELETE command

Try it out!

There is nothing in the Client MultiLoad code that checks for a subquery, so if there is a restriction on that type of operation, then it would be a restriction from Teradata.

-- SteveF