Good day to all: I am having a problem being able to attach to tables on another vendor's database using ODBC. The IBM DB2 database tables are defined with a two-part name such USERID.PHOLD or MET.MECH in a database named QISDB. There is an INI file (db2cli.ini) that contains the client configuration information. The section in the INI file for the QISDB database has the following information:
[QISDB] UID=cwmtmar (my user ID for the database) DBALIAS=QISDB (the database name that I connect to) CURRENTSQLID=USERID R:Base uses the CURRENTSQLID=USERID parameter to determine which tables I can attach to when it communicates with the IBM ODBC driver. When I enter the SATTACH command at the R> I can see, for example, a table named "MECH". When I try to attach the table, however, I get an error message from the IBM ODBC driver stating "USERID.MECH is an undefined name" because technically it is defined as "MET.MECH". If I change the CURRENTSQLID parameter in the INI file to "MET" I can then attach the "MECH" table but then I can't attach to any of the "USERID". Is there something I can do on the R:Base side that will enable me to attach to any of the tables in QISDB without having to change the INI file each time I need to switch between "MET" or "USERID" tables? It's like the tables are defined in a path such as QISDB.MET.MECH and R:Base only anticipates QISDB.MECH. Thank you in advance for any assistance. Mike Ramsour AK Steel Coshocton Works Voice: 740-829-4340 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
