AW: display fetch data in strsql using stored procedure

Hi Luqman,

if you want to display the result set,
you have to use the iSeries Navigator.
(Run SQL Scripts)

Birgitta




-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Luqman
Gesendet: Dienstag, 9. November 2004 20:03
An: rpg400-l@xxxxxxxxxxxx
Betreff: Re: display fetch data in strsql using stored procedure


My stored procedure is as under:-

create procedure mydate
dynamic result sets 1
language sql reads sql data
begin
declare c1 cursor with return for
select * from acc;
open c1;
end

When I call  mydate in STRSQL, the following message appeared.

 1 result sets are available from procedure MYDATE in *N.

Now, how can I view this result set to know whether results are ok or not.

Do I have to add further code in my above sql procedure for output purpose.

Best Regards,

Luqman




"Luqman" <pearlsoft@xxxxxxxxxxxx> wrote in
message news:cmr2g4$tre$1@xxxxxxxxxxxxxxxx
> 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.