0 - 5 of 5 tags for 3707

Below if the SQL I am trying to get to run. I am receiving the following error message upon execution: SELECT Failed 3707 Syntax error, expected something like an 'EXCEPT' keyword or an 'UNION' keyword or

a 'MINUS' keyword between ')' and the word 'z'

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.

replace procedure myprocess(in p_date date)

 

Begin

 

insert into my_table(field_1,field_2)

 

with tmp_tab(field1,field2,field3) as

 

(select field1,field2,field3

 

    From my_table2)

 

select field1,field2

 

replace procedure myprocess(in p_date date)

 

Begin

 

insert into my_table(field_1,field_2)

 

with tmp_tab(field1,field2,field3) as

 

(select field1,field2,field3

 

    From my_table2)

 

select field1,field2

 

replace procedure myprocess(in p_date date)

 

Begin

 

insert into my_table(field_1,field_2)

 

with tmp_tab(field1,field2,field3) as

 

(select field1,field2,field3

 

    From my_table2)

 

select field1,field2