• Print |
• E-mail  |
• Bookmark

Starting in Version 8, PROC DB2UTIL's SSID= option does not work
correctly.  Rather than connecting to the subsystem specified it is
connecting to the default subsystem.  As a result, the wrong table is
being looked for and will possibly be updated.  To avoid this problem,
you must specify the DB2 subsystem that you want to connect to by
setting the SAS system option DB2SSID=.

For example, valid Release 6.09E syntax:

   proc db2util data=sas_ds table=db2_table ssid=db2p function=i;
   mapto sasvar1 = db2var1 sasvar2 = db2var2;
   update;
   run;

converted to the following for Version 8:

   options db2ssid=db2p;

   proc db2util data=sas_ds table=db2_table function=i;
   mapto sasvar1 = db2var1 sasvar2 = db2var2;
   update;
   run;

A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009054

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#009054

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: