DSXchange

The delete stmt works fine in toad and also I have created a DataStage job just to delete the rows and it works fine, looks like it doesnt work in OPEN command!

What is invalid about the stmt, can you elaborate or post a valid stmt for delete.

Thanks,

Tried to use all of the following stmts in the OPEN command of oracle enterprise stage (DS 7.5.1) and get the above error, did anyone get a resolution on this ? 'DELETE FROM TABLE1' 'DELETE FROM TABLE1;' "DELETE FROM TABLE1" "DELETE FROM TABLE1;" DELETE FROM TABLE1 I am using the...

Oracle call failed; sqlcode = -900; message: ORA-00900: invalid SQL statement. Tried to use all of hte following stmts in the open command of oracle enterprise stage (DS 7.5.1) and get the above error, did anyone get a resolution on this ? 'DELETE FROM TABLE1' 'DELETE FROM TABLE1;' "DELETE FROM...