RE: What is inside a stored SQL procedure

["heba refaie" <heba_refaie@xxxxxxxxxxx>]

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