Re: Function is returning NULL

["Luqman" <pearlsoft@xxxxxxxxxxxx>]

Hi Hauser,

Thanks v.much for your reply, I really appreciate. I think you just clicked
on New Post instead of Reply Group and it showed as a new thread, thats why
I could not see your message earlier.

Cheers!

Luqman


"Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>
wrote in message
news:538BBD40ADF524459A43893DA18E5E5109C20E@xxxxxxxxxxxxxxxx
> Hi Luqman,
>
>
>
> you are merging SQL User Defined Table Functions and SQL Stored
Procedures!
>
>
>
> Only Stored Procedures can be called with the SQL Command CALL!
>
> Stored Procedures are created using the SQL Command CREATE PROCEDURES.
>
>
>
> User Defined Table Functions must be called in an SELECT statement.
>
> Select * From Table(MyUDTF(Parm1, Parm2, ... ParmN)) as X
>
> They are created over the SQL Command CREATE FUNCTION.
>
>
>
> An please have a look at the red book:
>
> Stored Procedures, Triggers and User Defined Functions
>
> http://publib-b.boulder.ibm.com/abstracts/sg246503.html?Open
> <http://publib-b.boulder.ibm.com/abstracts/sg246503.html?Open>
>
>
>
> Birgitta
>
>
>
> --
> 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.
>
>