Table2 -> Table3 -> Table2 .. I can not select data from these tables as they give % db2 "select count(*) from table1" 1 ----------- SQL0668N Operation not allowed for reason code "1" on table "TABLE1". SQLSTATE=57016 Can anyone tell me how to resolve this? Thanks, Prince. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <629275ba.0310071517.26e8f8e6@posting.google.com> [ref] => [htmlstate] => on_nl2br [postusername] => Prince [ip] => gspk@yahoo.com [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> Table2 -> Table3 -> Table2 .. > > > I can not select data from these tables as they give > > % db2 "select count(*) from table1" > > 1 > ----------- > SQL0668N Operation not allowed for reason code "1" on table > "TABLE1". SQLSTATE=57016 > > Can anyone tell me how to resolve this? > > Thanks, > Prince.[/ref] -- Pierre Saint-Jacques IBM DB2 Cerified Solutions Expert - Administration SES Consultants Inc. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <3F834EC5.6080408@attglobal.net> [ref] => <629275ba.0310071517.26e8f8e6@posting.google.com> [htmlstate] => on_nl2br [postusername] => P. [ip] => sescons@attglob [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> Table2 -> Table3 -> Table2 .. > > > > > > I can not select data from these tables as they give > > > > % db2 "select count(*) from table1" > > > > 1 > > ----------- > > SQL0668N Operation not allowed for reason code "1" on table > > "TABLE1". SQLSTATE=57016 > > > > Can anyone tell me how to resolve this? > > > > Thanks, > > Prince.[/ref][/ref] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <629275ba.0310080953.5d3adbd6@posting.google.com> [ref] => <629275ba.0310071517.26e8f8e6@posting.google.com> <3F834EC5.6080408@attglobal.net> [htmlstate] => on_nl2br [postusername] => Prince [ip] => gspk@yahoo.com [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> set integrity with cascade (cyclic reference) - IBM DB2
Professional Web Applications Themes

set integrity with cascade (cyclic reference) - IBM DB2

I just created a DB and loaded the tables with data from Oracle DB. Now, Im trying to enable the constraints using db2 "set integrity for table1 immediate checked" I get the following error DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL3608N Cannot check a dependent table "TABLE1" using the SET INTEGRITY statement while the parent table or underlying table "TESTOWNER.TABLE2" is in the check pending state or if it will be put into the check pending state by the SET INTEGRITY statement. ...

  1. #1

    Default set integrity with cascade (cyclic reference)

    I just created a DB and loaded the tables with data from Oracle DB.

    Now, Im trying to enable the constraints using
    db2 "set integrity for table1 immediate checked"

    I get the following error

    DB21034E The command was processed as an SQL statement because it was
    not a
    valid Command Line Processor command. During SQL processing it
    returned:
    SQL3608N Cannot check a dependent table "TABLE1" using the SET
    INTEGRITY statement while the parent table or underlying table
    "TESTOWNER.TABLE2" is in the check pending state or if it will be put
    into
    the check pending state by the SET INTEGRITY statement.
    SQLSTATE=428A8

    Then, I did,

    db2 "set integrity for table2 immediate checked"

    This gives the error similar to the one for Table1, but the
    parent/underlying table Table3.

    Then I did the check on Table3, which gives the exact same error as
    Table1.


    Now, I am in a loop. I issue Table1 --> Table2 -> Table3 -> Table2 ..


    I can not select data from these tables as they give

    % db2 "select count(*) from table1"

    1
    -----------
    SQL0668N Operation not allowed for reason code "1" on table
    "TABLE1". SQLSTATE=57016

    Can anyone tell me how to resolve this?

    Thanks,
    Prince.
    Prince Guest

  2. #2

    Default Re: set integrity with cascade (cyclic reference)

    Try this:
    select tabname,status,const_checked from syscat.tables where status='c'

    This should give you all the tables in check pending.
    You then need to state each and every table in the SET INTEGRITY command.

    This is a bit rusty as I've not done this in a long time but I think I
    remmber that's the procedure.
    HTH, Pierre.
    PS: Don't forgrt your exception tables.

    Prince Kumar wrote:
     

    --
    Pierre Saint-Jacques
    IBM DB2 Cerified Solutions Expert - Administration
    SES Consultants Inc.

    P. Guest

  3. #3

    Default Re: set integrity with cascade (cyclic reference)

    In article <google.com>,
    com says... 

    'set integrity for table1, table2, table3 immediate checked' should
    work.
    Gert Guest

  4. #4

    Default Re: set integrity with cascade (cyclic reference)

    Thank you both for your response.

    The suggested solution worked perfect.

    Prince.

    "P. Saint-Jacques" <net> wrote in message news:<net>... [/ref]
    Prince Guest

Similar Threads

  1. Dropdownlist Cascade
    By JimmyB4B in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 1
    Last Post: December 18th, 04:50 AM
  2. Cyclic Restart on SunFire 280R
    By Alvaro Puente in forum Linux / Unix Administration
    Replies: 0
    Last Post: April 16th, 07:51 AM
  3. [ANN] cyclic logs commands and libraries
    By apm in forum Linux / Unix Administration
    Replies: 0
    Last Post: March 1st, 01:22 PM
  4. Marshalling cyclic data structures
    By Nathan Weston in forum Ruby
    Replies: 5
    Last Post: November 3rd, 03:07 AM
  5. Seemingly Random Cyclic Errors
    By Don Shirah in forum ASP Database
    Replies: 1
    Last Post: July 20th, 04:06 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139