Topic
2 replies Latest Post - ‏2013-09-24T19:42:03Z by namal
namal
namal
10 Posts
ACCEPTED ANSWER

Pinned topic Stored Procedure

‏2013-09-24T15:06:54Z |

Hi,

There are some stored procedures in the iseries and want to find out how they have created.

if these are external stored procedures then how did parameter and other attribute use to create the stored proc.

(We have moved from one iseries to another and some application stored procs. are missing and we need to re-create them, I assume most of them are external stored procs. )

 

Thanks

  • krmilligan
    krmilligan
    446 Posts
    ACCEPTED ANSWER

    Re: Stored Procedure

    ‏2013-09-24T18:25:56Z  in response to namal

    I would use System i Navigator on the source system.  You would navigate to the Schemas folder within the Databases portion of the navigation tree and then choose the Procedures folder within the library/schema that houses the External Stored Procedure.  From that list, you can right-click and select the "Generate SQL" task.  That will provide the CREATE PROCEDURE statement for the external stored procedure.

    In the future, I'd suggest having the CREATE PROCEDURE statements be into a source file that can be managed by your change management process.