Embeded SQL Query - Possible to make it in RPGLE.

Hi,

I am sorry if I am asking at wrong place.

I am presently having list of queries (around 40) in word document, every
time before I run each query I will changing the output file (by Shift F1)
and run the query.  Actually each and every query is been formatted with the
previous query output.  I wish to put this into a program and executing as a
set (I hope it is what is stored procedure is all about)  I am not too sure,
how should I start with I know RPG programming. So, I am trying to implement
with SQLRPGLE, My basic doubts are

1. What should I use CURSOR,  VIEW,  STORED PROCEDURE or anything else?
2. Am I need to put that on a source member or a database file?

At one point of the query list I am appending (*add)  rows and at rest of
the time I am just replacing (*replace) the records.

What will be best approach to it?


Thanks and Regards,
Sriram Srinivasan 
IMPORTANT NOTICE: 

The information in this email (and any attachments) is confidential. 
If you are not the intended recipient, you must not use or disseminate the
information.
If you have received this email in error, please immediately notify me by
"Reply" command 
and permanently delete the original and any copies or printouts thereof. 
Although this email and any attachments are believed to be free of any virus
or 
other defect that might affect any computer system into which it is received
and opened, 
it is the responsibility of the recipient to ensure that it is virus free
and no responsibility 
is accepted by American International Group, Inc. or its subsidiaries or
affiliates either 
jointly or severally, for any loss or damage arising in any way from its
use.