Avaya Business Communications Manager - PeriRDB Bedienungsanleitung PDF herunterladen (Seite 25)

PeriSQL

Page 25

Using PeriSQL to Query an RDBMS

Perform the following steps to create an SQL SELECT command and query the

RDBMS. See the appropriate section for details about each step. For information

about accessing PeriSQL, see page 17.

How to ...Use PeriSQL to Query an RDBMS

1.From the Users/Databases list, select a user account name. PeriSQL displays a

list of all tables owned by that user. See page 21.

2.From the list of tables, select the table name(s). You can display from one to four

tables at a time. PeriSQL displays each table’s columns and attributes. See page

22.

3.From each table’s columns list, select the column(s) you want to include in the

SQL command. You can select multiple columns from one or more displayed

tables. See page 23.

4.Select Construct SQL. PeriSQL writes the SQL command text to the SQL scrolling

list box. You can customize the SQL command. See page 25.

5.Select Execute SQL. PeriSQL performs the current query and displays the first

retrieved record (if any) in the Fetched Records list. See page 27.

To display other records from the query, either enter the record number in the Rec

field or use the up and down arrows to scroll to the desired number.

Creating and Customizing the SQL Command in PeriSQL

To create an SQL command, you must select at least three pieces of information from

the scrolling lists:

• a user/database name (see PeriSQL User Accounts on page 21)

•a table name (see PeriSQL Tables on page 22)

• a table column (see PeriSQL Columns on page 23)

You can select columns from more than one table. See Selecting Multiple Columns

(Join) on page 26.

Select Construct SQL to build an SQL command based on the highlighted scrolling

list entries. PeriSQL inserts the SQL keywords required to specify the query criteria.

PeriSQL places the SQL command text in the SQL scrolling list.

user

table

column

SQL command

1 2 ... 20 21 22 23 24 25 26 27 28 29 30 ... 59 60

Keine Kommentare

Avaya Business Communications Manager - PeriRDB Bedienungsanleitung Seite 25