Re: Delete Syntax in MLOAD

Tools

Re: Delete Syntax in MLOAD

Hi,

I need to delete the rows from table in mload script which are not matching in the file.

Tried couples of ways but couldn't succeed.

DELETE FROM Employee WHERE EmpNo <> :EmpNo and EmpName <> :Empname;

UTY0805 RDBMS failure, 3537: A MultiLoad DELETE Statement is Invalid.

DELETE FROM Employee WHERE (EmpNo,EmpName) NOT IN (:EmpNo,:Empname);

UTY0805 RDBMS failure, 3707: Syntax error, expected something like

     a 'SELECT' keyword or '(' or a 'NONTEMPORAL' keyword or 'AS' keyword or '('

     between '(' and ':'

Please help

Thanks

Balu

1 REPLY
Teradata Employee

Re: Re: Delete Syntax in MLOAD

In a standard BEGIN [IMPORT] MLOAD, the DELETE statement must specify values for the PI with equality condition, just as an UPDATE would. Or you can use BEGIN DELETE MLOAD and non-PI equality WHERE condition. Check the manual for details.