I'm using Progress 91D with OpenLink Generic ODBC 5.10 driver and Crystal Reports 10 and XI.
When I use DB2JoinBuilder=olod5032, inner joins work correctly but when I try to use left outer joins Crystal generates incorrect SQL syntax. Instead of the words left outer join, a parenthesis plus sign parenthesis (+) is used. Here's an example.
SELECT A1.field1, B1.field2, C1.field3, D1.field4
FROM pro1.D D1, pro1.B B1, pro1.A A1, pro1.C C1
WHERE (D1.field1=B1.field1 (+)) AND (D1.field1=A1.field1 (+)) AND (D1.field1=C1.field1 (+))
Does anyone know what registry key I can use for Progress 91D, OpenLink and Crystal Reports for left outer joins?
Thanks in advance.