DB2 list schemas of a database
Posted by: DBA DB2,
on 11 Jul 2011 |
View original | Bookmarked: 0 time(s)
How to do a DB2 list schemas ?
Step 1 Connect to the database
db2 connect to my_database
Step 2 Execute this query
select schemaname from syscat.schemata
The recordset is something like :
Author: Jack Vamvas(http://www.dba-db2.com)
...