MS Access/DB2 ODBC

Article View: alt.comp.databases

Article #81

Back to alt.comp.databases Previous Next

#81

From: Bob Clore
Date: Tue, 12 May 1998 00:00

19 lines
1667 bytes

When Access 8 sends an Outer Join via ODBC it puts parentheses around the
clause after the "ON".  Our DB2 v4.1.0 on OS390 rejects this syntax.  The
parentheses don't show up in the Access SQL window, only in the ODBC trace.

Why does Access change things it doesn't need to?  Is there a way to get it
to stop doing that?
On the other side shouldn't parentheses be acceptable most anywhere as long
as they are matched?
Is there a  patch for DB2 v4.1.0 to handle this problem?
Any other ideas for a work around?

example:

select ........ from ..... left join .....  on (..... = ....)

Thanks,
Bob Clore
Seattle City Light (City of Seattle)

Technical Details

Message-ID: <6jaqh4$5bt$1@news.eli.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da59,60e410405656aa57,start
X-Google-Attributes: gid10da59,public
X-Google-Thread: 10f47b,60e410405656aa57,start
X-Google-Attributes: gid10f47b,public
X-Google-Thread: 10a90d,60e410405656aa57,start
X-Google-Attributes: gid10a90d,public
X-Google-Thread: 10cc0d,60e410405656aa57,start
X-Google-Attributes: gid10cc0d,public
X-Google-Thread: 115bcb,60e410405656aa57,start
X-Google-Attributes: gid115bcb,public
X-Google-Thread: ff0ac,60e410405656aa57,start
X-Google-Attributes: gidff0ac,public
From: "Bob Clore" <Robert.Clore@ci.seattle.wa.us>
Subject: MS Access/DB2 ODBC
Date: 1998/05/12
Message-ID: <6jaqh4$5bt$1@news.eli.net>
X-Deja-AN: 352725352
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: Seattle City Light (City of Seattle)
Newsgroups: alt.comp.databases,bit.listserv.db2-l,comp.databases.ibm-db2,comp.databases.ms-access,microsoft.public.access.odbcclientserver,microsoft.public.access.odbcclientsvr