Re: SQLRPGLE - IF EXISTS?

Thank you, Sir. Rob, it is not that I did not take time to read the manual.
Having dabbled around with so many databases, it sometimes gets difficult to
remember as to what function is supported by what SQL engine. I apologize
for posting something so trivial.

Kind regards,
-Jake.


On 4/7/07, Vernon Hamberg <vhamberg@xxxxxxxxxxx> wrote:

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.

--
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.