RE: Stored Procedures

Use RUNSQLSTM for CL programs to execute stored procedure.

Thanks/regards

Neeraj Sarougi
Lead Analyst
CGI c/o COTT
Mumbai, India

neeraj.sarougi@xxxxxxx



C: 91-9819583500
T: (022) 28291421 x261
F: (022) 28291818
Link: 978-946-3400 x8827/x8828


CONFIDENTIALITY NOTICE: Proprietary/Confidential Information belonging
to CGI Group Inc. and its affiliates may be contained in this message.
If you are not a recipient indicated or intended in this message (or
responsible for delivery of this message to such person), or you think
for any reason that this message may have been addressed to you in
error, you may not use or copy or deliver this message to anyone else.
In such case, you should destroy this message and are asked to notify
the sender by reply mail.




-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
THarteau@xxxxxxxxxxxxxxxxxx
Sent: Thursday, October 11, 2007 6:13 PM
To: RPG programming on the AS400 / iSeries
Subject: Stored Procedures

Hi,
Last week at the RPG/DB2 Summit, someone mentioned there was a
way
to run the SQL CREATE PROCEDURE command from a CL or something. I have
a
quite lengthy command I type in using STRSQL when I need to make a
change.
Is there a way to put this in some kind of member and just execute it?
I
am a little nervous whenever I have to re-enter this monster. Thanks!
<===================================================>

Terri Harteau
Felker Brothers Corporation
****************
"The danger in life is not that we aim too high and miss.
The problem is that we aim too low and hit the mark." -- Michelangelo
****************