Re: display fetch data in strsql using stored procedure

I mostly work on AS/400 through VPN Connection at my home and Iseries 
navigator is damn very slow, so I prefer to work on Green Screens, being its 
response very fast.

Best Regards,

Luqmna





<rob@xxxxxxxxx> wrote in message 
news:OFFE5DB13A.5C9E2C4C-ON05256F47.006CD777-05256F47.006CF29E@xxxxxxxxxx
> Instead of using STRSQL, use iSeries Navigator's run sql scripts function
> to call the stored procedure.  Just used that yesterday to test a stored
> procedure and view the result sets.
>
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Luqman" <pearlsoft@xxxxxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 11/09/2004 01:30 PM
> Please respond to
> RPG programming on the AS400 / iSeries 
> <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> rpg400-l@xxxxxxxxxxxx
> cc
>
> Fax to
>
> Subject
> display fetch data in strsql using stored procedure
>
>
>
>
>
>
> How can I display Fetched Data in Stored Procedure.
>
> For example, I created a cursor C1 and fetched data into following
> variables.
>
> FETCH C1 INTO EMPLOYEE_SALARY, EMPLOYEE_BONUS;
>
> Now, how can I display this data using STRSQL.
>
> In Oracle, we use following:-
>
> DBMS_OUTPUT.PUTLINE EMPLOYEE_SALARY;
>
>
> Best Regards,
>
> Luqman
>
>
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>