Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2015
    Posts
    24

    Unanswered: DB2 tab in SQLDeveloper

    Hi

    We are working on a mainframe migration project.
    We have to migrate DB2 database tables on mainframes to Oracle tables on solaris.

    Earlier(1 year back) when we were using SQL Developer, we have seen a tab DB2 in SQL Developer.[please refer image below]
    Click image for larger version. 

Name:	url.png 
Views:	3 
Size:	32.0 KB 
ID:	16217

    Now when we installed the SQL Developer, we are not able to see that tab(DB2). We have installed the same SQL Developer which was installed earlier.

    Could you please let us know in which version of SQL Developer will we be able to get that option.

    Thanks in advance.

    PS: I have posted << this question >> in the DB2 forum and as per the reply I am posting this in the Oracle forum..
    Last edited by radek854; 03-09-15 at 00:15.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Did you install the DB2 JDBC driver?

    http://docs.oracle.com/cd/E11882_01/...o.htm#CHDIEGDD
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Feb 2015
    Posts
    24
    Hi shammat,

    Thanks for the reply.

    We have already installed the drivers but we still are not able to view the DB2 tab. The included drivers are..
    Click image for larger version. 

Name:	JAR.png 
Views:	0 
Size:	7.6 KB 
ID:	16221

    Can you please help us in solving the issue.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Have you created an ODBC link?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Feb 2015
    Posts
    24
    Hi cis_groupie,

    Thanks for the reply.

    Can you please provide the steps or a reference on how to create an ODBC link.

  6. #6
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I've never used Solaris so can't help you - sorry. Have you tried google?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •