unable to import table definitions using ODBC

kiran_418 · Post by **kiran_418** » Thu Jun 09, 2005 12:09 pm

HI
Iam trying to import ODBC table definitions for two tables. It says authorization restricted. When i asked my DBA he said I have all rights for those 2 tables.
He asked me "it looks it was trying to access and write using a system file...." I have no clue to this questions.
The table definitions are being imported from AS400/ DB2 database.
Thanks for immediate response

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 09, 2005 12:49 pm

To get list of tables, you need to access your system tables. But you need not write it.

kiran_418 · Post by **kiran_418** » Thu Jun 09, 2005 2:09 pm

Ok
Y do i get this error when iam importing table definitions

DSR.MetaGeta(GET.COLUMNS)(SQLStatistics("SPEASUS4","DEVDTA","F5585211")): BCI Error:
SQLSTATE=42000,CODE=-551,[DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0551 - Not authorized to object QADBKFLD in QSYS type *FILE.

Any specific meaning to that
Thanks
Bye
kiran

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jun 10, 2005 3:59 am

That is an AS/400 DB2 error message.

Go into a search engine like google and try to locate it. One search returned the following.

http://networking.ittoolbox.com/groups/ ... font=fixed

ray.wurlod · Post by **ray.wurlod** » Fri Jun 10, 2005 6:05 pm

To be brutal, it's not a DataStage problem.

You have not been granted sufficient authority in DB2 on the AS400 to obtain a list of table names (or perhaps of a list of column names for a particular tables).

You must negotiate to get this authority granted by the DBA.