Is there a way to tell DB2 to continue on error and then to insert
tuples that don't exist in a table?
I'd like to modify the following SQL statement to do that. Executing
this statement results in a SQL0803N error.
I'm using DB2 8.1.
Thanks.
insert into emp_group
(emp_id,group_i d,active,
created_by,crea ted_date,
modified_by,mod ified_date)
select ee.emp_id,
(select group_id from group_lookup where short_name='BR( 005901) AT'),
'YES',
'BATCH01', current timestamp,
'BATCH01', current timestamp
from employee ee
join emp_group eg on ee.emp_id=eg.em p_id
join group_lookup gp on eg.group_id=gp. group_id
where
ee.office = '005901'
and gp.attribute='L OB'
and gp.group_name=' SPSS';
tuples that don't exist in a table?
I'd like to modify the following SQL statement to do that. Executing
this statement results in a SQL0803N error.
I'm using DB2 8.1.
Thanks.
insert into emp_group
(emp_id,group_i d,active,
created_by,crea ted_date,
modified_by,mod ified_date)
select ee.emp_id,
(select group_id from group_lookup where short_name='BR( 005901) AT'),
'YES',
'BATCH01', current timestamp,
'BATCH01', current timestamp
from employee ee
join emp_group eg on ee.emp_id=eg.em p_id
join group_lookup gp on eg.group_id=gp. group_id
where
ee.office = '005901'
and gp.attribute='L OB'
and gp.group_name=' SPSS';
Comment