How to list all Informix database names

database informix
Anyname Donotcare picture Anyname Donotcare · Nov 24, 2010 · Viewed 13.4k times · Source

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.

Answer

newenglander picture newenglander · Aug 29, 2012

Alternatively you could execute this query when connected to the sysmaster database:

select * from sysdatabases

Related questions

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values violating non-null, unique, …

Read More
How do I get constraint details from the name in Informix?

When programming a large transaction (lots of inserts, deletes, updates) and thereby violating a constraint in Informix (v10, but should apply to other versions too) I get a not very helpful message saying, for example, I violated constraint r190_710. How …

Read More
Row numbers for a query in informix

I am using informix database, I want a query which you could also generate a row number along with the query Like select row_number(),firstName,lastName from students; row_number() firstName lastName 1 john mathew 2 ricky pointing 3 sachin tendulkar Here …

Read More