All Forums Tools
anilmnt82 11 posts Joined 05/08
16 Mar 2009
can we use subquery in mload DELETE command

DELETE FROM Employee WHERE Term_date > (subquery)

ANIL K
feinholz 1234 posts Joined 05/08
16 Mar 2009

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

You must sign in to leave a comment.