Good morning: I am trying to access tables in our corporate IBM DB2 database using ODBC. I can SCONNECT to the database but when I try to SATTACH to the tables I get an error message as follows: [IBM][CLI Driver][DB2/6000]SQL0204N "CWMTMAR.SSSPEC" is an undefined name. SQLSTATE=42704
The CWMTMAR.SSSPEC consists of my user id of CWMTMAR and the table name of SSSPEC. When the list of available tables appears in R:Base I only see the SSSPEC portion. The actual tables themselves in DB2 are defined as USERID.SSSPEC. The DB2 database is translating the USERID portion into my user ID. Does anyone have any experience with how to configure a system to access DB2 tables? If so how do you configure a Windows 2000 system for access? Incidentally, when I use MS-Access 97 (boo! hiss!) to link to the tables with ODBC there is no problem. Also, I get the same results as mentioned above in both 6.5++ and R:Base VII. Any comments or suggestions will be greatly appreciated. I have a golden opportunity to show what R:Base is made of which may result in it being used more widely throughout the corporation. Thanks. Mike Ramsour Voice: 740-829-4340
