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

PeriSQL

Page 27

Performing a Query With PeriSQL

To query the database using the SQL command in the SQL scrolling list, select

Execute SQL.

Execute SQL performs the following:

1. PeriSQL sends the SQL statement to the SQL server.

2. The SQL server prepares and parses the statement, and opens all database

resources required to execute the SQL statement.

If any records match the query, PeriSQL displays the first returned record in the

Fetched Records scrolling list.

Each line entry in the Fetched Records list represents a column from the SQL

SELECT list. PeriSQL can only display one record at a time.

RDBMS release

number

Currently displayed

record #

Number of

retrieved

records

Click to view

another record

or enter record

# directly into

Rec field

1 2 ... 22 23 24 25 26 27 28 29 30 31 32 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 27