Helpful Information
 
 
Category: DB2 Development
DB2 constraint rules definitions?

Ok, I am currently tackling a kickoff of the phpMyAdmin(mysql) script for db2 but I have run into a bit of a hard spot.

When I build the table into a script form (pure sql) everything goes fine until I go to rebuild the foreign keys. Everything I know about db2's structuring is held in the syscat schema. The table that contains all of the foreign key references is kept in a table called syscat.references. Now, there are two columns that contain rules for each constraint(reference), updaterule and deleterule. From what I can tell each only contain a single letter. Now from the different applications that I have created there are only two different entries for this, a cascade rule and a blank rule which would be C and A in the field respectively. Now, I can replicate my own tables flawlessly, but I cannot find a reference to where these rules are defined.

Can anyone point me in the direction to where I can find the information on where the update/delete rules are defined?

Incase anyone is interested I found the answer:

for the deleterule there are four possibilities:
(A) No Action
(C) Cascade
(R) Restrict
(S) Set NULL

for the updaterule there are two possibilities:
(A) No Action
(R) Restrict

Could you please share me about the deleterule?

for the deleterule there are four possibilities:
(A) No Action
(C) Cascade
(R) Restrict
(S) Set NULL

for the updaterule there are two possibilities:
(A) No Action
(R) Restrict[/QUOTE]










privacy (GDPR)