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.

Generate DDL: filename and hierarchy

2 posts in General Discussion Last posting was on 2009-04-01 09:04:43.0Z
Lane Posted on 2009-03-31 19:06:39.0Z
Sender: 53d6.49d2655b.1804289383@sybase.com
From: Lane
Newsgroups: sybase.public.workspace.general
Subject: Generate DDL: filename and hierarchy
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49d269bf.5429.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Mar 2009 11:06:39 -0800
X-Trace: forums-1-dub 1238526399 10.22.241.41 (31 Mar 2009 11:06:39 -0800)
X-Original-Trace: 31 Mar 2009 11:06:39 -0800, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:834
Article PK: 1088525

1. How do I change the format of the default filename for a
stored procedure in the Generate DDL window? Currently the
filename has the format:
Procedure_<servername>_<database>_<procedureName>_ddl.sql
I want the default to be
<procedureName>.sql
Right now, I have to change the name of every procedure
before
I save the file.

2. How do I chnage the default hierarchy when saving the
file?
Currently, the hierarchy directory structure is
<location>\Database\Schemas\dbo\<objectType>\<objectName>.sql
I want the default hieracrchy to be
<location>\<objectType>\<objectName>.sql
I realize I can manually navigate to the exact location for
each object one at a time, but I would like to change the
default that is used when "Generate full hierarchy" is
checked.

Thanks


Li huang [Sybase] Posted on 2009-04-01 09:04:43.0Z
From: "Li huang [Sybase]" <lihuang@sybase.com>
Reply-To: lihuang@sybase.com
Organization: Sybase Software Co., Ltd
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: Generate DDL: filename and hierarchy
References: <49d269bf.5429.1681692777@sybase.com>
In-Reply-To: <49d269bf.5429.1681692777@sybase.com>
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: <49d32e2b$1@forums-1-dub>
Date: 1 Apr 2009 01:04:43 -0800
X-Trace: forums-1-dub 1238576683 10.22.241.152 (1 Apr 2009 01:04:43 -0800)
X-Original-Trace: 1 Apr 2009 01:04:43 -0800, vip152.sybase.com
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:835
Article PK: 1088524

Hi, Lane:

Currently, you need to change it every time when you invoke Generate DDL wizard.
In the next release, we will consider to add preference options to customize filename and hierarchy.

Thank you for your suggestion!

Lane wrote:
> 1. How do I change the format of the default filename for a
> stored procedure in the Generate DDL window? Currently the
> filename has the format:
> Procedure_<servername>_<database>_<procedureName>_ddl.sql
> I want the default to be
> <procedureName>.sql
> Right now, I have to change the name of every procedure
> before
> I save the file.
>
> 2. How do I chnage the default hierarchy when saving the
> file?
> Currently, the hierarchy directory structure is
> <location>\Database\Schemas\dbo\<objectType>\<objectName>.sql
> I want the default hieracrchy to be
> <location>\<objectType>\<objectName>.sql
> I realize I can manually navigate to the exact location for
> each object one at a time, but I would like to change the
> default that is used when "Generate full hierarchy" is
> checked.
>
> Thanks

--
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