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.

Select * expansion in stored procs

3 posts in General Discussion Last posting was on 2007-11-07 17:25:35.0Z
Gareth Davies Posted on 2007-11-02 13:00:15.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Select * expansion in stored procs
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
X-Original-NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
Message-ID: <472b1f5f@forums-1-dub>
Date: 2 Nov 2007 05:00:15 -0800
X-Trace: forums-1-dub 1194008415 87.194.125.184 (2 Nov 2007 05:00:15 -0800)
X-Original-Trace: 2 Nov 2007 05:00:15 -0800, 87-194-125-184.bethere.co.uk
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:518
Article PK: 1088202

Is there a way to turn off the automatic column expansion of SELECT *
statements inside stored procuredures when they save?

I cant find an option for this behaviour and it's causing lots of errors
working with temporary tables (where the column definitions are in flux
during development).

Thanks

BTW - in spite of my whingeing, I'm pretty impressed with Workspace so far.


Aryeh Silverberg <asilverberg Posted on 2007-11-06 05:13:56.0Z
From: Aryeh Silverberg <asilverberg@silverbergs_dot_com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070828)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: Select * expansion in stored procs
References: <472b1f5f@forums-1-dub>
In-Reply-To: <472b1f5f@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: user-38q4akk.cable.mindspring.com
X-Original-NNTP-Posting-Host: user-38q4akk.cable.mindspring.com
Message-ID: <472ff814$3@forums-1-dub>
Date: 5 Nov 2007 21:13:56 -0800
X-Trace: forums-1-dub 1194326036 209.162.42.148 (5 Nov 2007 21:13:56 -0800)
X-Original-Trace: 5 Nov 2007 21:13:56 -0800, user-38q4akk.cable.mindspring.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:521
Article PK: 1088205

Column Expansion is done by the ASE Server, and not be workspace.

Gareth Davies wrote:
> Is there a way to turn off the automatic column expansion of SELECT *
> statements inside stored procuredures when they save?
>
> I cant find an option for this behaviour and it's causing lots of errors
> working with temporary tables (where the column definitions are in flux
> during development).
>
> Thanks
>
> BTW - in spite of my whingeing, I'm pretty impressed with Workspace so far.


Gareth Davies Posted on 2007-11-07 17:25:35.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: Select * expansion in stored procs
References: <472b1f5f@forums-1-dub> <472ff814$3@forums-1-dub>
In-Reply-To: <472ff814$3@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
X-Original-NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
Message-ID: <4731f50f@forums-1-dub>
Date: 7 Nov 2007 09:25:35 -0800
X-Trace: forums-1-dub 1194456335 87.194.125.184 (7 Nov 2007 09:25:35 -0800)
X-Original-Trace: 7 Nov 2007 09:25:35 -0800, 87-194-125-184.bethere.co.uk
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:522
Article PK: 1088209

Ah, so it is. Thanks.

Aryeh Silverberg wrote:
> Column Expansion is done by the ASE Server, and not be workspace.
>
> Gareth Davies wrote:
>> Is there a way to turn off the automatic column expansion of SELECT *
>> statements inside stored procuredures when they save?
>>
>> I cant find an option for this behaviour and it's causing lots of
>> errors working with temporary tables (where the column definitions are
>> in flux during development).
>>
>> Thanks
>>
>> BTW - in spite of my whingeing, I'm pretty impressed with Workspace so
>> far.