How to list all Informix database names

Question

I want to know if there is a way to list (get) all database names in Informix. I need the right query or stored procedure to do this.

Answer 1

According to the documentation , the command to get the list of databases on the server you are connected to is simple:

show databases

Answer 2

Alternatively, you can execute this query when connecting to the database sysmaster:

select * from sysdatabases 

Answer 3

( ):

sysmaster: sysdatabases;