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

PeriRDB User’s Guide

Page 36

Using PeriSQL With the SQL Block

You can launch PeriSQL from an SQL block action window to create, modify, and

execute SQL SELECT commands through a graphical interface. Use this feature to

create and test SELECT commands before you add them to the application.

For details about using PeriSQL, see Using PeriSQL to Query an RDBMS on page

25.

PeriSQL can write the constructed SQL command to any open SQL block window

that has SELECT as its DML type. The SQL block action window must be open.

You must access PeriSQL from PeriProducer to use this feature. For information about

accessing PeriSQL, see Accessing PeriSQL on page 17.

Writing the PeriSQL SELECT to an SQL Block

First, construct the SELECT statement in PeriSQL (see Using PeriSQL to Query an

RDBMS on page 25).

Next, in the PeriSQL window, click <M

ENU> on Write to PeriPro. From the pull

down menu, select the SQL block to write to. PeriSQL can write the SQL command

directly to any open SQL block that has SELECT as its DML type.

You can also use Write to PeriPro to write a Procedure or Function to an SQL block.

See Using Stored Procedures, Functions, and Triggers on page 28.

You may have to manually add database and user qualifiers into a SELECT block if

the database you used in PeriSQL differs from the one in SELECT block.

You can leave PeriSQL active for the entire current PeriProducer session. That is, you

can iconize PeriSQL, load applications, add or delete SQL blocks, etc. PeriSQL

dynamically updates the Write to PeriPro menu to reflect the current application.

Open

SELECT SQL

blocks

Open SQL blocks with a DML type

other than SELECT are unavailable

1 2 ... 31 32 33 34 35 36 37 38 39 40 41 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 36