Re: SQL Functions in RPG

[Alan Campin <alan0307d@xxxxxxxxx>]

As far as I know no such thing. You have to have something in the database
for SQL to work.

On Mon, Nov 2, 2015 at 10:57 AM, Englander, Douglas <
Douglas_Englander@xxxxxxxxxxxxx> wrote:

> Does anyone know if I can create a subprocedure in an ILE RPG program, and
> use embedded SQL in that program to reference that subprocedure as a SQL
> function, instead of creating a SQL function that points to a subprocedure
> located in a Service Program? I am looking for something like a SQL
> "temporary function" that would be used only by that program, and only when
> that program is active. If so, can you point to some examples?
>
> Thank you,
>
> Doug
>
> --
> This is the RPG programming on the IBM i (AS/400 and 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.