On Oct 9, 8:25 am, Serge Rielau <srie...@ca.ibm.com> wrote:
> Rahul Babbar wrote:
> > Hi,
>
> > I am getting the following error, while executing the simple insert
> > script on a few tables.
>
> > INSERT INTO <table_name>(<col1>) VALUES (1);
>
> > DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: =;FUNCTION
> > Message: No authorized routine named "=" of type "FUNCTION" having
> > compatible arguments was found.
>
> This smells like an issue with a nested SQL object:
> * Expression generated column
> * check constraint
> * trigger
>
> I do recall an issue with generated column when a LOB was involved.
>
> Either way this should be a PMR and if it's novel an APAR should be opened.
>
> Cheers
> Serge
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab

Hi,

A PMR has been raised for it.

Rahul