Tuesday, 3 November 2015

How to access DB2 from SQLDeveloper

To be able to access DB2 from SQLDeveloper, you need a JDBC driver (db2jcc.jar - just google it).
Assuming you have downloaded the jar, here's how to setup the SQLDeveloper:
1. Open SQLDeveloper
2. Go to Tools > Preferences
3. Open Database | Third Party JDBC Drivers from the left hand side panel
4. Click 'Add Entry' button,select the jar file that you've downloaded and click 'OK'
  
5. After setup the JDBC driver, a DB2 tab will be added to the New Connection screen

Note for Enter Database field:
  • Enter <DatabaseName> if you wish to display all schema within a database
  • Enter <DatabaseName>:currentSchema=<SchemaName> if you wish to work on a specific schema within a database

Intro...

Just some random techie stuffs....