0

I would like to know the DB2 platforms where it is possible to create User-defined table functions in SQL-PL. It seems that it is possible in DB2 for i, but I haven't seen anything for LUW, not z/OS.

It does not appear in the "SQL Reference for Cross-Platform Development Version" as many other popular features.

AngocA
  • 7,655
  • 6
  • 39
  • 55
  • 1
    Both DB2 for LUW and z/OS support SQL table functions -- check out the SQL reference. `CREATE FUNCTION blah ... RETURNS TABLE ...` – mustaccio Oct 30 '14 at 18:54
  • Thank you. That's true. http://www.ibm.com/developerworks/ibmi/library/i-power-of-udtf/ This article is for DB2 for i, however many things works for other platforms. – AngocA Oct 30 '14 at 23:10

0 Answers0