Howard, Assuming the tables in the various DB all
have the same structure - why not create a set of
synonyms in one master DB (pick the one that makes
sense) and select from all the tables at once?

Is that an option for you?

Rob Vorbroker
--- Howard Salter <HowardSalter@penningtonseed.com>
wrote:
> Hello all,
>
>
>
> I'm writing a 4GL report, and I need it to span
> several databases that all
> have matching tables and structures, it's just the
> info in the tables that's
> different. I know I could add the database name to
> the FROM statement in
> each of my selects, but I was hoping there was a way
> to do create a DATABASE
> statement using a variable name. That way I wouldn't
> have to change the SQL
> statements and add the CLOSE and FREE statements for
> each cursor and prep
> statement.
>
>
>
> TIA,
>
>
>
> Howard
>
>


=====
Rob Vorbroker Phone: 513/336-8695
Vorbroker Consulting, Inc. Fax: 513/336-6812
www.vorbroker.com robv@vorbroker.com

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
sending to informix-list