Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by manishg2000
-
SQL to List All Database Names
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.:(- manishg2000
- Post #2
- Forum: IBM: DB2
-
SQL to List All Database Names
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
- Thread
- Replies: 2
- Forum: IBM: DB2
