Re: Multiple dbs and one 4gl program
In article <3fdijm$593@emory.mathcs.emory.edu>, pp@ciop.waw.pl (Pawel Pietrusinski) says:
>
>
>Is it possible to access multiple databases from
>within one 4gl program (for example perform
>a join on tables from two different databases)?
>
>Are there any additional tools required?
>
>We're using Informix OnLine 4.1 , 4gl 4.0
>
>Thank you
>
Yes it is possible to access two or more databases with one statement.
You must use the ":"-Notation:
SELECT a.row, b.row FROM db1:tab1 a, db2:tab2 b
WHERE a.row = b.row
--
########################################################
# ____ ____ ____ #
# | _ | | | | | Stefan Gutsche #
# | (_)| | | | | #
# | ___| _| _|__| _| IVU GmbH #
# |( (_ \\ ( (_ | (_ | Bundesallee 129 #
# | | | \\ \\/ /| | | | D-12161 Berlin #
# | | | \\ /|| |__| | #
# |(____) |\\_/ |\\________) phone : +49 30 850006-38 #
# | | | | | | fax : +49 30 850006-66 #
# |____| |____| |____| e-mail: sg@ivu-berlin.de #
# #
########################################################