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

PeriSQL

Page 33

Supplying Arguments to Functions and Procedures

You can display the template for a Procedure or Function to determine the required

arguments and types. You must specify data cards or constants for required arguments

in the object declaration. You can edit a Procedure or Function in either PeriSQL’s

SQL window and/or PeriPro’s SQL block (after selecting the Write to PeriPro menu

in PeriSQL).

• IN designates an argument passed from the application to the RDBMS

• OUT designates an argument returned to the application

• IN/OUT designates an argument that both passes data to the RDBMS and returns

data to the application

For example, the following implementation of the Procedure GET_STAR_EMP

requires a floating point number as input and returns character strings:

All Functions return a value. You must always specify a character data card to receive

the return value.

Three required

arguments

Input to the

Procedure

Output from

the Procedure

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 33