niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
Hierarchical Queries
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
gfiuni2@gmail.com
*nix forums beginner


Joined: 28 Jun 2006
Posts: 2

PostPosted: Wed Jun 28, 2006 4:31 pm    Post subject: Hierarchical Queries Reply with quote
Hello,

Does Sybase 11.9 support hierarchical queries?

Thanks in advance,
Jose Luis.
Back to top
bret@sybase.com
*nix forums addict


Joined: 24 May 2005
Posts: 66

PostPosted: Wed Jun 28, 2006 5:12 pm    Post subject: Re: Hierarchical Queries Reply with quote
gfiuni2 wrote:
Quote:
Hello,

Does Sybase 11.9 support hierarchical queries?

Thanks in advance,
Jose Luis


There is no special built-in syntax for them.

Here is one method for doing them:
http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.7

See also Celko's book on the subject.
http://www.amazon.com/gp/product/1558609202/sr=8-2/qid=1151514720/ref=sr_1_2/104-0816178-1002364?ie=UTF8
Back to top
--CELKO--
*nix forums Guru Wannabe


Joined: 01 Jun 2005
Posts: 122

PostPosted: Thu Jun 29, 2006 1:45 pm    Post subject: Re: Hierarchical Queries Reply with quote
Quote:
Does Sybase 11.9 support hierarchical queries?

If you mean something likethe proprietary "hidden cursor" syntax in
Oracloe, no thank god.

Get a copy of TREES & HIERARCHIES IN SQL for several pure SQL ways to
model trees and hierarchies along with all the code you will need.
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Tue Dec 02, 2008 1:14 pm | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts sieve queries paul hendrick Exim 1 Thu Jul 20, 2006 9:27 am
No new posts Log actual params for prepared queries: TO-DO item? Ed L. PostgreSQL 2 Sat Jul 15, 2006 9:29 pm
No new posts Multiple subquery in update or two queries (PL/SQL) ? Martin T. Oracle 0 Wed Jul 12, 2006 12:01 pm
No new posts input type="image" Array queries Mark Woodward PHP 5 Mon Jul 10, 2006 11:12 am
No new posts Bug#377546: ITP: schedtools -- Queries/alters process's s... Thibaut VARENE devel 4 Sun Jul 09, 2006 10:00 pm

MySpace Layouts | Charity Gifts | Car Credit | Credit Cards | Loans
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1589s ][ Queries: 16 (0.0875s) ][ GZIP on - Debug on ]