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

Introduction to RDB Access

Page 13

Using the RDB package

1. Write an Interactive Voice Response (IVR) application using MPS Devel-

oper.

2. Include SQL blocks in the IVR application.

a. Type SQL commands into the block or use MPS SQL.

b. Specify native, SQL Client, or CORBA Client connections in each

block.

3. When you run the IVR application, each SQL block formulates SQL

commands.

4. If the application uses a client connection, the SQL commands are sent to

either the SQL Client or CORBA Client. (This step is omitted if the appli-

cation uses a native connection.)

5. The SQL commands are sent to a program/library that is part of MPS

RDB.

6. The RDB program/library forwards the SQL commands to the RDBMS

Client.

7. If the application uses native or SQL Client connections, the RDBMS Cli-

ent sends the SQL commands to the RDBMS database. If the application

uses CORBA Client connections, the RDBMS Client sends the SQL com-

mands to the CORBA Server.

8. The results from the RDBMS Database (or CORBA Server) are sent back

to the IVR application in reverse order.

Supported RDBM Systems

The following tables show supported connection types for third-party relational

database systems.

Connection

type

Oracle Sybase Informix MS SQL DB2

Native Oracle 8i (1), 9i,

10g (2)

Sybase 10.x,

11.x, 12.1

IDS

7.31,

9.21,

9.30,

9.40

DB2 7.x,

8.1

ODBC

Connect ODBC

4.2. For MS SQL

Server 7.0,

2000, use

Connect 5.0

1 2 ... 8 9 10 11 12 13 14 15 16 17 18 ... 59 60

Comentarios a estos manuales

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 13

Comentarios a estos manuales

Relacionado con productos y manuales para Software de base de Avaya Business Communications Manager - PeriRDB