 <p>I found the followin exsample on ibm sites:</p> <pre><code>select t1.timeid, t1.storeid, t1.sales from time, store, table (cvsample.salesfunc(time.timeid, store.storeid)) as t1 where time.timeid = t1.timeid and store.storeid = t1.storeid; </code></pre> <p>notice the syntax: <strong>table (cvsample.salesfunc(time.timeid, store.storeid)) as t1</strong></p> <p>so you prob dont need fields and 'as' you still need '*' and the 'FROM'</p> <p>so </p> <pre><code>INSERT INTO STUDENT_TMP SELECT * FROM Table (MyDB.fn_getStudent()) </code></pre>