CA SDM - Create a DERIVED column that execute a custom SQL funciton

[Robinson Morales P]

Hello Team,

Does anyone know if it is possible to achieve the following:

Create a DERIVED column on CR Object, and that column is calculated with SQL custom function

I've tried createing a MOD file like this:

OBJECT cr {
    ATTRIBUTES Call_Req {
        custom_field DERIVED (dbo.custom_function(zVEmail));
    };
};

But we got ERROR

syntax error, unexpected '(', expecting YACC_ISNULL or YACC_QSTR or YACC_STR or ')' at "("

Regards,

Robin M.

[Robinson Morales P]

Hello team.

Official TechDoc from Broadcom side:

DERIVED attribute uses and limitations

https://knowledge.broadcom.com/external/article?articleNumber=387574

Regards,

Robin M.