|
View previous topic :: View next topic
|
| Author |
Message |
sanjida
New User
Joined: 30 Dec 2007
Posts: 13
Location: delhi
|
|
|
|
i am trying to change a field in a child table which is a foriengn key using fileaid for db2.
the reason is the table has a parent table.
can anybody help me how can i change using fileaid for db2 tool. |
|
| Back to top |
|
 |
Ritesh Chopra
New User
Joined: 15 Oct 2007
Posts: 13
Location: India
|
|
|
|
| sanjida wrote: |
i am trying to change a field in a child table which is a foriengn key using fileaid for db2.
the reason is the table has a parent table.
can anybody help me how can i change using fileaid for db2 tool. |
Please mention the problem clearly. Is it that you want to change a field that references another field ? Where is the problem exactly ? |
|
| Back to top |
|
|
sanjida
New User
Joined: 30 Dec 2007
Posts: 13
Location: delhi
|
|
|
|
actually i want to change a field called APPL_ID in a child table(a1) which is foriegn key .
when i trying to chaNGE ITS NOT ALLOWING ME .
how can i do it using file aid for db2. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
Referential Integrity... that' s the buzzword
You simply cannot do it, it is not a fileaid issue...
it' s a table/application design constraint !! |
|
| Back to top |
|
|
sanjida
New User
Joined: 30 Dec 2007
Posts: 13
Location: delhi
|
|
|
|
how should i approach for this problem.
thanks for the reply |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| Add the needed row to the parent table first or drop the referential constraint. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
You might also talk with your dba(s) to make sure you understand the "rules" concerning these tables. |
|
| Back to top |
|
|
|
|
