Updating DB2 table from another DB2 table

[MV04]

Hi All,

I am looking for a procedure or some way to update a DB2 table in a DB2 library from another DB2 table in a SAS librray.

The DB2 table which is in DB2 library which needs updating is empty.

[Kurt_Bremser]

If both tables are located in the DBMS, use explicit pass-through to avoid transfer of data to and from SAS.

[MV04]

Thanks for your reply Kurt
How do I do that

[Kurt_Bremser]

Within proc sql, use connect to connect to the DBMS, execute to run the command there, and disconnect to terminate the connection.