SQL to List All Database Names

[manishg2000]

What sql query can I use to list names of all databases in DB2 (need to call it via jdbc)?

Something of the flavor like in Mysql we have [Show Databases]

And "LIST DATABASE DIRECTORY" is not much help when making a jdbc call.

Thanks!

 

[manishg2000]

btw also

SELECT * FROM SYSIBM.SYSDATABASE gives an error for me

SQL0204N "SYSIBM.SYSDATABASE" is an undefined name. SQLSTATE=42704

So not able to use that even.

 

[Truusvlugindewind]

JDBC/ODBC connectors are not designed for that. You use it to connect to a specific database and that database is the scope. You could try to use the "SYSPROC.ADMIN_CMD" for the LIST DB DIRECTORY.