If you can't see the Tables inside the Table Browser of the Business Objects Universe Designer and you are using IBM DB2 or you are facing the following error:
[IBM] [CLI Driver][DB2/NT] SQL0443N Routine
"SYSIBM.SQLTABLES' (specific name "TABLES") has returned an error
SQLSTATE with diagnostic text. "SYSIBM:CLI:-805", SQLSTATE=38553
Then you need to BIND your database, in order to able to view the tables in the Table Browser or your application.
write the following queries in order to perfom the BINDING:
connect to database user username using password
bind db2clipk.bnd
bind db2clist.bnd
bind db2schema.bnd
In my case I wrote the full path of the bnd files in order to get it work
bind 'C:\Program Files\IBM\SQLLIB\bnd\db2clipk.bnd'
bind 'C:\Program Files\IBM\SQLLIB\bnd\db2clist.bnd'
bind 'C:\Program Files\IBM\SQLLIB\bnd\db2schema.bnd'
To make sure that everything is working properly you can CALL SQLTABLES procedure and see if it returns or produce an error.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Feel free to write any comments or ideas!