Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Fileaid db2 referential integrity

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
sanjida

New User


Joined: 30 Dec 2007
Posts: 13
Location: delhi

PostPosted: Sun Jan 20, 2008 6:10 pm    Post subject: Fileaid db2 referential integrity
Reply with quote

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
View user's profile Send private message

Ritesh Chopra

New User


Joined: 15 Oct 2007
Posts: 13
Location: India

PostPosted: Mon Jan 21, 2008 2:46 pm    Post subject: Re: fileaid db2 refrential integrity
Reply with quote

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
View user's profile Send private message
sanjida

New User


Joined: 30 Dec 2007
Posts: 13
Location: delhi

PostPosted: Mon Jan 21, 2008 10:12 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Mon Jan 21, 2008 11:02 pm    Post subject: Reply to: fileaid db2 refrential integrity
Reply with quote

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
View user's profile Send private message
sanjida

New User


Joined: 30 Dec 2007
Posts: 13
Location: delhi

PostPosted: Tue Jan 22, 2008 9:20 am    Post subject:
Reply with quote

how should i approach for this problem.

thanks for the reply
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Jan 22, 2008 4:23 pm    Post subject:
Reply with quote

Add the needed row to the parent table first or drop the referential constraint.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jan 22, 2008 10:21 pm    Post subject:
Reply with quote

Hello,

You might also talk with your dba(s) to make sure you understand the "rules" concerning these tables.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Using Field names in FILEAID Batch CO... Atul Banke Compuware & Other Tools 2 Wed Jun 29, 2016 9:54 pm
No new posts FileAid to compare(logical operations... anand1204 Compuware & Other Tools 3 Wed Apr 06, 2016 2:55 am
No new posts fileaid CHANGED parameter boyti ko Compuware & Other Tools 3 Fri Dec 19, 2014 1:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us