Avaya Business Communications Manager - PeriRDB Manual de usuario descargar pdf (Pagina 31)

PeriSQL

Page 31

Implementing Procedures and Functions

To implement a Procedure or Function in an application, you must include the object’s

declaration in an SQL block in the application and supply variables for any required

arguments.

PeriSQL includes Triggers for display only. You cannot use PeriSQL to add a Trigger

to an application.

Writing Procedures and Functions to an Application

You can use PeriSQL and an Objects Browser to write Procedures and Functions

directly to an SQL application.

How to ...Write Procedures and Functions to an Application

1. In the SQL block, select PROCEDURE.

2. In the PeriSQL Objects Browser, click <

SELECT> on the desired Procedure or

Function.

3. Click <

MENU> on the selected object to open the Construct SQL menu. Select

Procedure Call (or Function Call if object is a Function) and PeriSQL copies the

object declaration to the PeriSQL window.

If text is selected (highlighted) in a source code window, choosing Selected Text

from the Construct SQL menu copies the text to the PeriSQL window.

Indicates the block will execute

a Procedure or Function

1 2 ... 26 27 28 29 30 31 32 33 34 35 36 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 31