Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I managed to connect to DB2 on zOS by adding third party JDBC drivers from IBM (db2jcc4.jar and db2jcc_license_cisuz.jar) in SQL Developer preferences. During connecting I get an error:
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=4.18.60
The connection actually works and I can successfully execute SQL statements afterwards, however autocompletion and browsing the list of tables doesn't, which renders the tool pretty useless.
So is this a faulty setup on my part, or does SQL Developer not support DB2 on zOS yet?
If that is the case, are there any plans/roadmap for at least minimal support of DB2?
The 3rd party database support in Oracle SQL Developer is provided for helping you migrate said 3rd party databases to Oracle Database
Our list of supported platforms