AnsweredAssumed Answered

DB2 iSeries/as400 connectivity issue - unable to view the columns in the table

Question asked by amudhavani.shanthosh181426 on Aug 29, 2017
Latest reply on Mar 26, 2018 by man2018

Hi Team,

 

Below are the connection detail. 

 

Driver type : custom

User Name & password : which has full privileges

Class Name : com.ibm.as400.access.AS400JDBCDriver

Connection URL : jdbc:as400://CJC402.cbi-inet.com:463/IBMDA400.DataSource.1

 

When I use get in the operation, I am able to see the tables that I need to query, but the columns are not getting listed. 

 

Can you please let me know what I have to do. Thank you. 

Outcomes