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.

How to get the result set's datatypes of a stored procedure

2 posts in General Discussion Last posting was on 2011-07-05 07:15:24.0Z
qkc Posted on 2011-07-05 00:30:37.0Z
Sender: 4c1d.4e125931.1804289383@sybase.com
From: qkc
Newsgroups: sybase.public.ase.general
Subject: How to get the result set's datatypes of a stored procedure
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e125b2d.4c9b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Jul 2011 17:30:37 -0700
X-Trace: forums-1-dub 1309825837 10.22.241.41 (4 Jul 2011 17:30:37 -0700)
X-Original-Trace: 4 Jul 2011 17:30:37 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30311
Article PK: 72489

How to get the result set's datatypes of a stored procedure
I want get all the result set's data type of all the stored
procedures in a database.
What is the right way?

I don't know if ASE15.0.2 has any tools to create a table
using the result set of a stored procedure? (like SQL Any
Where). e.g
select * into dbo.NewTable
from dbo.MyProcedure( )


Rob V [ Sybase ] Posted on 2011-07-05 07:15:24.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: How to get the result set's datatypes of a stored procedure
References: <4e125b2d.4c9b.1681692777@sybase.com>
In-Reply-To: <4e125b2d.4c9b.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: <4e12ba0c$1@forums-1-dub>
Date: 5 Jul 2011 00:15:24 -0700
X-Trace: forums-1-dub 1309850124 10.22.241.152 (5 Jul 2011 00:15:24 -0700)
X-Original-Trace: 5 Jul 2011 00:15:24 -0700, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30313
Article PK: 72492


On 05-Jul-2011 02:30, qkc wrote:
> How to get the result set's datatypes of a stored procedure
> I want get all the result set's data type of all the stored
> procedures in a database.
> What is the right way?
>
> I don't know if ASE15.0.2 has any tools to create a table
> using the result set of a stored procedure? (like SQL Any
> Where). e.g
> select * into dbo.NewTable
> from dbo.MyProcedure( )

Sybase ASE does not have the same feature as SQL Anywhere to create a
table based on a stored proc's result set.
A workaround, with various limitations, is described at
www.sypron.nl/proctab.

As for determining the result types: there is no way to do this
programmatically in SQL. You will have to inspect the SQL code by the
stored proc and figure out the data types.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------