Re: display fetch data in strsql using stored procedure

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.