| |
| Title: | How to get the database names in a Eloquence data base environment ? |
|---|
| Document: | gen_040 |
|---|
| Keywords: | dbdumpcat,database name,name,sysdb,list of database,dbid |
|---|
How to get the database names in a Eloquence data base environment ?
dbdumpcat -t31 provides a list of all databases in the database
environment.
For example:
/opt/eloquence6/bin/dbdumpcat -u dba -t31
dumps the catalog of the default database server.
Additional options -h and -s allow specifying
a different host or service.
-------------------------------------------
#31 sysdb (8 entries)
-------------------------------------------
|dbid|name |flags |nodeid|
-------------------------------------------
|11 |DB |04000000|100 |
|12 |PPS4D3 |04000000|125 |
|13 |DB2 |04000000|437 |
|15 |DB3 |04000000|487 |
|16 |SGL1 |04000000|512 |
|17 |SYSDB1 |04000000|557 |
|18 |SAMPLE |04000000|596 |
|19 |TRA |04000000|621 |
-------------------------------------------
Only column 2 (name) is relevant for you.
|
|
