The Client-Server Architecture

As every other Database platform this is also a Client Server Architecture.

Client – Program that receives requests from a user and sends them to the server; also receives responses from the server and displays them for a user

Server – Program that processes requests from the client and returns results to the client

ASE – History

This is commonly known as Sybase DB or Sybase ASE, is a Relational Database Model product by Sybase Corporation which became part of  SAP in July 2010.

ASE is a legacy software predominantly used on the Unix  platform, but is also available for Microsoft Windows.

Versions so far,

1992 : SQL Server 4.2

1993: Sybase SQL Server 10.0

1995: Sybase released SQL Server 11.0

1996: Sybase with version 11.5

1998: ASE 11.9.2

1999: ASE 12.0

2001: ASE 12.5

2005: Sybase released ASE 15.0

2010: Sybase release ASE 15.5

2011: Sybase released ASE 15.7 at Techwave

2014: SAP released ASE 16.

Adaptive Server

It is a Sybase server that manages multiple databases

Databases are divided as follows.Required Databases

Master

Model

Sybsystemprocs

Sybsystemdb

tempdb

Utility databases

sybsecurity

dbccdb

sybsyntax

pubs2

Application Databases.

Connection

For connecting to the server, you need

any of the ASE client

Valid Login name and password

The connection so created, is called as the session

When your login name is authenticated, you are connected to your default database

Default database is the database, where you are placed after a successful connection

It is specific to a login

The SA (System Administrator) assigns it to individual logins.

Isql – Connection to server

isql is a command line utility which acts as a client to Adaptive Server

isql can be invoked with the following options (most commonly used)

-U login name

-S server name

-P password

-w width of display

-c line terminator

e.g:  $isql –Usa –Sserver1 –Ppassword

If –P parameter is omitted, it prompts for the password

The prompt defaults to the line number, where the commands can be typed

e.g :  1>select db_name()

    2>go

  ———————

  master

  (1 row affected)

go, on a line by itself executes the command (There cannot be any blank spaces in front of go)

Batches in isql

A batch is a set of Transact-SQL statements that are submitted as a group by the client and executed as a group by the server

Example:

select * from titles

  select * from authors

  go

isql batches are terminated by the word go

Database Navigation in isql

A session is always in one of the server databases

To display the current database, use the command:

select db_name( )

go

To move to a different database, use the command:

use

go

System Procedures

System procedures are built-in utilities of Sybase to view, modify information inside Sybase ASE

They generally reside in sybsystemprocs(System database)

They are preceded with sp_

Examples of procedures

sp_help

Displays all the objects in the current database

sp_helpdb

Displays all the databases in the current server

sp_helpdb databasename

Displays detailed information about a particular database

Summary

In a client/server relationship:

The client is the program that receives requests from the user, sends them to the server, and returns the results to the user.

The server receives and executes client requests.

Adaptive Server is the ASE server.

ASE 12.5 includes two client applications:

isql, a command-line client

jisql, a java-based graphical interface client

System procedures can provide information on:

The databases managed by the server

The objects within a given database