Question about Online 5.0 (fwd)
Walter,
#1 - yes, try:
select a.*,b.*
from dbname1:table1 a,
dbname2:table2 b
#2 - this may not be a very good idea, what if you schema changes? also,
you may find that doing this works in 1 tool but not in another...
> Hello,
>
> I have access to Informix-Online 5.0 and would like to know if the following
> things are possible from within dbaccess or any other Informix program:
>
> 1. Is it possible to access two or more tables in two or more different
> databases which may even be in different Dbspaces? At the same time
> (that is from the same program)? It seems that I can only access one
> database at a time with the DATABASE command.
>
> 2. Is it possible to refer to a table column by column number instead
> by column name? (i.e. update column five instead of updating column
> "customer_no" assuming that customer_no is the fifth column.)
> This _could_ be done via the systables and syscolumns tables but even
> then I need some kind of "indirect addressing" to do it.
>
>
> Apologies if these questions are overly stupid. I am new to this matter.
>
> Thanks for any replies!
>
> -Walter
>
>
>
>
--
regards,
+----------------------------------------------------------------------------+
| . . | |
| ... ... | Bob Baskett |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | |
|----------------------------------------------------------------------------|
| 'connectionLESS IS MORE' -- Data Broker |
|----------------------------------------------------------------------------|
| Duct tape is like the force. It has a light side, and a dark side, and |
| it holds the universe together ... |
| -- Carl Zwanzig |
+----------------------------------------------------------------------------+