In-line Ifs

["Paramasivam Murugesan , Gurgaon" <ParamasivamM@xxxxxxxxxxxxxxx>]

Hi all,
        Any Example, How are 'In-line If's  coded in SQL statements?.. I
dont know whether this is allowed in in SQL/400 or not.

TIA,
Murugesh

-----Original Message-----
From: M. Lazarus [mailto:mlazarus@xxxxxxxx]
Sent: Monday, April 19, 2004 3:40 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: %lookup


Simon,

  I strongly agree.  But there are actually an additional 5 forms of lookup 
- %TLOOKUPxx!  I see no reason that we (or the compiler) needed that
variation.

  -mark


At 4/16/04 08:01 PM, you wrote:
>Here's one for the compiler writers:
>
>Why do you persist in defining multiple variants of the same built-in 
>function?
>
>It was bad enough with 3 forms of trim but now 5 forms of lookup! Where 
>will it end?
>
>Trim should have been:
>%TRIM( string {: option {: char}} )
>where option is 'L', 'R', or 'B' with 'B' the default
>and char is the character to trim with a space as the default
>
>Lookup should have been:
>%LOOKUP( needle : haystack {: option {: start {: limit }}} )
>where option is 'EQ', 'LT', 'GE', 'GT', or 'LE' with 'EQ' the default
>and the rest as they are.
>
>I realise it's too late to correct this travesty but I wish you would stop 
>perpetuating it.
>
>Regards,
>Simon Coulter.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.