|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
||||
|
||||
|
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? |
|
#2
|
||||
|
||||
|
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 |
|
#3
|
|||
|
|||
|
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] |
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > DB2 constraint rules definitions? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|