IBM Mainframe Forum

insert thru select is giivng error for multiple rows insert

---- copying data from db2 shipped sample databse

beow are table descriptions

Select all

CREATE TABLE  DEPT
      (DEPTNO    CHAR(3)           NOT NULL,
       DEPTNAME  VARCHAR(36)       NOT NULL,
       MGRNO     CHAR(6)                   ,
       ADMRDEPT  CHAR(3)           NOT NULL,
       LOCATION  CHAR(16)                  ,
       PRIMARY KEY (DEPTNO)                )
  IN mydatabase

ALTER TABLE  DEPT
      FOREIGN KEY RDD (ADMRDEPT) REFERENCES DBMATE01.DEPT
              ON DELETE CASCADE;

following are the indexes
DEPTNO Primary, ascending
MGRNO Ascending
ADMRDEPT Ascending

my insert query
insert into dept
select * from DSN8910.dept;

And your error is? And the manual says with regard to that error code?

error

SQLCODE = -533, ERROR: INVALID MULTIPLE-ROW INSERT

Reading the fine manual makes obvious what you have done wrong.

yes the errror says it doesn't allow multple row insert
and sujests to insert by one row at time,,,,,


but i like to know whats the reason for failure of multiple insert ,,, is it due to index or primary key ?
as i executed with different table and it was successful