I want to know if there is any way to list (get) all the database names on Informix. I need a proper query or stored procedure to do that.
According to the documentation, the command to get a list of the databases on the server you are connected to is simply:
show databases