A SERVICE OF

logo

Open as PDF
next previous
CHAPTER 1 Overview
Installation Guide Evaluation Version 5
Stored procedures
Stored procedures encapsulate a series of SQL commands that the server can
execute as a single command. System stored procedures (SSPs) are created
when the server is installed.
The client
A client uses functions provided by the CT-Library (CT-Lib) and Common
Library (CS-Lib) APIs to establish a connection to the server, submit requests
to the server, and receive results back from the server.
Figure 1-1: Adaptive Server system model
Adaptive Server editions
Adaptive Server is available in the following editions:
• Enterprise Edition – has no limit on scalability and can run all available
options that can be purchased separately.
Application code
Open Client
Network interface
Response
Request
RPC
Data
Procedure
sql compiler
SQL executive
cache
Transaction
Indexes
Data tables
System
procedures
cache
Shared memory
log
Access Manager