Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2012
    Posts
    6

    Unanswered: Query via ODBC/sqldbx

    Hi,

    I want to see all tables and have problems doing so. I am accessing DB2 via sqldbx/ODBC. "show tables" or "list tables" does not work. SYSCAT.TABLES does not work either. How is it possible?

    Thanks!

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Works fine for me...

    Maybe you should give some facts, like what error message/error-code you get, what version +fixpack of DB2 you are using..

  3. #3
    Join Date
    Jul 2012
    Posts
    6
    Hi,

    thanks for replying. Sorry just discoverd that the test environment uses watcom v12.0.2.0 and not db2. So this is the wrong forum - but still have the problem.

    if I type "show tables" or "list tables" I get the following error message:

    procedure 'show' not found
    Last edited by sooofunky; 07-13-12 at 06:42.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    This is a DB2 forum.
    If you are not connecting to DB2 then your question makes no sense.

  5. #5
    Join Date
    Jul 2012
    Posts
    6
    I know - how can I move this thread?

  6. #6
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    You might re-post this in the Other databases part of the forum.

    Suggest you also refer to this topic and ask it be removed.

    Good luck.

Posting Permissions

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