Re: SQLRPGLE - IF EXISTS?

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.