Page 1 of 2

Parent Table and Child Table

PostPosted: Mon Jun 22, 2009 10:40 pm
by chetan_007
Hi,

Suppose If I want to make some updates in Parent table then I need to update corresponding child tables too.
But, how can I know the child table names associated with parent table in DB2.

Could any one explain me.

Thanks,
Chetan

Re: Parent Table and Child Table

PostPosted: Mon Jun 22, 2009 11:34 pm
by dick scherrer
Hello,

If this has not already been provided via an entity relationship diagram of something similar, you should talk with your dba.

Re: Parent Table and Child Table

PostPosted: Fri Nov 20, 2009 12:24 pm
by jitender_2004bhiwani
Hello,

when browsing the table using DB2 fileaid, use command 'rbrowse' it will display all parent and child relations for that table.

Re: Parent Table and Child Table

PostPosted: Fri Nov 20, 2009 12:30 pm
by jitender_2004bhiwani
see below screens for more help:

QAOS#2 D for DB2 Browse RAVFS2.TVFPAYI_PI SSID: DQA0
COMMAND ===> rbrowse SCROLL ===> CSR
PI_ID PARTITION_NO IMPORT_FILE_ID PI_SUB_TYPE_ID SYSTEM_S
DEC(11,0) SMALLINT DEC(11,0) SMALLINT CHAR(4)
------PRIMARY ------------ -------------- -------------- --------
000001 950. 1 ------------- 5 COMP
000002 3400. 1 ------------- 5 COMP

then press enter and following screen will appear;

QAOS#2 Row 1 to 6 of 23
COMMAND ===>

A one to one or one to many relationship exists.
Use ADD to create a new application relationship or select an existing
relationship definition.
To edit a view: overtype displayed table name with a valid single table
view name.

Line Commands:
S - Select table
I - Relationship Information

CMD Creator Table/View Type
--- -------- ------------------- --------------------------------
_ RAVFS2 TVFACCC_CHARGE_ACC RI - CHILD
_ RAVFS2 TVFBENF_BENEFICRY RI - CHILD
_ RAVFS2 TVFBLKT_BLKLST_TMP RI - CHILD
_ RAVFS2 TVFBLKT_BLKLST_TMP RI - CHILD
_ RAVFS2 TVFCANC_CANC_REQST RI - CHILD
_ RAVFS2 TVFDACC_DEBIT_ACC RI - CHILD

Re: Parent Table and Child Table

PostPosted: Sat Nov 21, 2009 2:43 am
by dick scherrer
Hello,

If someone asks a question about file-aid, it is good to provide a file-aid answer.

As most systems to not have file-aid/db2 it is best not to provide solutions that require this product to general questions.

Re: Parent Table and Child Table

PostPosted: Sat Nov 21, 2009 5:19 pm
by enrico-sorichetti
see below screens for more help:
the help/answer will be completely useless if the TS does not have the product/tool You are suggesting

Re: Parent Table and Child Table

PostPosted: Wed Nov 25, 2009 10:14 pm
by GuyC
look in sysibm.sysrels (if the relationship is documented in DB2)

Re: Parent Table and Child Table

PostPosted: Tue Dec 01, 2009 10:15 am
by jitender_2004bhiwani
Dick/enrico,

I agree that the help/answer given by me is completetly useless if the TS does not have DB2 fileaid. But DB2 fileaid is a common product which most of the company (around 95 %) have whoever is using IBM DB2. Also I am suggesting one of the way to find a solution for the user's problem without any concern to what the user have on thier site.

In mainframe world, there are different ways to handle everything which are site specific, so if we will think more about them we won't to be able to help the people.

Re: Parent Table and Child Table

PostPosted: Tue Dec 01, 2009 10:58 am
by dick scherrer
Hello,

But DB2 fileaid is a common product which most of the company (around 95 %) have whoever is using IBM DB2.
Where did you get this statistic? Compuware would surely be happy if their fileaid/db2 product was licensed at 95% of the organizations that have db2 :)

In mainframe world, there are different ways to handle everything which are site specific, so if we will think more about them we won't to be able to help the people.
Almost everything (except a product specific question) can be answered by some "standard" solution (see the suggestion from GuyC). Most situations do not require some site-specific product.

Re: Parent Table and Child Table

PostPosted: Tue Mar 09, 2010 9:37 pm
by chetan_007
What are the different version of DB2 are available for mainframes since inception?
Please give me the list of DB2 versions till date. (Also I'm not clear about the tem DB2 UDB - is it related to mainframes DB2)?