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

PeriRDB User’s Guide

Page 20

PeriSQL Display

PeriSQL runs in its own window. The display changes dynamically, displaying and

labeling scrolling lists based on your selections. The following items appear in every

PeriSQL window (Inquiry window):

Standard PeriSQL window items

Peri logo

Clicking the Periphonics logo in the heading of the PeriSQL

Inquiry window, displays an "About" window containing PeriSQL

Write to PeriPro

1. Write to PeriPro is only enabled if you access PeriSQL from PeriProducer.

Copies the current SQL command statement to the selected

SQL block.

PeriSQL can write the SQL command to any open SQL block

window that has SELECT as its DML type. For additional

information, see Using PeriSQL With the SQL Block on page 36.

Objects Signals PeriSQL to display any predefined Procedures,

Functions or Triggers when you select a user/database. For

additional information, see Using Stored Procedures, Functions,

and Triggers on page 28.

Users

/Databases

2.Oracle

3.Sybase

Displays information about the RDBMS server user

accounts/databases that have been defined.

When you click a user account/database name, PeriSQL

displays the names of all tables owned by that user/account. See

PeriSQL User Accounts on page 21.

Fetched (#) Records Displays the record(s) retrieved from a successful query. # is the

number of records that satisfied the query.

An entry in the scrolling list corresponds to a column from the

SQL SELECT list, for the currently displayed record.

Rec The current record number.

PeriSQL displays only one record at a time. Use this field to

display a specific record from the returned record set.

SQL Displays the SQL command.

Construct SQL Creates the SQL SELECT command based on the selected

columns and tables, and displays it in the SQL scrolling list box.

Execute SQL Executes the current SQL SELECT command. Select Execute

SQL to perform the query on the database.

1 2 ... 15 16 17 18 19 20 21 22 23 24 25 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 20