Re: Stored Procedure with Embedded SQL

[DLee@xxxxxxxx]

Morning Craig


Any idea where I can find the C# program mentioned on page 12 of this 
article?

I got the stored procedure created and run okay.  Very cool, very easy.

<This link is a PDF file that shows how you can create an SQL Stored 
Procedure, using the iSeries Navigator, in minutes. You can develop and 
test 
the stored procedure, then link it to your client program (the C# 
program).

http://www.web400.com/pdf/Mod4_CS2008_StoredProc_NET.pdf

Your RPG program is really complicated, for what is essentially an SQL 
statement with a parameter. The SQL Stored Procedure is designed for the 
type of requirement that you're facing.

At least work through the iSeries Navigator example, you'll then be in a 
better position to understand what you're trying to do.>

Darrell Lee
Information Technology
Extension 17127