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.