RE: User Defined Table Function (UDTF)

I was afraid of this when I couldn't find any documentation.

I know I can use a runtime defined data structure with a stored
procedure returning a cursor; but it requires an HLL program to use it;
I was hoping to be able to use the table returned in a query manager
query. 

Are there any other ideas on how I could do this?

Jay Himes

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Thursday, September 07, 2006 7:51 AM
To: Midrange Systems Technical Discussion
Subject: RE: User Defined Table Function (UDTF)

Jay,

AFAIK, you can't define the returned table structure at run time.  It
must be defined when the UDTF is created.

Charles Wilt
--
iSeries Systems Administrator / Developer Mitsubishi Electric Automotive
America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx 
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Himes, Jay
Sent: Wednesday, September 06, 2006 9:41 PM
To: Midrange Systems Technical Discussion
Subject: User Defined Table Function (UDTF)

I am attempting to create a user defined table function which returns 
a table structure defined at run-time. I have a function that works; 
returning a comma separated list of fields in a single varchar field 
(see below). This is not ideal for my needs.

I am unable to find any documentation on how to create a table 
structure at run-time; does anyone have any pointers or examples?


Current Function Creation:

Create Function JEHIMES1/RMTTBL (datain char(10))
Returns Table( DATFLD varchar (3200) )                        
         
External Name 'JEHIMES1/RMTTBLM(PROCESSLIST)'  
Language RPGLE                                 
Disallow Parallel                              
No SQL                                         
Parameter Style DB2SQL                         
Not Deterministic

Thanks,
Jay Himes                            

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take 
a moment to review the archives at 
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.