Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Posts
    10

    Unanswered: remove constraints on db2 table

    Hi All,

    Can anyone help ,how we can remove constraints on table,

    Below are error message,

    DELETE FROM DB2.CHNG_EVNT_ITM;
    SQLERROR ON DELETE COMMAND, EXECUTE FUNCTION
    RESULT OF SQL STATEMENT:
    DSNT408I SQLCODE = -532, ERROR: THE RELATIONSHIP CCHEID02 RESTRICTS THE DELETI
    DSNT418I SQLSTATE = 23504 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNXRSDL SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = -190 13172769 0 13228485 -742129664 0 SQL DIAGNOSTIC
    DSNT416I SQLERRD = X'FFFFFF42' X'00C90021' X'00000000' X'00C9D9C5' X'D3C
    INFORMATION

  2. #2
    Join Date
    Apr 2012
    Posts
    156
    Alter table drop constraint .....
    To determine the constraint(s) look at catalog table syscat.constdep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •