Importing the table metadata from AS400?

[Former Member]

Hi Guys,

we are getting table not found error when trying to impor a table definition from AS400. The user has admin rights but we are not sure about the syntax for the connection paramters. There are no connection erros and we are able to import the defintions from SQL and Oracle successfully with out any problems.

we are having the paramaters in the JDBC receiver adapter as below.

JDBC Driver: com.ibm.as400.access.AS400JDBCDriver

Connection: jdbc:as400:xx.y.zz.xyz:CORPD70

xx.y.zz.xyz --> IP addess and CORPD70 is the DB name

any help would be really appreciated

Thanks,

Srini

[Former Member]

The problem is solved. The user did not had full authorizations.

[Former Member]

The problem is solved. The user did not had full authorizations.