RE: SQL Gurus Wanted

Just as an FYI,

But my experience is that I can always use an System i SQL statement on SQL server or Oracle.

But not the other way around. DB2 Sticks pretty dang close to the standards. MS and Oracle have
added a bunch of non-standard syntax.

Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Porterfield, Sean
Sent: Tuesday, July 31, 2007 7:43 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL Gurus Wanted

-----Original Message-----
From: Joe Pluta

From: Porterfield, Sean

UPDATE File1
SET File1.Data1 = File2.Data1
FROM File1, File2
WHERE File1.Key1 = File2.Key1

Should this work correctly? Thanks.

Sean, as far as I know the syntax above won't work at all.

However, without the WHERE EXISTS, the query will update

all records

in A.

Thanks, Joe. I created some simple tables to test this out;
it helps a lot to see it in action.

My version produced "Column qualifier or table FILE2
undefined." Using yours without the WHERE EXISTS, every
record was updated. With the WHERE EXISTS, I got exactly
what I expected.

I guess this is just a syntax difference between MS SQL
Server and System i SQL. Luckily it seems with the subselect
and where exists, I can use it on either platform.
--
Sean Porterfield

This email is confidential, intended only for the named
recipient(s) above and may contain information that is
privileged. If you have received this message in error or
are not the named recipient(s), please notify the sender
immediately and delete this email message from your computer
as any and all unauthorized distribution or use of this
message is strictly prohibited. Thank you.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.