DB2 : DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: =;FUNCTION During Insert

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by jraveendranath 0n 09 October 2007

I am having a strange error in DB2 V 9.1(On AIX Version 5.3). The DB2 has fix pack 3 also installed on it.

When I am doing an Insert into a table, I am encountering the below error.

INSERT INTO tableabc(abc, def, ghi, jkl) VALUES (1, 1, 1, 1);

The primary key, data types all are taken care of during the insert.

The error received is as below.

DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: =;FUNCTION
Message: No authorized routine named “=” of type “FUNCTION” having compatible arguments was found.

A select on the same table works fine.

Also, when I am trying to create a procedure that is dependent on this table, I am running into the same exact error.

Temporary Solution that we found is to Drop and Create the table & indexes again, and the Insert, Create Procedure works fine without a single change in the SQL.

We need a solution which does not involve a drop of table.

We already raised a PMR with IBM, but in the mean time.. Anybody there who can help?

Learn more about databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting