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

3 posts in General Discussion Last posting was on 2009-11-03 16:12:01.0Z
Alex Rodriguez Posted on 2009-10-26 19:17:42.0Z
Newsgroups: sybase.public.ase.general
Subject: select from SP
From: Alex Rodriguez <adr5@columbia.edu>
Organization: Your Organization
X-Newsreader: WinVN 0.99.12h (x86 32bit)
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ae5f5d6$1@forums-1-dub>
Date: 26 Oct 2009 11:17:42 -0800
X-Trace: forums-1-dub 1256584662 10.22.241.152 (26 Oct 2009 11:17:42 -0800)
X-Original-Trace: 26 Oct 2009 11:17:42 -0800, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28549
Article PK: 77792

Hi,
I'm using ASE 15.0.3. Is it possible to select from a stored procedure?
Some like

select *
from mysp

TIA
------------
Alex


Michael Peppler [Team Sybase] Posted on 2009-10-26 20:58:48.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: select from SP
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2009.10.26.20.58.48.586715@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4ae5f5d6$1@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 26 Oct 2009 12:58:48 -0800
X-Trace: forums-1-dub 1256590728 10.22.241.152 (26 Oct 2009 12:58:48 -0800)
X-Original-Trace: 26 Oct 2009 12:58:48 -0800, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28550
Article PK: 77791


On Mon, 26 Oct 2009 11:17:42 -0800, Alex Rodriguez wrote:

> Hi,
> I'm using ASE 15.0.3. Is it possible to select from a stored procedure?
> Some like
>
> select *
> from mysp

Not directly.

You can create a proxy table that maps to your stored proc via an RPC call.

Something like

create existing table mysp_table (... columns ....)
external procedure at "loopback...mysp"

where "loopback" is a logical server name that points back at the local
ASE server. There are a number of details that need to be set up correctly
for this to work - I suggest you read the documentation on CIS (Component
Integration Services) as well as the "create existing table" manual page.

Michael


Rob V [ Sybase ] Posted on 2009-11-03 16:12:01.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <4ae5f5d6$1@forums-1-dub>
Subject: Re: select from SP
Lines: 37
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af05651@forums-1-dub>
Date: 3 Nov 2009 08:12:01 -0800
X-Trace: forums-1-dub 1257264721 10.22.241.152 (3 Nov 2009 08:12:01 -0800)
X-Original-Trace: 3 Nov 2009 08:12:01 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28581
Article PK: 77823

See www.sypron.nl/proctab

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"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"Alex Rodriguez" <adr5@columbia.edu> wrote in message
news:4ae5f5d6$1@forums-1-dub...
> Hi,
> I'm using ASE 15.0.3. Is it possible to select from a stored procedure?
> Some like
>
> select *
> from mysp
>
> TIA
> ------------
> Alex
>