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