OraFAQ Forum: Client Tools » SQL Developer

Home » Other » Client Tools » SQL Developer - access to AS400 iSeries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Developer - access to AS400 iSeries [message #634246]

Fri, 06 March 2015 06:57

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 !

Report message to a moderator

Re: SQL Developer - access to AS400 iSeries [message #634435 is a reply to message #634246]

Tue, 10 March 2015 02:43

Lalit Kumar B
Messages: 3174
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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: SQL Developer - access to AS400 iSeries [message #634438 is a reply to message #634246]

Tue, 10 March 2015 03:06

Lalit Kumar B
Messages: 3174
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

Report message to a moderator

Re: SQL Developer - access to AS400 iSeries [message #634440 is a reply to message #634436]

Tue, 10 March 2015 03:15

Lalit Kumar B
Messages: 3174
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.

Report message to a moderator

Re: SQL Developer - access to AS400 iSeries [message #634441 is a reply to message #634438]

Tue, 10 March 2015 03:21

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Previous Topic:	Checking Swap Space
Next Topic:	script cutting off

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 23:43:13 CST 2024