RE: SQL Gurus Wanted

["Wilt, Charles" <WiltC@xxxxxxxxxx>]

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.