Re: translate this Sql Server Query into DB2 Sql for AS/400 ?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

I'm not sure this will do what you want in SQL Server or anywhere. The 
problem is the LEFT OUTER JOIN - M.LVL will be NULL when the employee does 
not have a manager in the employee file. Depending on the database (maybe), 
the result of adding something to a NULL column is NULL - is that what you 
want?

I have a simpler example of this from Microsoft's MSDN site, but I'll wait 
until you reply to the above question.

Vern

At 03:27 PM 9/17/2005, you wrote:

> Can anyone translate this Sql Server Query into DB2 Sql for AS/400 ?
>
> UPDATE E
>   SET lvl =M.LVL+1
>     FROM Employees AS E JOIN inserted AS I
>     ON I.empid = E.empid
>     LEFT OUTER JOIN Employees AS M
>     ON E.mgrid = M.empid
>
> Best Regards,
>
> Luqman
>
>
>
>
> --
> 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.