Re: Simple UDTF only gets called with OPEN, FETCH events

[CRPence <CRPbottle@xxxxxxxxx>]

  AFaIK the SQL Graphical Debugger is only for debug of routines 
written with the LANGUAGE SQL.

  You have a non-SQL RPG program as an External program that implements 
the SQL UDTF [i.e. LANGUAGE RPGLE], not an SQL User Defined TABLE 
FUNCTION; i.e. CREATE FUNCTION (External Table) vs CREATE FUNCTION (SQL 
Table).  Thus whatever debug feature and technique is used for debugging 
your RPGLE in a multi-threaded capable process should suffice.

  For reference:

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcftbe.htm
IBM i 7.1 Information Center -> Database -> Reference -> SQL reference 
-> Statements
_i CREATE FUNCTION (External Table) i_
"This CREATE FUNCTION (External Table) statement defines an external 
table function at the current server. The function returns a result table.

An external user-defined table function may be used in the FROM clause 
of a subselect, and returns a table to the subselect by returning one 
row each time it is invoked. ..."


http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcftb.htm
IBM i 7.1 Information Center -> Database -> Reference -> SQL reference 
-> Statements
_i CREATE FUNCTION (SQL Table) i_
"This CREATE FUNCTION (SQL table) statement creates an SQL table 
function at the current server. The function returns a single result 
table. ..."

Regards, Chuck

On 12-Nov-2013 09:10 -0800, Peter Dow wrote:
> Thanks Luis! I'll give that a try tomorrow.
>
> On 11/12/2013 8:53 AM, Luis Rodriguez wrote:
> > If you have the time, I suggest you try the SQL Graphical
> > Debugger. IMHO is the best way to debug complex SQL procedures,
> > UDFs, etc.
> >
> > You can find a link to the relevant PDF here:
> >
> > http://public.dhe.ibm.com/partnerworld/pub/pdf/courses/2ae2.pdf