RE: display fetch data in strsql using stored procedure

Lugman,

No keyword in DB2 that I'm aware of, I'd bet there isn't one.

I'd guess you'd need to do it in RPG or some other HLL.  Since you'd need
I/O to a display file or the DSM APIs.

The Dynamic Screen Manager (DSM) APIs might be a better choice given that
the screens would be very dynamic.

Wouldn't necessarily need or want to call it from STRSQL.  You could just
call it from the command line.  The program would have to find out what
parms the stored procedure takes and what it outputs.  You may need APIs to
do this or you might be able to get the information from the SYSPROCS view.
Then you'd make the call and display the results.  Not really sure how.  Not
even sure RPG would be the language to do this in.  C might be a better
choice.

Obviously, it can be done.  But it might be more cost effective to just buy
Prodata's or someone else's product.

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: Wednesday, November 10, 2004 1:16 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Re: display fetch data in strsql using stored procedure
> 
> 
> Any idea how can I make it myself ? Do I have to use APIs or 
> any print 
> command?
> 
> In Sql Server, we just use PRINT in stored procedure for 
> testing, while in 
> Oracle, we use DBMS_OUTPUT.PUTLINE, so there must be some 
> keyword in DB2.
> 
> Best Regards,
> 
> Luqman
> 
> <CWilt@xxxxxxxxxxxx> wrote in message 
> news:FA8EB8B613601846A4E8D1A3AA144F8E072ACC@xxxxxxxxxxxxxxxxxxxxxxx
> > 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.
> >>
> > --
> > 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.
>