Stored procedures, The client, Adaptive server editions – Sybase 15.0.2 User Manual

Page 19

Advertising
background image

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

N

e

tw

or

k i

n

te

rf

a

ce

Response

Request

RPC

Data

Procedure

sql compiler

SQL executive

cache

Transaction

Indexes

Data tables

System

procedures

cache

Shared memory

log

Access Manager

Advertising