search cancel

Datacom and UDFT


Article ID: 42054


Updated On:


Datacom DATACOM - AD


What is an UDFT?

CA Datacom 14.0 PTF RO89483 is making reference to UDFT. 


Release: 14.0 and above 

CA Datacom/AD 


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)


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.