search cancel

Datacom and UDFT

book

Article ID: 42054

calendar_today

Updated On:

Products

Datacom DATACOM - AD

Issue/Introduction

What is an UDFT?

CA Datacom 14.0 PTF RO89483 is making reference to UDFT. 

Environment

Release: 14.0 and above 

CA Datacom/AD 

Resolution

An SQL User-Defined Function Table (UDFT) is similar to an External Procedure but is used in a query as if it were a normal table.

A UDFT, like a normal table, is invoked when its name is referenced. 

A UDFT is not called by a program or trigger.

Unlike a normal table, however, a UDFT is read-only.

Unlike an External Procedure, a UDFT returns a table row, whose columns are declared in the CREATE FUNCTION statement in the RETURNS clause. ...

See CA Datacom 15.1 documentation section "SQL User Defined Function Table (UDFT)
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/using/using-sql/sql-user-defined-function-table-udft.html

 

Additional Information

UDFT was introduced with CA Datacom Version 14.0 via PTF RO40578 for some CA Datacom/AD product usage. It is now fully available and documented for CA Datacom Version 15.0 and above.