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.

Data Value from stored procedure

2 posts in DataWindow Last posting was on 2009-05-18 15:26:15.0Z
mgsh.kmr Posted on 2009-05-18 11:07:50.0Z
From: mgsh.kmr@gmail.com
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Data Value from stored procedure
Date: Mon, 18 May 2009 04:07:50 -0700 (PDT)
Organization: http://groups.google.com
Lines: 6
Message-ID: <fbc962d8-78ea-457b-a218-c61bdffd68ee@u9g2000pre.googlegroups.com>
NNTP-Posting-Host: 125.22.246.139
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1242644870 9999 127.0.0.1 (18 May 2009 11:07:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 18 May 2009 11:07:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u9g2000pre.googlegroups.com; posting-host=125.22.246.139; posting-account=pGhH3woAAAAJPA43NB2QUEoJa6oIuSzw
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!postnews.google.com!u9g2000pre.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89319
Article PK: 418562

Hi,
how to map the data's which are returned from the stored
procedure in the data window using power builder


Thanks in advance..


Jason 'Bug' Fenter [TeamSybase] Posted on 2009-05-18 15:26:15.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Data Value from stored procedure
References: <fbc962d8-78ea-457b-a218-c61bdffd68ee@u9g2000pre.googlegroups.com>
In-Reply-To: <fbc962d8-78ea-457b-a218-c61bdffd68ee@u9g2000pre.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a116cac$1@forums-3-dub.sybase.com>
X-Original-Trace: 18 May 2009 07:11:56 -0700, vip152.sybase.com
Lines: 16
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 18 May 2009 08:22:59 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 May 2009 08:26:15 -0700
X-Trace: forums-1-dub 1242660375 10.22.108.75 (18 May 2009 08:26:15 -0700)
X-Original-Trace: 18 May 2009 08:26:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89321
Article PK: 418566

Create a new datawindow. When given the option to choose a data source,
you should be able to select "stored procedure". This should query the
procedure and create the columns automatically, but you can define the
result set manually if you wish. After that, just use it like you would
any other datawindow. dw_1.Retrieve() will execute the stored procedure
and the results will be returned as rows in the datawindow.

mgsh.kmr@gmail.com wrote:
> Hi,
> how to map the data's which are returned from the stored
> procedure in the data window using power builder
>
>
> Thanks in advance..