Home » SQL & PL/SQL » Client Tools » SQL Developer - access to AS400 iSeries
SQL Developer - access to AS400 iSeries [message #634246] Fri, 06 March 2015 06:57 Go to next message
dvaillant
Messages: 1
Registered: March 2015
Junior Member
Hi,
I would like to know the way to access to a db2 database (AS400 iSeries) with Sql Developer 4.x.
I have already used db2jcc.jar, but I don't know how to configure the connexion.
With SQL-View, I can access to the database using the ALIAS parameter in ODBC.
But how it work with SQL Developer ?
Thanks by advance !
Re: SQL Developer - access to AS400 iSeries [message #634435 is a reply to message #634246] Tue, 10 March 2015 02:43 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
Welcome to the forum!

Please read and follow the OraFAQ Forum Guide and How to use [code] tags, to enable us to help you.

Quote:
I would like to know the way to access to a db2 database (AS400 iSeries) with Sql Developer 4.x.


Your question is not related to Oracle. This is not a DB2 forum. So, I would suggest you to post in a DB2 forum.

[Updated on: Tue, 10 March 2015 02:44]

Report message to a moderator

Re: SQL Developer - access to AS400 iSeries [message #634436 is a reply to message #634435] Tue, 10 March 2015 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65988
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But SQL Developer is an Oracle product, so the question is at its place here.
The problem is not at DB2 side but at SQL Developer one to connect to a DB2 database.


Re: SQL Developer - access to AS400 iSeries [message #634438 is a reply to message #634246] Tue, 10 March 2015 03:06 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
dvaillant wrote on Fri, 06 March 2015 18:27

I have already used db2jcc.jar, but I don't know how to configure the connexion.


There are some notes about Configuring the Third Party Connection here http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html#conf

Regarding DB2 it says:

IBM DB2: You need the binary driver jar files db2jcc.jar and db2jcc_license_cu.jar. Search for DB2 Universal JDBC Drivers or follow the links from http://www-306.ibm.com/software/data/db2/express/additional-downloads.html
Re: SQL Developer - access to AS400 iSeries [message #634440 is a reply to message #634436] Tue, 10 March 2015 03:15 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
Quote:
But SQL Developer is an Oracle product, so the question is at its place here.
The problem is not at DB2 side but at SQL Developer one to connect to a DB2 database.


May be you are correct Michel. When I read the client tools forum details "Tools for executing SQL and PL/SQL commands", I interpret it as only related to Oracle. Yes SQL Developer is an Oracle product, but I thought the forum is to help only with Oracle related stuff like how to connect to Oracle DB. What if someone asks how to connect to DB2 from TOAD. That is how I interpreted. May be I am wrong. As a benefit of doubt, I have now posted some links to point OP to some usage notes.
Re: SQL Developer - access to AS400 iSeries [message #634441 is a reply to message #634438] Tue, 10 March 2015 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 65988
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Far better answer than your previous one.

Quote:
I thought the forum is to help only with Oracle related stuff like how to connect to Oracle DB.


There are many topics in this forum related to connect SQL Developer to a non-Oracle database (most of the time SQL Server) including migration issues.

The matrix is simple, the forum includes:
Oracle client tool <-> Oracle database
Oracle client tool <-> Non-Oracle database
Non-Oracle client tool <-> Oracle database

But NOT "Non-Oracle client tool <-> Non-Oracle database".

[Updated on: Tue, 10 March 2015 04:10]

Report message to a moderator

Re: SQL Developer - access to AS400 iSeries [message #635941 is a reply to message #634435] Mon, 13 April 2015 09:18 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Why not use IBM® Data Studio (free from IBM).
It's similar to SQL Developer.
Previous Topic: Checking Swap Space
Next Topic: script cutting off
Goto Forum:
  


Current Time: Wed Nov 21 09:55:30 CST 2018