Hi,

We have an informix environment where we have several customer databases:

Customer001
Customer002
Customer003

Obviously this is not a great way to do things, and we have a long-term project to combine them into 1 database, but for the meantime I need to come up w/ sql to get information out of each one for a report.

select item
from customer001:item <-- this is where I need the dynamic "db selector"

Any help is appreciated.

Thanks,

Al in SoCal