Re: Cobol stored procedure

Thanks.  I did run it in Navigator.  Got much more info to look at.  I do get a result set of 0.
Still have no idea why I dn't get anything.  I have displays in the program for counts and SQLCODE and all is good.
 
Thanks Richard.

--- On Thu, 4/30/09, Richard Casey <casey_r@xxxxxxxxxxxxxxxx> wrote:


From: Richard Casey <casey_r@xxxxxxxxxxxxxxxx>
Subject: Re: [COBOL400-L] Cobol stored procedure
To: "'COBOL Programming on the iSeries/AS400'" <cobol400-l@xxxxxxxxxxxx>
Date: Thursday, April 30, 2009, 11:47 AM


Mike,

If you go to "Run SQL Scripts" in iSeries Navigator, you can run your CALL
statement from there and see the contents of the result set.

Holler if you have any questions.

Have fun!
Richard


-----Original Message-----
From: cobol400-l-bounces@xxxxxxxxxxxx
[mailto:cobol400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Apice
Sent: Wednesday, April 29, 2009 9:42 PM
To: cobol400-l@xxxxxxxxxxxx
Subject: [COBOL400-L] Cobol stored procedure

Not sure if this is the correct site for this but here goes.
 
I have a stored procedure created in as400 sql. 
 
It call a CLLE program which in turn calls 2 Cobol programs.
 
1st just does the query and writes to a file.
 
2nd reads  file into cursor.  Declare, open , return result set for client
 
I call the SP in STRSQL and it completes.  How can I actually see result set
data on 400.
 
Eventually, Jave JT400 will be calling this SP.
 
Thanks much.