Home

	Expand Search

(Workplace UNIX) Introducing SQL Server

About This Book

About This Book

Introducing Sybase SQL Server for Workplace UNIX introduces the features and capabilities of Sybase(R) SQL Server(TM) for Workplace UNIX, an integrated set of Sybase products for developing client/server database applications.

Audience

This manual provides a starting point for:

• System administrators and other privileged users, who perform administrative tasks for the SQL Server for Workplace UNIX installation as a whole
• Database owners, who create and manage databases
• Application developers, who write programs to access the information in SQL Server databases

How to Use This Book

Introducing Sybase SQL Server for Workplace UNIX includes information you need to begin using SQL Server for Workplace UNIX. For each topic, the manual tells you where to get more detailed information if you need it.

Introducing Sybase SQL Server for Workplace UNIX is organized according to the tasks that users perform. The manual contains the following chapters:

Chapter	Topics Covered	Primary Audience
Chapter 1, "What Is Sybase SQL Server for Workplace UNIX?"	Introductory topics and concepts about SQL Server for Workplace UNIX	System administrators, database owners, application developers
Chapter 2, "Managing a SQL Server Installation"	Controlling system resources, managing users, tuning for performance, and performing other system maintenance activities	System administrators
Chapter 3, "Managing SQL Server Data"	Creating and managing databases and database objects	Database owners
Chapter 4, "Backing Up and Restoring Data"	Protecting your data from a system or media failure	System administrators
Chapter 5, "Accessing Data with Transact-SQL"	Using Sybase's enhanced Structured Query Language to access and manipulate the information in your SQL Server databases	System administrators, database owners, application developers
Chapter 6, "Building Client/Server Applications"	Using the Open Client(TM) application programming interfaces to build applications that access SQL Server databases	Application developers
Glossary	Defines terms relevant to SQL Server for Workplace UNIX	System administrators, database owners, application developers

Related Documents

SQL Server for Workplace UNIX includes a full range of documentation, in printed and online form, that provides comprehensive information to help you make the best use of the product's features and capabilities.

At the end of each chapter in this manual is a list of documents that provide additional information about the topics discussed within the chapter.

Conventions Used in This Manual

The following conventions in typography and terminology are used in this manual for consistency and clarity.

SQL Syntax Conventions

Listed below are the syntax conventions that this manual uses.

Key	Definition
command	Command names, command option names, utility names, utility flags, and other keywords are in bold Courier in syntax statements, and in bold Helvetica in paragraph text.
variable	Variables, or words that represent values that you supply, are in italics.
{ }	Curly braces indicate that you choose at least one of the enclosed options. (Do not type the braces.)
[ ]	Brackets indicate that you can include none or any of the enclosed options. (Do not type the brackets.)
( )	Parentheses are to be typed as part of the command.
|	The vertical bar means you may select only one of the options shown.
,	The comma means you may choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command

The manual also observes the following conventions:

• Syntax statements (displaying the syntax and all options for a command) are printed as follows:

  select column_name 
  from table_name 
  where search_conditions 

  In syntax statements, keywords (commands) are in normal font and identifiers are in lowercase; normal font is used for keywords, italics for user-supplied words.

• Examples showing the use of Transact-SQL(R) commands are printed as follows:

  select * from publishers

• You can disregard case when you type keywords:

  "SELECT" is the same as "Select" or "select."

• Client-Library(TM) routine syntax is shown as follows:

  CS_RETCODE ct_init(context, version)
  
  CS_CONTEXT context;
  CS_INT version;

• Client-Library structure names and symbolic constants are shown in uppercase:

  CS_CONTEXT, CS_SYNC_IO

Formatting SQL Statements

Transact-SQL has no rules about line length or breaks. However, for readability, examples and syntax statements in this manual are formatted so that each clause begins on a new line. Clauses that have more than one part extend to additional lines, which are indented.