Stored Procedures

Topics:

Procedures are reusable components of application logic, usually written in the native 4GL language of the server. Procedures may also be written in compiled and linked 3GL languages, such as C, COBOL, Fortran, Assembler, RPG, and others, and then can be called from the native 4GL language of the server.

This chapter discusses use of the native 4GL language of the server for stored procedures. The Stored Procedure Reference manual discusses the creation of procedures using 3GL languages.

Procedures are available from the navigation pane of Application page. You can:

  • Create and edit stored procedures.
  • Run procedures at the present time, at a later time, or under stress conditions (Web Console only).
  • Run a variety of reports that monitor many aspects of procedure performance.

iWay Software