View previous topic :: View next topic
|
Author |
Message |
manya jyoti
New User
Joined: 30 Mar 2009 Posts: 1 Location: Delhi
|
|
|
|
Hi! This is your First post in our Forums! So please be sure to 1) Use meaningful and descriptive Topic Title 2) Try to post your query in the relevant forum category 3) Make sure your query is not already posted and solved in our forums, Use the Search facility and avoid Reposts! If you are following the above rules, delete this message and post your query here! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
What does "child table" mean to you (unfortunately, the term means different things to diffeent people/organizations).
Suggest you talk with your dba to get the info you want from your environment. |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi
This post is seems to be funny.
Who is posting. What is the post. Is the requester is satisfied with the replay?
Raghu |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
This post is seems to be funny. |
I believe not. . .
Quote: |
Who is posting. What is the post. |
Suggest your time would be better spent doing something other than this post. . .
It was the first post for Manya. The question is the topic subject.
Maybe Manya will post some follow up info and we'll know if there are more questions or if it is resolved. |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi Dick
See the post of Manya
Hi! This is your First post in our Forums! So please be sure to 1) Use meaningful and descriptive Topic Title 2) and it continues
Form this I post I understood that Manya- the person who wrote the post- is saying.... Hi This is your First post in our Forums! ...
What can a person who read the post will understand?
The post comes under the name manya joyti. Normally a normal person can see something wrong this. That is what I feel and expressed. If it hurts any body, sorry and I hereby withdraw my words.
And don't say what I have to do
Thanks
Raphe |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Raphe,
Quote: |
And don't say what I have to do |
Dick only made a suggestion; he did not tell you what to do.
I would suggest not being so sensitive and learn more english so that in the future your posts are not miss-interpreted. |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi Dick
This is not the forum for this type of argument.
You being a senior member in this forum we expect something productive from you.
Regards
Raghu |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
[sarcasm on]
Yes, Dick; how about being more productive?
[/sarcasm off]
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
given also the high salary, and the fringe benefits |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi Raghu,
Raghu navaikulam wrote: |
See the post of Manya
Hi! This is your First post in our Forums! So please be sure to 1) Use meaningful and descriptive Topic Title 2) and it continues |
When a "new user" posts his/her very first post on this forum these lines (bold ones) are automatically "inserted" - one is supposed to remove them & post the supporting explanation about the "actual question" . . . |
|
Back to top |
|
|
mtaylor
Active User
Joined: 20 Feb 2009 Posts: 108 Location: Kansas City
|
|
|
|
I did this one time; Do a query on SYSIBM.TABLES and join on FORIEGN_KEY relationships or something. It's been a few years. |
|
Back to top |
|
|
mtaylor
Active User
Joined: 20 Feb 2009 Posts: 108 Location: Kansas City
|
|
|
|
mtaylor wrote: |
I did this one time; Do a query on SYSIBM.TABLES and join on FORIEGN_KEY relationships or something. It's been a few years. |
Oh and this is only good for Schema RI, won't tell you anything about Application enforced RI of which there is often quiet a lot. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Jyothi,
This is what you are looking for
Code: |
SELECT A.REFTBNAME
, A.REFTBCREATOR
, A.CREATOR
, A.TBNAME
, A.RELNAME
FROM SYSIBM.SYSRELS A
WHERE A.REFTBNAME = 'INET_CASE'
ORDER BY A.REFTBNAME
, A.REFTBCREATOR
, A.RELNAME
; |
Thank You,
Sushanth Bobby |
|
Back to top |
|
|
ashishsr123
New User
Joined: 06 May 2008 Posts: 33 Location: Chennai
|
|
|
|
Hi, Jyothi,
If you have DB2 catalog manager at your shop , finding parent table ,will be a Child's play .
If you have it ,do let me know i will give you screenshots of it to help you find out.
Regards,
Ashish |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
If you have DB2 catalog manager at your shop , finding parent table ,will be a Child's play |
Not necessarily. . . .
If it is an older system, very likely not child's play - it may not even be do-able looking only at the database definition. . .
Please look at this topic:
ibmmainframes.com/viewtopic.php?t=40025 |
|
Back to top |
|
|
|