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 ...

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 ...