cognos8 framework manager db2 SQL5001 error

[christenhusz]

Hi,

I tried to connect with framework manager to a db2 database. I created an odbc connection to the db2 database and i am able to see and load the metadata of those tables in my framewok model. But when i want to join two tables i get the following error.

[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5001 - Column qualifier or table 'xxxxxx' undefined.

from the IBM site:

SQL5001 - Column qualifier or table &2 undefined.
Change your naming convention in your ODBC DSN.

Probable cause:

Your ODBC Data Source Name (DSN) configuration uses the wrong naming convention. Use the ODBC Administrator to change your DSN to use the proper (*SQL or *SYS) naming convention. Always use *SQL unless your application design specifically expects *SYS.

i'm new to db2 and i can't fing the CORRECT naming convention of a ODBC DSN.

how can shine some light on this issue, or has seen this before??

thx!


christenhusz

 

[tskelton]

I use an iSeries Access ODBC Driver to connect to DB2. In the configuration for that ODBC driver, under the 'Server' tab, there's a naming convention drop-down with 2 choices: *SQL or *SYS. My ODBC drivers have always used *SQL with Cognos products.

You may already know this, but what that setting tells the app which way you refer to your qualified objects. For example, the *SYS method uses a '/' like this:
LIBRARY/TABLE
whereas the *SQL method uses a '.' like this:
LIBRARY.TABLE

I hope this helps.

 

[christenhusz]

i'll check it asap. If this is the solution you get a star! ;-)

thx!

christenhusz