Re: SQLRPGLE - IF EXISTS?

["Jake Morkel" <jakeroc@xxxxxxxxx>]

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.