Re: [sqr-users] Executing a Sybase stored procedure fromdisplaying results

["Richard C Spoth" <Spoth.Richard@healthnow.org>]

Use the excute..INTO function.

execute  SPyourStoreProcedure 

        INTO
        &First          int
        , &Second       int
        , &Third        char(3)
 
Rick





"Nehal H. Patel" <nehal_h_patel@yahoo.com>
Sent by: sqr-users-bounces+spoth.richard=healthnow.org@sqrug.org
01/03/2005 09:15 AM
Please respond to "This list is for discussion about the SQR database 
reporting  language from Hyperion Solutions."

 
        To:     "This list is for discussion about the SQR database reporting 
language 
from Hyperion Solutions." <sqr-users@sqrug.org>
        cc: 
        Subject:        Re: [sqr-users] Executing a Sybase stored procedure 
from displaying 
results


Thanks for the reply Dattatraya,
The stored procedure is simple, it does not take any
prams.  The stored proc just queries a table and
returns the two fields in ASC order.  I'd like to
display this data.

I've never used a stored proc before, in the past i've
always used embedded SQL in the SQR.

Thanks.
-Nehal.

--- Dattatraya Shetty <datta_shetty@yahoo.com> wrote:

> Hi Neha,
>     What results would you like to Display ? Is it
> output of the Stored
> Procedure or else are you going to save the results
> into a Temp Table
> and want to display that ? 
> 
> Please give more details.
> Datta. 
> 
> --- "Nehal H. Patel" <nehal_h_patel@yahoo.com>
> wrote:
> 
> > Hello,
> > I have a stored proc that accepts one parameter
> and
> > I'd like to display the results.
> > 
> > Does anyone know how and have an example?
> > 
> > Thanks.
> > 
> > 
> > 
> > __________________________________ 
> > Do you Yahoo!? 
> > Yahoo! Mail - now with 250MB free storage. Learn
> more.
> > http://info.mail.yahoo.com/mail_250
> > 
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> 
> 
> 
> 
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Mail - Find what you need with new enhanced
> search.
> http://info.mail.yahoo.com/mail_250
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 



 
__________________________________ 
Do you Yahoo!? 
Dress up your holiday email, Hollywood style. Learn more. 
http://celebrity.mail.yahoo.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users





CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole 
use of the intended recipient(s) and may contain proprietary, confidential, 
trade secret or privileged information.  Any unauthorized review, use, 
disclosure or distribution is prohibited and may be a violation of law.  If you 
are not the intended recipient or a person responsible for delivering this 
message to an intended recipient, please contact the sender by reply email and 
destroy all copies of the original
message.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users