By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

IMMEDIATE CHECKED

P: n/a
Hi!

I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO TABLE1 and LOAD FROM NUL REPLACE
INTO TABLE2 and both tables are in Set Integrity Pending state.

If I do SET INTEGRITY FOR TABLE1 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE1" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE2" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

If I do SET INTEGRITY FOR TABLE2 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE2" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE1" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

Im in a magic loop here. :)))
Is there a way to get out ? :))

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Mar 1 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi!

I just dropped the foreign key from TABLE1 to TABLE2 and recreated it alter
successfull SET INTEGRITY.

Best regards,
Kovi

Gregor Kovańć wrote:
Hi!

I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO TABLE1 and LOAD FROM NUL REPLACE
INTO TABLE2 and both tables are in Set Integrity Pending state.

If I do SET INTEGRITY FOR TABLE1 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE1" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE2" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

If I do SET INTEGRITY FOR TABLE2 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE2" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE1" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

Im in a magic loop here. :)))
Is there a way to get out ? :))

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Mar 1 '07 #2

P: n/a
On Thu, 01 Mar 2007 10:07:00 +0100, Gregor Kova?
<gr**********@mikropis.siwrote:
>Hi!

I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO TABLE1 and LOAD FROM NUL REPLACE
INTO TABLE2 and both tables are in Set Integrity Pending state.

If I do SET INTEGRITY FOR TABLE1 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE1" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE2" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

If I do SET INTEGRITY FOR TABLE2 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE2" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE1" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

Im in a magic loop here. :)))
Is there a way to get out ? :))

Best regards,
Kovi
Yep. Do both at the same time.

SET INTEGRITY FOR TABLE1, TABLE2 IMMEDIATE CHECKED

B.
Mar 1 '07 #3

P: n/a
Brian Tkatch <N/Awrote:
On Thu, 01 Mar 2007 10:07:00 +0100, Gregor Kova?
<gr**********@mikropis.siwrote:
>>Hi!

I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO TABLE1 and LOAD FROM NUL REPLACE
INTO TABLE2 and both tables are in Set Integrity Pending state.

If I do SET INTEGRITY FOR TABLE1 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE1" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE2" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

If I do SET INTEGRITY FOR TABLE2 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE2" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE1" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

Im in a magic loop here. :)))
Is there a way to get out ? :))

Best regards,
Kovi

Yep. Do both at the same time.

SET INTEGRITY FOR TABLE1, TABLE2 IMMEDIATE CHECKED

B.
Yes, much easier way. :)) I was looking at the syntax, but just didn't see
that back arrow. :((

Best regards,
Kovi

--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Mar 1 '07 #4

P: n/a
On Thu, 01 Mar 2007 21:27:00 +0100, Gregor Kova?
<gr**********@mikropis.siwrote:
>Brian Tkatch <N/Awrote:
>On Thu, 01 Mar 2007 10:07:00 +0100, Gregor Kova?
<gr**********@mikropis.siwrote:
>>>Hi!

I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO TABLE1 and LOAD FROM NUL REPLACE
INTO TABLE2 and both tables are in Set Integrity Pending state.

If I do SET INTEGRITY FOR TABLE1 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE1" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE2" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

If I do SET INTEGRITY FOR TABLE2 IMMEDIATE CHECKED first I get:
SQL3608N Cannot check a dependent table "TABLE2" using the SET
INTEGRITY statement while the parent table or underlying table
"TABLE1" is in the Set Integrity Pending state or if it will be put
into the Set Integrity Pending state by the SET INTEGRITY statement.
SQLSTATE=428A8

Im in a magic loop here. :)))
Is there a way to get out ? :))

Best regards,
Kovi

Yep. Do both at the same time.

SET INTEGRITY FOR TABLE1, TABLE2 IMMEDIATE CHECKED

B.

Yes, much easier way. :)) I was looking at the syntax, but just didn't see
that back arrow. :((

Best regards,
Kovi
Neither did i!!! I posted this a little while back too. It is
especially useful for ignoring reference order.

B.
Mar 1 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.