Topics:

• Working With Stored Procedures
• Creating a Stored Procedure
• Sending Stored Procedure Report Output to Server-Side Printers
• Editing a Stored Procedure
• Running a Stored Procedure
• Scheduling a Procedure
• Sending an E-mail Notification for a Procedure
• Procedure Run-Time Processing Essentials
• Platform-Specific Commands and Features
• Stress Testing a Procedure
• Running Impact Analysis Reports

Procedures are reusable components of application logic which can include reporting or extract syntax, and are usually written in the native 4GL language of the server (TABLE). The native language of the server also includes syntax for controlling the execution of events within the request, and is known as Dialogue Manager. Procedures that contain TABLE and Dialogue Manager commands are called FOCEXECs.

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 tools to create 4GL procedures plus an introduction to the general use of the Dialogue Manager language. The Stored Procedure Reference manual discusses the creation of procedures using 3GL languages.