> ISC ERROR MESSAGE:
> Operation violates CHECK constraint INTEG_30 on view or table
> EMPLOYEE

Check the triggers and field constraints on the EMPLOYEE table and
make sure your data meets those requirements. In my copy of EMPLOYEE
INTEG_30 relates to trigger CHECK_4 which looks like...

CHECK ( salary >= (SELECT min_salary FROM job WHERE
job.job_code = employee.job_code AND
job.job_grade = employee.job_grade AND
job.job_country = employee.job_country) AND
salary <= (SELECT max_salary FROM job WHERE
job.job_code = employee.job_code AND
job.job_grade = employee.job_grade AND
job.job_country = employee.job_country))


--
Geoff Worboys
Telesis Computing