IBM Support

SQL functions (UDF & UDTF) parameter limit

News


Abstract

The maximum number of parameters has been increased for User Defined Functions (UDF) and User Defined Table Functions (UDTF).

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > SQL functions (UDF & UDTF) parameter limit

The maximum number of parameters has been increased for User Defined Functions (UDF) and User Defined Table Functions (UDTF).

For UDTFs, the return columns are considered parameters.

With this extension of the function parameter limits, SQL users will be able to construct more complex UDFs and UDTFs.

image-20200115130915-1

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
15 January 2020

UID

ibm11164628