DB2 and OUTER JOIN SYNTAX

[Andy Hallam]

DB 7.1

I am currently porting our C++ ODBC apps from INFORMIX, SQLSERVER and ORACLE
to DB2.

From what I can see DB2 only supports ANSI STANDARD OUTER SYNTAX i.e
...LEFT/RIGHT OUTER JOIN...

i.e:
SELECT Part, StockQty
FROM PartFile
LEFT OUTER JOIN StockFile ON Part = StockPart

Now INFORMIX, SQLSERVER and ORACLE also supply there own native OUTER JOIN
SYNTAX. For example the above SQL can also be written thus.

-- INFORMIX
SELECT Part, StockQty
FROM PartFile, OUTER StockFile
WHERE Part = StockPart

-- SQLSERVER
SELECT Part, StockQty
FROM PartFile, StockFile
WHERE Part *= StockPart

-- ORACLE
SELECT Part, StockQty
FROM PartFile, StockFile
WHERE Part = StockPart(+)

What I need to know is does DB2 also support it's own outer syntax along the
lines of INFORMIX, SQLSERVER and ORACLE ?

Thanks for any info.

Andy.

[Serge Rielau]

Nope, and we're proud at it :-)

Cheers
Serge

[pm3...@attglobal.net]

Is there a reason you are looking for a non-standard way of coding things?

PM

[Andy Hallam]

Basically I'm working with legacy applications and SQL. (Based on INFORMIX
syntax) and writing a parser to implement native outer join syntax is alot
easier...Other than that it means re-writing 5000+ SQL statements...

<pm3...@attglobal.net> wrote in message
news:3B661B47...@attglobal.net...