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 10  2900 
"Rahul Babbar" <ra***********@gmail.comwrote in message
news:11*********************@57g2000hsv.googlegrou ps.com...
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
Please do a db2look and post the DDL for the table. You can do this with the
Control Center.
On Oct 8, 6:32 pm, "Mark A" <nob...@nowhere.comwrote:
"Rahul Babbar" <rahul.babb...@gmail.comwrote in message
news:11*********************@57g2000hsv.googlegrou ps.com...
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
Please do a db2look and post the DDL for the table. You can do this with the
Control Center.
Here's the DDL (got from Quest Central)
CREATE TABLE ABC_ADDRESS
(TC_ABC_ID VARCHAR(50) NOT NULL,
ABC_ID BIGINT NOT NULL,
O_LOCATION_ID BIGINT NOT NULL,
O_LOCATION_ALIAS_ID VARCHAR(16),
O_ADDRESS_LINE_1 VARCHAR(75),
O_ADDRESS_LINE_2 VARCHAR(75),
O_ADDRESS_LINE_3 VARCHAR(75),
O_CITY VARCHAR(40),
O_STATE_PROV VARCHAR(2),
O_COUNTY VARCHAR(40),
O_POSTAL_CODE VARCHAR(10),
O_COUNTRY_CODE VARCHAR(2),
C_LOCATION_ID BIGINT NOT NULL,
C_LOCATION_ALIAS_ID VARCHAR(16),
C_ADDRESS_LINE_1 VARCHAR(75),
C_ADDRESS_LINE_2 VARCHAR(75),
C_ADDRESS_LINE_3 VARCHAR(75),
C_CITY VARCHAR(40),
C_STATE_PROV VARCHAR(2),
C_COUNTY VARCHAR(40),
C_POSTAL_CODE VARCHAR(10),
C_COUNTRY_CODE VARCHAR(2),
D_LOCATION_ID BIGINT NOT NULL,
D_LOCATION_ALIAS_ID VARCHAR(16),
D_ADDRESS_LINE_1 VARCHAR(75),
D_ADDRESS_LINE_2 VARCHAR(75),
D_ADDRESS_LINE_3 VARCHAR(75),
D_CITY VARCHAR(40),
D_STATE_PROV VARCHAR(2),
D_COUNTY VARCHAR(40),
D_POSTAL_CODE VARCHAR(10),
D_COUNTRY_CODE VARCHAR(2),
HIBERNATE_VERSION BIGINT
)
DATA CAPTURE NONE
IN USERSPACE1;
ALTER TABLE ABC_ADDRESS
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_PK PRIMARY KEY
(ABC_ID
);
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_FK FOREIGN KEY
(ABC_ID
)
REFERENCES ABC
(ABC_ID
)
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
The following insert gives the above error.
insert into abc_address(lpn_id) values(1);
However, the problem goes away after the table is dropped and
recreated.
Rahul
Rahul Babbar wrote:
On Oct 8, 6:32 pm, "Mark A" <nob...@nowhere.comwrote:
>"Rahul Babbar" <rahul.babb...@gmail.comwrote in message
news:11*********************@57g2000hsv.googlegro ups.com...
>>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
Please do a db2look and post the DDL for the table. You can do this with the
Control Center.
Here's the DDL (got from Quest Central)
CREATE TABLE ABC_ADDRESS
(TC_ABC_ID VARCHAR(50) NOT NULL,
ABC_ID BIGINT NOT NULL,
O_LOCATION_ID BIGINT NOT NULL,
O_LOCATION_ALIAS_ID VARCHAR(16),
O_ADDRESS_LINE_1 VARCHAR(75),
O_ADDRESS_LINE_2 VARCHAR(75),
O_ADDRESS_LINE_3 VARCHAR(75),
O_CITY VARCHAR(40),
O_STATE_PROV VARCHAR(2),
O_COUNTY VARCHAR(40),
O_POSTAL_CODE VARCHAR(10),
O_COUNTRY_CODE VARCHAR(2),
C_LOCATION_ID BIGINT NOT NULL,
C_LOCATION_ALIAS_ID VARCHAR(16),
C_ADDRESS_LINE_1 VARCHAR(75),
C_ADDRESS_LINE_2 VARCHAR(75),
C_ADDRESS_LINE_3 VARCHAR(75),
C_CITY VARCHAR(40),
C_STATE_PROV VARCHAR(2),
C_COUNTY VARCHAR(40),
C_POSTAL_CODE VARCHAR(10),
C_COUNTRY_CODE VARCHAR(2),
D_LOCATION_ID BIGINT NOT NULL,
D_LOCATION_ALIAS_ID VARCHAR(16),
D_ADDRESS_LINE_1 VARCHAR(75),
D_ADDRESS_LINE_2 VARCHAR(75),
D_ADDRESS_LINE_3 VARCHAR(75),
D_CITY VARCHAR(40),
D_STATE_PROV VARCHAR(2),
D_COUNTY VARCHAR(40),
D_POSTAL_CODE VARCHAR(10),
D_COUNTRY_CODE VARCHAR(2),
HIBERNATE_VERSION BIGINT
)
DATA CAPTURE NONE
IN USERSPACE1;
ALTER TABLE ABC_ADDRESS
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_PK PRIMARY KEY
(ABC_ID
);
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_FK FOREIGN KEY
(ABC_ID
)
REFERENCES ABC
(ABC_ID
)
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
The following insert gives the above error.
insert into abc_address(lpn_id) values(1);
However, the problem goes away after the table is dropped and
recreated.
Rahul
I dont see a cloumn called lpn_id in the table.... :D
Rahul Babbar wrote:
On Oct 8, 6:32 pm, "Mark A" <nob...@nowhere.comwrote:
>"Rahul Babbar" <rahul.babb...@gmail.comwrote in message
news:11*********************@57g2000hsv.googlegro ups.com...
>>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
Please do a db2look and post the DDL for the table. You can do this with the
Control Center.
Here's the DDL (got from Quest Central)
CREATE TABLE ABC_ADDRESS
(TC_ABC_ID VARCHAR(50) NOT NULL,
ABC_ID BIGINT NOT NULL,
O_LOCATION_ID BIGINT NOT NULL,
O_LOCATION_ALIAS_ID VARCHAR(16),
O_ADDRESS_LINE_1 VARCHAR(75),
O_ADDRESS_LINE_2 VARCHAR(75),
O_ADDRESS_LINE_3 VARCHAR(75),
O_CITY VARCHAR(40),
O_STATE_PROV VARCHAR(2),
O_COUNTY VARCHAR(40),
O_POSTAL_CODE VARCHAR(10),
O_COUNTRY_CODE VARCHAR(2),
C_LOCATION_ID BIGINT NOT NULL,
C_LOCATION_ALIAS_ID VARCHAR(16),
C_ADDRESS_LINE_1 VARCHAR(75),
C_ADDRESS_LINE_2 VARCHAR(75),
C_ADDRESS_LINE_3 VARCHAR(75),
C_CITY VARCHAR(40),
C_STATE_PROV VARCHAR(2),
C_COUNTY VARCHAR(40),
C_POSTAL_CODE VARCHAR(10),
C_COUNTRY_CODE VARCHAR(2),
D_LOCATION_ID BIGINT NOT NULL,
D_LOCATION_ALIAS_ID VARCHAR(16),
D_ADDRESS_LINE_1 VARCHAR(75),
D_ADDRESS_LINE_2 VARCHAR(75),
D_ADDRESS_LINE_3 VARCHAR(75),
D_CITY VARCHAR(40),
D_STATE_PROV VARCHAR(2),
D_COUNTY VARCHAR(40),
D_POSTAL_CODE VARCHAR(10),
D_COUNTRY_CODE VARCHAR(2),
HIBERNATE_VERSION BIGINT
)
DATA CAPTURE NONE
IN USERSPACE1;
ALTER TABLE ABC_ADDRESS
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_PK PRIMARY KEY
(ABC_ID
);
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_FK FOREIGN KEY
(ABC_ID
)
REFERENCES ABC
(ABC_ID
)
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
The following insert gives the above error.
insert into abc_address(lpn_id) values(1);
However, the problem goes away after the table is dropped and
recreated.
Rahul
I dont see a column called lpn_id in the table.... :D
Rahul Babbar wrote:
On Oct 8, 6:32 pm, "Mark A" <nob...@nowhere.comwrote:
>"Rahul Babbar" <rahul.babb...@gmail.comwrote in message
news:11*********************@57g2000hsv.googlegro ups.com...
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
Please do a db2look and post the DDL for the table. You can do this with
the Control Center.
Here's the DDL (got from Quest Central)
CREATE TABLE ABC_ADDRESS
(TC_ABC_ID VARCHAR(50) NOT NULL,
ABC_ID BIGINT NOT NULL,
O_LOCATION_ID BIGINT NOT NULL,
O_LOCATION_ALIAS_ID VARCHAR(16),
O_ADDRESS_LINE_1 VARCHAR(75),
O_ADDRESS_LINE_2 VARCHAR(75),
O_ADDRESS_LINE_3 VARCHAR(75),
O_CITY VARCHAR(40),
O_STATE_PROV VARCHAR(2),
O_COUNTY VARCHAR(40),
O_POSTAL_CODE VARCHAR(10),
O_COUNTRY_CODE VARCHAR(2),
C_LOCATION_ID BIGINT NOT NULL,
C_LOCATION_ALIAS_ID VARCHAR(16),
C_ADDRESS_LINE_1 VARCHAR(75),
C_ADDRESS_LINE_2 VARCHAR(75),
C_ADDRESS_LINE_3 VARCHAR(75),
C_CITY VARCHAR(40),
C_STATE_PROV VARCHAR(2),
C_COUNTY VARCHAR(40),
C_POSTAL_CODE VARCHAR(10),
C_COUNTRY_CODE VARCHAR(2),
D_LOCATION_ID BIGINT NOT NULL,
D_LOCATION_ALIAS_ID VARCHAR(16),
D_ADDRESS_LINE_1 VARCHAR(75),
D_ADDRESS_LINE_2 VARCHAR(75),
D_ADDRESS_LINE_3 VARCHAR(75),
D_CITY VARCHAR(40),
D_STATE_PROV VARCHAR(2),
D_COUNTY VARCHAR(40),
D_POSTAL_CODE VARCHAR(10),
D_COUNTRY_CODE VARCHAR(2),
HIBERNATE_VERSION BIGINT
)
DATA CAPTURE NONE
IN USERSPACE1;
The following insert gives the above error.
insert into abc_address(lpn_id) values(1);
The table contains 5 columns defined with NOT NULL. Your INSERT statement
specifies only 1 column (and one that doesn't even exist in the table).
How are the values for the other not-nullable columns provided? Maybe you
do have some triggers?
However, the problem goes away after the table is dropped and
recreated.
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
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
On Oct 8, 8:31 pm, m <mdlspo...@yahoo.comwrote:
Rahul Babbar wrote:
On Oct 8, 6:32 pm, "Mark A" <nob...@nowhere.comwrote:
"Rahul Babbar" <rahul.babb...@gmail.comwrote in message
>news:11*********************@57g2000hsv.googlegro ups.com...
>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
Please do a db2look and post the DDL for the table. You can do this with the
Control Center.
Here's the DDL (got from Quest Central)
CREATE TABLE ABC_ADDRESS
(TC_ABC_ID VARCHAR(50) NOT NULL,
ABC_ID BIGINT NOT NULL,
O_LOCATION_ID BIGINT NOT NULL,
O_LOCATION_ALIAS_ID VARCHAR(16),
O_ADDRESS_LINE_1 VARCHAR(75),
O_ADDRESS_LINE_2 VARCHAR(75),
O_ADDRESS_LINE_3 VARCHAR(75),
O_CITY VARCHAR(40),
O_STATE_PROV VARCHAR(2),
O_COUNTY VARCHAR(40),
O_POSTAL_CODE VARCHAR(10),
O_COUNTRY_CODE VARCHAR(2),
C_LOCATION_ID BIGINT NOT NULL,
C_LOCATION_ALIAS_ID VARCHAR(16),
C_ADDRESS_LINE_1 VARCHAR(75),
C_ADDRESS_LINE_2 VARCHAR(75),
C_ADDRESS_LINE_3 VARCHAR(75),
C_CITY VARCHAR(40),
C_STATE_PROV VARCHAR(2),
C_COUNTY VARCHAR(40),
C_POSTAL_CODE VARCHAR(10),
C_COUNTRY_CODE VARCHAR(2),
D_LOCATION_ID BIGINT NOT NULL,
D_LOCATION_ALIAS_ID VARCHAR(16),
D_ADDRESS_LINE_1 VARCHAR(75),
D_ADDRESS_LINE_2 VARCHAR(75),
D_ADDRESS_LINE_3 VARCHAR(75),
D_CITY VARCHAR(40),
D_STATE_PROV VARCHAR(2),
D_COUNTY VARCHAR(40),
D_POSTAL_CODE VARCHAR(10),
D_COUNTRY_CODE VARCHAR(2),
HIBERNATE_VERSION BIGINT
)
DATA CAPTURE NONE
IN USERSPACE1;
ALTER TABLE ABC_ADDRESS
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_PK PRIMARY KEY
(ABC_ID
);
ALTER TABLE ABC_ADDRESS
ADD CONSTRAINT ABC_ADDRESS_FK FOREIGN KEY
(ABC_ID
)
REFERENCES ABC
(ABC_ID
)
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
The following insert gives the above error.
insert into abc_address(lpn_id) values(1);
However, the problem goes away after the table is dropped and
recreated.
Rahul
I dont see a column called lpn_id in the table.... :D
Sorry,
The insert query is
insert into abc_address(abc_id) values(1);
Still it gives the same error.
Rahul
On Oct 9, 12:09 am, Knut Stolze <sto...@de.ibm.comwrote:
Rahul Babbar wrote:
On Oct 8, 6:32 pm, "Mark A" <nob...@nowhere.comwrote:
"Rahul Babbar" <rahul.babb...@gmail.comwrote in message
>news:11*********************@57g2000hsv.googlegro ups.com...
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
Please do a db2look and post the DDL for the table. You can do this with
the Control Center.
Here's the DDL (got from Quest Central)
CREATE TABLE ABC_ADDRESS
(TC_ABC_ID VARCHAR(50) NOT NULL,
ABC_ID BIGINT NOT NULL,
O_LOCATION_ID BIGINT NOT NULL,
O_LOCATION_ALIAS_ID VARCHAR(16),
O_ADDRESS_LINE_1 VARCHAR(75),
O_ADDRESS_LINE_2 VARCHAR(75),
O_ADDRESS_LINE_3 VARCHAR(75),
O_CITY VARCHAR(40),
O_STATE_PROV VARCHAR(2),
O_COUNTY VARCHAR(40),
O_POSTAL_CODE VARCHAR(10),
O_COUNTRY_CODE VARCHAR(2),
C_LOCATION_ID BIGINT NOT NULL,
C_LOCATION_ALIAS_ID VARCHAR(16),
C_ADDRESS_LINE_1 VARCHAR(75),
C_ADDRESS_LINE_2 VARCHAR(75),
C_ADDRESS_LINE_3 VARCHAR(75),
C_CITY VARCHAR(40),
C_STATE_PROV VARCHAR(2),
C_COUNTY VARCHAR(40),
C_POSTAL_CODE VARCHAR(10),
C_COUNTRY_CODE VARCHAR(2),
D_LOCATION_ID BIGINT NOT NULL,
D_LOCATION_ALIAS_ID VARCHAR(16),
D_ADDRESS_LINE_1 VARCHAR(75),
D_ADDRESS_LINE_2 VARCHAR(75),
D_ADDRESS_LINE_3 VARCHAR(75),
D_CITY VARCHAR(40),
D_STATE_PROV VARCHAR(2),
D_COUNTY VARCHAR(40),
D_POSTAL_CODE VARCHAR(10),
D_COUNTRY_CODE VARCHAR(2),
HIBERNATE_VERSION BIGINT
)
DATA CAPTURE NONE
IN USERSPACE1;
The following insert gives the above error.
insert into abc_address(lpn_id) values(1);
The table contains 5 columns defined with NOT NULL. Your INSERT statement
specifies only 1 column (and one that doesn't even exist in the table).
How are the values for the other not-nullable columns provided? Maybe you
do have some triggers?
However, the problem goes away after the table is dropped and
recreated.
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Hi,
I had mentioned in my first post that there are no triggers on the
table.
Further, if i don't give the not nullable columns then, it gives the
error, "cannot assign null value to a not null column"
Further, we have tried giving all the values for not nullable
columns(you can trust me for that) and it gives the same error.
It starts giving "cannot assign null value to a not null column" error
once the table is recreated, and everything works fine.
one more observation i found out, iniatially it was giving this error
for many tables, however, i was able to fix for a table or two after
doing a reorg on the table. However, Reorg did not work for any other
tables.
Rahul
On Oct 9, 8:25 am, Serge Rielau <srie...@ca.ibm.comwrote:
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
Rahul Babbar wrote:
I had mentioned in my first post that there are no triggers on the
table.
Yes, you did.
Further, if i don't give the not nullable columns then, it gives the
error, "cannot assign null value to a not null column"
Further, we have tried giving all the values for not nullable
columns(you can trust me for that) and it gives the same error.
You should have told us that.
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: coosa |
last post by:
I have a table:
----------------------------------------------------
CREATE TABLE CATEGORY (
CATEGORY_ID INTEGER IDENTITY(1,1) NOT NULL,
CATEGORY_NAME VARCHAR(40) NOT NULL,...
|
by: Bri |
last post by:
Hi,
First let me explain the process I have going on, then I'll address the
problems I'm having:
1) Insert records in a temp table using a query
2) Using a query that joins the temp table with...
|
by: Ramesh |
last post by:
hi
I am trying to insert 50,000 random records in the SQL
server. I have created COM for inserting records. When i
started inserting, after 44152 records it displayed
following error message.
"...
|
by: ing42 |
last post by:
I have a problem with inserting records into table when an indexed view
is based on it.
Table has text field (without it there is no problem, but I need it).
Here is a sample code:
USE test
GO...
|
by: ammmmmu |
last post by:
Hi all,
I am using VB 5.0 and msaccess as a database, I am reading the data from logfiles and inserting it in db, its not throwing any error, but after excecution I not find any records in table...
|
by: hafeez |
last post by:
Hello All,
I created two database instances in the same MS SQL SERVER 2005 named hafeez and local. I created a linked server from hafeez database to local named HTOL
I created a dummy table in...
|
by: Armin Zingler |
last post by:
"Bill Schanks" <wschanks@gmail.comschrieb
Try to execute
lvMembers.beginupdate
before filling and
lvMembers.endupdate
|
by: KDawg44 |
last post by:
Hi,
I have PHP function that adds a record to the database. The table has
an ID that is AUTO_INCREMENT. Is there anyway to get that ID back
when I do any kind of insert? That ID is a foreign...
|
by: hakkatil |
last post by:
Hi to all,
I have a page that inserts excel sheet to access database. I am using asp. What I want to do is to check the inserting record if it is in the database. Basicly checking the dublicate...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
