Avaya Business Communications Manager - PeriRDB Bedienungsanleitung

Avaya Business Communications ManagerDocument Status: StandardDocument Number: P0602814Document Version: 1.92Date: June 2010PeriRDB User’s Guide 2.1

PeriRDB User’s GuidePage 10Solaris and Windows 2000 ConventionsThis manual depicts examples (command line syntax, configuration files, and screen shot

This chapter covers:Introduction to RDB Access1. Overview2. Using the RDB package3. Supported RDBM Systems

PeriRDB User’s GuidePage 12OverviewRelational Database Management Systems (RDBMS) Database access is enabled through the MPS Relational Database (RDB)

Introduction to RDB AccessPage 13Using the RDB package1. Write an Interactive Voice Response (IVR) application using MPS Devel-oper.2. Include SQL blo

PeriRDB User’s GuidePage 14 1. Oracle 8i is not supported by the vendor since December 2004.2. Access to Oracle 10g requires Oracle 9i client.Conn

This chapter covers:PeriSQL1. Automatically Generating SQL Commands (PeriSQL)2. Accessing PeriSQL3. PeriSQL Display4. Using PeriSQL to Query an RDBMS5

PeriRDB User’s GuidePage 16Automatically Generating SQL Commands (PeriSQL)The Periphonics SQL Generate and Display Tool (PeriSQL) allows you to create

PeriSQLPage 17Accessing PeriSQLYou can access PeriSQL as a stand-alone utility or through the PeriProducer SQL block.Setting the Environment Variables

PeriRDB User’s GuidePage 18To access Sybase, set the following Sybase-specific environment variables:For example:Accessing PeriSQL From the Command Li

PeriSQLPage 19Accessing PeriSQL From PeriProducerUse an SQL block to access PeriSQL from PeriProducer. From an SQL block action window, select PeriSQL

© 2010 Avaya Inc. All Rights Reserved.Notices While reasonable efforts have been made to ensure that the information in this document is complete and

PeriRDB User’s GuidePage 20PeriSQL DisplayPeriSQL runs in its own window. The display changes dynamically, displaying and labeling scrolling lists bas

PeriSQLPage 21PeriSQL User AccountsAt startup, PeriSQL displays the user/database accounts scrolling list. This list contains the user accounts that a

PeriRDB User’s GuidePage 22PeriSQL TablesWhen you select a user account name, PeriSQL displays that user’s set of table names in a scrolling list belo

PeriSQLPage 23You can display tables for only one user at a time. When you click a different user name, PeriSQL:• removes the tables for the previous

PeriRDB User’s GuidePage 24Column CharacteristicsData Type and LengthEach column has at least two characteristics: its data type and its length.If the

PeriSQLPage 25Using PeriSQL to Query an RDBMSPerform the following steps to create an SQL SELECT command and query the RDBMS. See the appropriate sect

PeriRDB User’s GuidePage 26You can modify the SQL command manually within the SQL scrolling list. Position the cursor at the desired character and use

PeriSQLPage 27Performing a Query With PeriSQLTo query the database using the SQL command in the SQL scrolling list, select Execute SQL.Execute SQL per

PeriRDB User’s GuidePage 28Debugging the SQL Command in PeriSQLIf PeriSQL cannot successfully execute the SELECT command, it provides an error message

PeriSQLPage 29You cannot use PeriSQL to execute Procedures, Functions, or Triggers.You cannot use PeriSQL to define Procedures, Functions, or Triggers

Page 3Table of ContentsPreface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Scope .

PeriRDB User’s GuidePage 30In the Objects Browser window, the heading in the top sub-window indicates the User Name, the number of Procedures, Functio

PeriSQLPage 31Implementing Procedures and FunctionsTo implement a Procedure or Function in an application, you must include the object’s declaration i

PeriRDB User’s GuidePage 324. From the PeriSQL Write to PeriPro menu, select the SQL block to write to. PeriSQL copies the contents of the SQL window,

PeriSQLPage 33Supplying Arguments to Functions and ProceduresYou can display the template for a Procedure or Function to determine the required argume

PeriRDB User’s GuidePage 34Supplying Arguments in the SQL Block WindowAfter you transfer the object declaration to the application, you can either ent

PeriSQLPage 35Supplying Arguments in PeriSQLYou can manually enter the arguments in the object declaration before you write the declaration to the app

PeriRDB User’s GuidePage 36Using PeriSQL With the SQL BlockYou can launch PeriSQL from an SQL block action window to create, modify, and execute SQL S

This chapter covers:SQLClnt1. Accelerating RDBMS Access With SQLClnt 2. The Cryptutil utility3. Instructions to install Oracle Client 8.1.7 on an IBM

PeriRDB User’s GuidePage 38Accelerating RDBMS Access With SQLClnt You can accelerate RDBMS requests by coding the application to use a dedicated SQL c

SQLClntPage 39The following is an example of how to start an SQLClnt:sqlclnt -v 254 -s 230 -m oracle -q MYoracle -cTo use the previous SQLClnt, the qu

PeriRDB User’s GuidePage 4Timing, Measuring, and Logging RDBMS Server Performance . . . 40Cryptutil Utility . . . . . . . . . . . . . . . . . . . . .

PeriRDB User’s GuidePage 40secondary server goes down. If you want to use an encrypted connect string, use option –b. Encrypt the connect string by us

SQLClntPage 41Using the Encrypted Connect String with SQLClntNew command line options have been added to the SQLClnt, namely U and B.• U—This option i

PeriRDB User’s GuidePage 42Using Option UAn example of using the SQLClnt with option U is given below:"sqlclnt -v 2 -s 221 -m oracle -U uiYLCVuOU

SQLClntPage 43Accessing Databases using SQLClnt on an Intermediate NodeSQLClnt usually runs on the same node as the IVR application. You can also run

PeriRDB User’s GuidePage 44SQLClnt on an Intermediate NodeThe following diagram shows SQLClnt on an intermediate node but related processes on the sam

SQLClntPage 45SQLClnt and vmst on an Intermediate NodeThe following diagram shows SQLClnt and vmst on an intermediate node with periq on the same node

PeriRDB User’s GuidePage 46SQLClnt and periq on an Intermediate NodeSQLClnt and periq on an intermediate node with vmst on the same node as the IVR ap

SQLClntPage 47This page has been intentionally left blank.

This chapter covers:CORBAClnt1. Working with CORBA Server Objects2. CORBAClnt3. The CORBA Block

CORBAClntPage 49Working with CORBA Server ObjectsPeriRDB version 1.2 supports integration with CORBA (Common Object Request Broker Architecture). The

Preface

PeriRDB User’s GuidePage 50corbaclnt Usage Menu The following options are available for CORBAClnt:Installation/Startup of corbaclnt on SolarisTo inter

CORBAClntPage 51Reported Issues!corbaclnt is blocked on a request to the CORBA server, and if the server does not respond, due to a network, server cr

PeriRDB User’s GuidePage 52The CORBA BlockThe information that an application developer enters in the CORBA Block is used to build and send a request

CORBAClntPage 53Invoking Operations With the CORBA BlockThe operation to invoke is entered in free format. A folder or datacard can be specified to re

PeriRDB User’s GuidePage 54• PeriPro creates the vagorb and corba folders in the Global Data Folders window for use during its interaction with corbac

CORBAClntPage 55Specifying Return ExceptionsThe following table shows the exceptions available with the CORBA block:Condition nameCORBA Block exceptio

This chapter covers:PeriRDB Libraries1. The PeriRDB and SQLClnt Libraries

PeriRDB LibrariesPage 57PeriRDB LibrariesThe following tables list each database with its associated library. The PeriRDB libraries are located in $RD

Index

IndexPage 59Symbols# 54AAbout window 20AMU command 51any 55Bbadoperation 56badparameter 56boolean 55Cchar 55comfail 56commandsAMU 51sqlclnt 39, 40veng

PeriRDB User’s GuidePage 6ScopeThe PeriRDB User’s Guide provides a feature description and reference for PeriSQL and SQLClnt software functions as wel

PeriRDB User’s GuidePage 60orberr 56out 54PPeri logo 20periq 38PeriRDB Libraries 58PeriSQL 16–36accessing 18columns 23creating an SQL command 25debugg

PrefacePage 7How to Use This ManualThis manual uses many standard terms relating to computer system and software application functions. However, it co

PeriRDB User’s GuidePage 8Conventions Used in This ManualThis manual uses different fonts and symbols to differentiate between document elements and t

PrefacePage 9The flying Window icon identifies procedures or events that apply to the Windows 2000 operating system only.1The Solaris icon identifies