Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

extracting stored procs in dependency order

2 posts in General Discussion Last posting was on 2009-03-13 09:12:40.0Z
Gareth Davies Posted on 2009-03-11 16:27:37.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: extracting stored procs in dependency order
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b7e679@forums-1-dub>
Date: 11 Mar 2009 08:27:37 -0800
X-Trace: forums-1-dub 1236788857 10.22.241.152 (11 Mar 2009 08:27:37 -0800)
X-Original-Trace: 11 Mar 2009 08:27:37 -0800, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:815
Article PK: 1088490

Is there a way to extract stored procs so that when the script is run
they build in the right order?

The extract DDL option in WS2.1 doesn't seem to use the information in
the sysdepends table (and neither does the 'reverse engineer' function
in Power Designer 10).

Any advice appreciated, thanks.

Gareth


Li huang [Sybase] Posted on 2009-03-13 09:12:40.0Z
From: "Li huang [Sybase]" <lihuang@sybase.com>
Reply-To: lihuang@sybase.com
Organization: Sybase Software Co., Ltd
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: extracting stored procs in dependency order
References: <49b7e679@forums-1-dub>
In-Reply-To: <49b7e679@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49ba2388$1@forums-1-dub>
Date: 13 Mar 2009 01:12:40 -0800
X-Trace: forums-1-dub 1236935560 10.22.241.152 (13 Mar 2009 01:12:40 -0800)
X-Original-Trace: 13 Mar 2009 01:12:40 -0800, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:816
Article PK: 1088515

Hi, Gareth:

Thanks for your suggestion!

We will consider to support dependency feature in the future release.

Gareth Davies wrote:
> Is there a way to extract stored procs so that when the script is run
> they build in the right order?
>
> The extract DDL option in WS2.1 doesn't seem to use the information in
> the sysdepends table (and neither does the 'reverse engineer' function
> in Power Designer 10).
>
> Any advice appreciated, thanks.
>
> Gareth

--
Thanks and regards,

Daniel(Li) Huang [Sybase]

Sybase
Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Tel 8621-38657420
Email: lihuang@sybase.com