Using a DB2 User Defined Function

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mchiber
    New Member
    • Nov 2008
    • 1

    Using a DB2 User Defined Function

    Hi,

    I am from the Microsoft SQL Server world. Need to convert some scripts to DB2. Can someone tell me how to select from a UDF that returns a Table ?

    In MSSQL its
    select * from dbo.FunctionNam e('argument')
    How to do this in DB2?
  • cburnett
    New Member
    • Aug 2007
    • 57

    #2
    Code:
    select * from table(dbo.FunctionName('argument')) as x

    Comment

    Working...