View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 01:06 PM
Rahul Babbar
 
Posts: n/a
Default getting very cryptic error while inserting the records

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.

The datatype of the column is integer and the table has a large number
of columns, however i am trying to insert only one column(same error
comes with more columns).

Further there is no trigger on that table.
What could be the possible causes of the issue?.

However, there may be some functions that might be used to insert the
records, when the table is altered, the functions could become
inconsistent/invalid. However, i am not sure how an invalid function
which inserts the records in a table can be the cause of failure of
this insert.

I regret giving only this much information but this is the info that i
have.

What could be the possible reasons of this error?

Thanks
Rahul

Reply With Quote