hierarchal query in db2

hierarchal query in db2

 

  


Hi guru's
please tell me is there any way by which i can get all the child record of
the parent key. I know in oracle there is a clause START WITH and CONNECT
BY PRIOR clause(hierarchal query). Is there any similar kind of clause.
It is very urgent for me.
waiting for reply
regards
shailendra

-----Original Message-----
From: db2udbdba-[Email Address Removed] [mailto:db2udbdba-[Email Address Removed] Wednesday, April 10, 2002 3:44 PM
To: [Email Address Removed] WELCOME to [Email Address Removed] This is the ezmlm program. I'm managing the
[Email Address Removed] mailing list.

I'm working for my owner, who can be reached
at db2udbdba-[Email Address Removed] I have added the address

[Email Address Removed] the db2udbdba mailing list.

Welcome to [Email Address Removed] save this message so that you know the address you are
subscribed under, in case you later want to unsubscribe or change your
subscription address.

To unsubscribe, send a message to:

<db2udbdba-unsubscribe-ShailendraBh=NIIT.[Email Address Removed] Administrative commands for the db2udbdba list ---

I can handle administrative requests automatically. Please
do not send them to the list address! Instead, send
your message to the correct command address:

For help and a description of available commands, send a message to:
<db2udbdba-[Email Address Removed] subscribe to the list, send a message to:
<db2udbdba-[Email Address Removed] remove your address from the list, just send a message to
the address in the ``List-Unsubscribe'' header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
<db2udbdba-[Email Address Removed] for the digest to:
<db2udbdba-digest-[Email Address Removed] addition or removal of addresses, I'll send a confirmation
message to that address. When you receive it, simply reply to it
to complete the transaction.

If you need to get in touch with the human owner of this list,
please send a message to:

<db2udbdba-[Email Address Removed] include a FORWARDED list message with ALL HEADERS intact
to make it easier to help you.

--- Enclosed is a copy of the request I received.

Return-Path: <[Email Address Removed] (qmail 10694 invoked from network); 10 Apr 2002 10:13:54 -0000
Received: from web20509.mail.yahoo.com (216.136.226.144)
by teonline.net with SMTP; 10 Apr 2002 10:13:54 -0000
Message-ID: <20020410100837.50375.[Email Address Removed] from [203.200.76.80] by web20509.mail.yahoo.com via HTTP; Wed, 10
Apr 2002 03:08:37 PDT
Date: Wed, 10 Apr 2002 03:08:37 -0700 (PDT)
From: d23 gty <[Email Address Removed] 1.0
Content-Type: text/plain; charset=us-ascii




__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

NIIT Software Solutions 'eBillSpace' software Powers Electronic Bill Payment
for India's Department of Posts - the World's Largest Postal Network. For
details visit our website http://www.niit.com
___________________NOTICE____________________________
This electronic mail transmission contains confidential information intended
only for the person(s) named. Any use, distribution, copying or disclosure
by any other person is strictly prohibited. If you received this
transmission in error, please notify the sender by reply e-mail and then
destroy the message. Opinions, conclusions, and other information in this
message that do not relate to the official business of NIIT shall be
understood to be neither given nor endorsed by NIIT When addressed to NIIT
clients, any information contained in this e-mail is subject to the terms
and conditions in the governing client contract.
DB2 & UDB email list listserv db2-l LazyDBA home page