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

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
    450 Posts
    ACCEPTED ANSWER

    Re: Stored Procedure

    ‏2013-09-24T18:25:56Z  

    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.

  • krmilligan
    krmilligan
    450 Posts

    Re: Stored Procedure

    ‏2013-09-24T18:25:56Z  

    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.

  • namal
    namal
    10 Posts

    Re: Stored Procedure

    ‏2013-09-24T19:42:03Z  

    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.

    Thanks a lot for the reply.