CA Service Management

 View Only
  • 1.  CA SDM - Create a DERIVED column that execute a custom SQL funciton

    Posted 17 days ago

    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.



  • 2.  RE: CA SDM - Create a DERIVED column that execute a custom SQL funciton

    Posted 15 hours ago

    Hello team.

    Official TechDoc from Broadcom side:

    DERIVED attribute uses and limitations

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

    Regards,

    Robin M.