SQL to List All Database Names SQL to List All Database Names manishg2000 (Programmer) (OP) 4 Apr 11 17:49 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! RE: SQL to List All Database Names manishg2000 (Programmer) (OP) 4 Apr 11 17:52 btw alsoSELECT * FROM SYSIBM.SYSDATABASE gives an error for meSQL0204N "SYSIBM.SYSDATABASE" is an undefined name. SQLSTATE=42704So not able to use that even.:( RE: SQL to List All Database Names Truusvlugindewind (Programmer) 19 Apr 11 06:40 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.