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

No, M.LVL is a numeric field and cannot be null, if employee does not have a 
manager, his LVL will be 0.

Best Regards,

Luqman


"Vernon Hamberg" <vhamberg@xxxxxxxxxxx> wrote in 
message news:6.2.1.2.2.20050918065125.030ef3e0@xxxxxxxxxxxxxxxxxxx
> 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.
>
> -- 
> 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.
>
>