Re: display fetch data in strsql using stored procedure

[rob@xxxxxxxxx]

You could use the SQL CLI API's.  Look at the Redbook "Who knew you could 
do that with RPG..."  Never used these api's though.  They are targeted 
for those:
1 - want to look at result sets.  Generating them from imbedded sql is ok 
but not reading them
2 - Won't pay for the sql precompiler
3 - are sick of the limitations of the precompiler, of which many were 
fixed in v5r3.
4 - holy grail of platform independence.  But what's platform independent 
about api calls from rpg?
5 - Those who need to spend some quality time with someone from the 
opposite sex.

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 03:18 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Fax to

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



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