topic Updating DB2 table from another DB2 table in New SAS User

Updating DB2 table from another DB2 table

MV04 — Wed, 08 May 2019 10:30:14 GMT

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 — Wed, 08 May 2019 11:14:20 GMT

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

MV04 — Wed, 08 May 2019 11:22:26 GMT

Thanks for your reply Kurt
How do I do that

Kurt_Bremser — Wed, 08 May 2019 12:07:52 GMT

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