Re: SQLRPGLE - IF EXISTS?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Jake

Rob's subtle suggestion is well-taken - the SQL Reference at 
www.iseries.ibm.com/infocenter will tell you all that is available - 
you want to use the version that matches your OS/400 level.

You can also go to www.iseries.ibm.com/db2 for links to manuals and 
other useful information.

HTH
Vern

At 02:37 PM 4/4/2007, you wrote:

> Hello All;
> I am stuck on an sqlrpgle application. Is there an 'IF EXISTS' function that
> I can use? I know that there is an 'IF EXISTS' function in SQL Server but I
> am not sure if the DB2 engine supports that. I am just trying to see if a
> customer id exists in a file. Could have done 'Chain' but 'powers be' want
> me to explore the SQL option first...:). Any help will be much appreciated.
> TIA.
>
> cheers,
> -Jake.
> --
> 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.