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]