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.
>
>