A trigger may be fired for any given data modification language (DML) SQL statement. These statements include INSERT, UPDATE, and DELETE, and each event may have its own trigger. It’s also ...

See Using DBMS Data in Version 7 and Version 8 for examples. If you are using descriptors, you can specify them in the SQL procedure's INSERT, DELETE, and UPDATE statements. You can also use these ...

you can also use RSPT to send non-query SQL statements to a remote DBMS. For example, proc sql; connect to remote (server=sunserv dbms=oracle); execute (delete from parts.inventory where ...