Sybase-ASA-HOWTO,
[ Pobierz całość w formacie PDF ]
Sybase Adaptive Server Anywhere for Linux
HOWTO
Aylwin Lo
Tom Slee
Sybase Inc.
Tom.Slee@sybase.com
Revision History
Revision 1.0
2001−04−26
Revised by: al
First public release.
This HOWTO guides you through the installation of SQL Anywhere Studio 7.0.2 for Linux and the basic
operation and administration of Adaptive Server Anywhere databases.
Sybase Adaptive Server Anywhere for Linux HOWTO
Table of Contents
....................................................................................................................................................1
........................................................................................................1
......................................................................................................................1
................................................................................................1
...............................................................................................................................................2
......................................................................................................2
.........................................................................................................2
.........................................................................................................................2
...........................................................................................................................2
...............................................................................................4
..................................................................................................................................................5
........................................................................................................................5
....................................................................................................................5
......................................................................................................................................................6
.............................................................................................................................................6
..............................................6
..................................................................................................6
...............................................................................................................7
.......................................................................................8
..........................................................................................................................8
..............................................................8
........................................................................9
...........................................................................9
....................................................................................10
..........................................................................................................10
.........................................................................................................................11
...............................................................................................................12
.........................................................................................................12
.................................................................................13
...................................................................................................13
.......................................................................................................16
................................................................................................16
.........................................................................................16
............................................................................................16
............................................................................16
...................................................................................................17
..........................................................................................18
................................................................................................................18
...................................................................................................................................19
.............................................................................................................................................19
.............................................................................................................19
........................................................................................20
................................................................................................20
i
Sybase Adaptive Server Anywhere for Linux HOWTO
Table of Contents
.........................................................................................................................21
....................................................................................................................21
.....................................................................................................................22
.................................................................23
......................................................................................................23
..................................................................................................23
.........................................................................................24
.....................................................................................24
.....................................................................25
..................................................................................................................26
.............................................................................................................27
.................................................................................................................27
.......................................................................................................................27
.........................................................................................................................27
ii
1. Introduction
This HOWTO guides you through the installation of SQL Anywhere Studio 7.0.2 for Linux and the basic
operation and administration of Adaptive Server Anywhere databases.
1.1. New versions of this document
The latest version of this document should always be available at the Linux Documentation project website
(
.
1.2. Content and Audience
Within this document, you will find a list of the supported Linux distributions ("
"). It is intended for
moderately experienced users of Linux or UNIX. Familiarity with relational database concepts is certainly
useful, but not a requirement. "
contains a summary of relational database concepts.
1.3. Adaptive Server Anywhere features
Adaptive Server Anywhere (Adaptive Server Anywhere) is the full SQL relational database management
system at the heart of SQL Anywhere Studio. Ideally suited for use as an embedded database, in mobile
computing, or as a workgroup server, it includes the following among its features:
·
Designed to operate without administration
Economical hardware requirements
·
Designed for mobile computing and synchronization
·
Ease of use
·
High performance
·
Cross−platform solution
·
Standalone and network use
·
Industry standard interfaces
·
Some of the more specific features include:
·
Java support for logic and datatypes
Stored procedures and triggers
·
For further details about Adaptive Server Anywhere, please visit the following links:
·
is a datasheet on SQL Anywhere Studio. It
includes some data on Adaptive Server Anywhere, which ships as a component of SQL Anywhere
Studio.
·
has some information on the features and
system requirements of SQL Anywhere Studio and points you to the download location for SQL
Anywhere Studio for Linux 7.0.
1. Introduction
1
Sybase Adaptive Server Anywhere for Linux HOWTO
1.4. Quirks
1.4.1. Alt and Function keys
Sometimes the Alt keys or the F1−F10 keys may not function in the terminal where you are running
Interactive SQL.
To emulate the Alt key, press Ctrl−A. Then press whatever key was to be pressed with the Alt key. For
example, instead of pressing Alt−F, you would press Ctrl−A, then F.
To emulate the function keys, press Ctrl−F, followed by the number of the function key you wanted to press.
For example, instead of pressing F9, you would press Ctrl−F, then 9. For F10, use the zero key.
1.5. What's a Relational Database?
If you are already familiar with relational databases, you can skip this section.
1.5.1. Definition
A
relational database−management system
(RDBMS) is a system for storing and retrieving data, in which
the data is organized in tables. A relational database consists of a collection of tables that store interrelated
data.
If that doesn't quite make sense yet, read on.
1.5.2. Example
Suppose you have some software to keep track of sales orders, and each order is stored in the form of a table,
called sales_order. It has information about the customer (for example, her name, address and phone
number), the date of the order, and information about the sales representative (for example his name,
department, and office phone number). Let's put all this into a table, with the data for a few orders:
Table 1. The sales_order table
cust_name cust_address cust_city_state_zip cust_phone order_date emp_name emp_dept emp_phone
M. Devlin 3114 Pioneer
Ave.
Rutherford, NJ
07070
2015558966 19930316 R. Overbey Sales
5105557255
M. Devlin 3114 Pioneer
Ave.
Rutherford, NJ
07070
2015558966 19940405 M. Kelly
Sales
5085553769
J.
Gagliardo
2800 Park Ave. Hull, PQ K1A 0H3 8195559539 19940326 M.Garcia Sales
7135553431
E. Peros 50 Market St. Rochester, NY
7165554275 19930603 P. Chin
Sales
4045552341
1.4. Quirks
2
[ Pobierz całość w formacie PDF ]