Re: Outer Join Problem....
Chandra Kumar wrote in message <62kvkf$8cp@cssun.mathcs.emory.edu>...
> We are developing an Application where in the database is kept open.
ie the customer
>Can either go for Informix Online or Oracle.
> As u all know that for Outer joins In informix on client will have
OUTER keyword
>Is placed before the name the table. But in Oracle outer join syntax + has
to be placed
>After each column which will have values not matching the corresponding
column in the
>Joined table.
> But in this I cannot have common script on the client (powerbuilder) -
Any solution
>Do inform - I will be very thank ful ..
Chandra:
Think about writing meta-scripts that will run on neither platform. Then,
run one of two parsers that will change the syntax to match the desired
server. For instance:
Select *
From Tab1 T1, {InformixOuter} Tab2 T2
Where T1.joinfield ={MSSQLOuter} T2.joinfield {OracleOuter};
When parsing for Informix, replace '{InformixOuter}' string with 'OUTER' and
strip the other two strings. Similarly search and replace for the other
platforms. You might like it better than writing UNIONs, especially since
Informix can't handle UNIONs inside of views.
Michael
mporemba@moscom.com