Lucent Technologies CentreVu Report Designer, User Manual

Page: 223 / 266

SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Introduction
18-1
18 SQL Query and CMS Database Table
Basics
Introduction
18
The Call Management System (CMS) is a relational database that is made of
a series of database tables. The tables are made up of rows of database
items and columns of data. CMS reports retrieve data from the database
tables and format the data into readable tables, charts, and fields.
Reports use Structured Query Language (SQL) queries to retrieve specific
data from the database tables. You can create and edit queries using the
Edit | Queries feature of the Report Designer. This chapter gives you
information about SQL queries, concentrating on the use of WHERE clauses.
For extensive information on SQL, please refer to your
INFORMIX
*
documentation.
The sections in this chapter are as follows:
●
SQL Query Basics
●
CMS Database Table Basics
●
Creating a Custom Data Table
●
Modifying a Table
*INFORMIX is a registered trademark of Informix Software, Inc.