Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    24

    Unanswered: List all the database name?

    I am writing a C++ program to connect to the db2 remotely. I want to get all the database name under an instant(node) in the server, what can I do? I have try the db2api function sqledosd() and sqledgne(), but I can only get the database name that I've cataloged. What should I do? Isn't it available for db2api/ cli / SQL Statement? And how can I know whether the database was created by user or system? Thanks very much~!
    Last edited by carmenlei; 07-06-04 at 06:52.

  2. #2
    Join Date
    Jun 2004
    Posts
    39
    SQL statement to get the database name : LIST DATABASE DIRECTORY or LIST NODE DIRECTORY

    To know whether the database was created by user or system : LIST TABLES
    geoffrey
    - Four J's Development Tools -

Posting Permissions

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