RE: What is inside a stored SQL procedure

You should be able to.  However, after a certain level of statement 
complexity the prompting available with STRSQL drops down to the rest of 
the tools.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"heba refaie" <heba_refaie@xxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
07/07/2003 09:06 AM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     rpg400-l@xxxxxxxxxxxx
        cc: 
        Fax to: 
        Subject:        RE: What is inside a stored SQL procedure


Thank you very much Jerry, this procedure is coming from a third 
party...some one has sent it to me in a text file after I found that it 
opens files that are in a user library (with no override) he told me how 
to 
create it from the navigator...but I tried it your way and I could find 
what 
is inside it. it would be great if we would be able to describe it from 
StrSQL too...Just curious is it possible to create, desc, alter and drop 
proc from the green screen SQL.

Regards
Heba


>From: "Jerry Myrick" <myrickjr@xxxxxxxxxxxxx>
>Reply-To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
>Subject: RE: What is inside a stored SQL procedure
>Date: Mon, 7 Jul 2003 07:45:51 -0500
>
>Heba,
>
>Is this stored procedure created in-house or is it provided by IBM or
>another vendor? If the stored procedure was created in-house, you should
>have source physical file that contains a member with the source code.
>If you can't find the source, the source of a stored procedure is stored
>in the system table SYSPROCS at the time it is created. Take a look at
>the DB2 SQL Reference manual for the column names.
>
>Hope this helps.
>
>Jay
>
>-----Original Message-----
>From: rpg400-l-bounces@xxxxxxxxxxxx
>[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of heba refaie
>Sent: Sunday, July 06, 2003 3:10 AM
>To: RPG400-L@xxxxxxxxxxxx
>Subject: What is inside a stored SQL procedure
>
>Hi Group,
>
>Happy 4th July
>I have an RPGLE program using CLI SQL...it calls inside a SQL procedure
>and
>seems that it dose not select correctly...I am very new to this
>thing...is
>it possible to find out what is inside the SQL procedure...How?
>
>Thanks in advance
>Heba
>
>_________________________________________________________________
>Add photos to your messages with MSN 8. Get 2 months FREE*.
>http://join.msn.com/?page=features/featuredemail
>
>_______________________________________________
>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.
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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