RE: display fetch data in strsql using stored procedure

Prodata (www.prodatacomputer.com) has a new product called STE, Stored
Procedure Test Environment.  That will show you results sets and output
parms from an SQL stored procedure on a green screen.

You could of course also roll-your-own.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: Luqman [mailto:pearlsoft@xxxxxxxxxxxx]
> Sent: Tuesday, November 09, 2004 3:18 PM
> To: rpg400-l@xxxxxxxxxxxx
> 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
> @dekko-1...
> > 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.
>