Welcome to Linux Knowledge Base and Tutorial
"The place where you learn linux"
Mercy Corps

 Create an AccountHome | Submit News | Your Account  

Tutorial Menu
Linux Tutorial Home
Table of Contents

· Introduction to Operating Systems
· Linux Basics
· Working with the System
· Shells and Utilities
· Editing Files
· Basic Administration
· The Operating System
· The X Windowing System
· The Computer Itself
· Networking
· System Monitoring
· Solving Problems
· Security
· Installing and Upgrading
· Linux and Windows

Man Pages
Linux Topics
Test Your Knowledge

Site Menu
Site Map
Copyright Info
Terms of Use
Privacy Info
Masthead / Impressum
Your Account

Private Messages

News Archive
Submit News
User Articles
Web Links


The Web

Who's Online
There are currently, 78 guest(s) and 0 member(s) that are online.

You are an Anonymous user. You can register for free by clicking here



Current HOWTO: Sybase-ASA-HOWTO

Sybase Adaptive Server Anywhere for Linux HOWTO

Sybase Adaptive Server Anywhere for Linux HOWTO

Aylwin Lo

Tom Slee

Sybase Inc.


Revision History
Revision 1.02001-04-26Revised 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.

Table of Contents
1. Introduction
1.1. New versions of this document
1.2. Content and Audience
1.3. Adaptive Server Anywhere features
1.4. Quirks
1.4.1. Alt and Function keys
1.5. What's a Relational Database?
1.5.1. Definition
1.5.2. Example
1.5.3. Primary and Foreign Keys
2. Requirements
2.1. System requirements
2.2. Supported distributions
3. Installation
3.1. Process
3.2. Distribution-specific considerations (for TurboLinux and Caldera)
3.3. Setting the Environment Variables
3.4. Where did it get installed?
4. Creating, Running and Connecting to Databases
4.1. Creating a database
4.1.1. Creating a database from the command prompt
4.1.2. Creating a database from Sybase Central
4.2. Running a database server and starting databases
4.2.1. Running the server as a daemon
4.3. Stopping the database server
4.4. Stopping databases
4.5. Connecting to a database
4.5.1. Connection strings
4.5.2. Connecting from Interactive SQL
4.5.3. Connecting via ODBC Setting up ODBC with Adaptive Server Anywhere About ODBC data sources Connecting to an ODBC data source
5. Backing up and Restoring a Database
5.1. Creating a Backup of the Database
5.1.1. Full vs. Incremental Backups
5.1.2. Online vs. Offline Backups
5.1.3. Server-side vs. Client-side Backups
5.1.4. How to make a backup From the command line From SQL From Sybase Central
5.2. Validating the database and its backup
5.3. Recovering the database
6. Managing a Database
6.1. Tables
6.1.1. Creating a Table
6.1.2. Making Alterations to Tables
6.2. Users, permissions, and authorities
6.2.1. User IDs Special user IDs Creating new user IDs
6.2.2. Permissions
6.2.3. Authorities RESOURCE authority DBA authority
6.2.4. Removing Users and Revoking Permissions
6.2.5. Changing Passwords
6.3. Making the database more secure
6.3.1. Increasing password security
6.3.2. Views, procedures, and triggers
6.3.3. Encrypting client/server communications
7. Where to get more information
8. Legalities and Acknowledgements
8.1. Copyright and Licenses
8.2. Names and Contacts
8.3. Acknowledgement

The Linux Tutorial completely respects the rights of authors and artists to decide for themselves if and how their works can be used, independent of any existing licenses. This means if you are the author of any document presented on this site and do no wish it to be displayed as it is on this site or do not wish it to be displayed at all, please contact us and we will do our very best to accommodate you. If we are unable to accommodate you, we will, at your request, remove your document as quickly as possible.

If you are the author of any document presented on this site and would like a share of the advertising revenue, please contact us using the standard Feedback Form.


There are several different ways to navigate the tutorial.



Security Code
Security Code
Type Security Code

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.

Help if you can!

Amazon Wish List

Did You Know?
The Linux Tutorial can use your help.


Tell a Friend About Us

Bookmark and Share

Web site powered by PHP-Nuke

Is this information useful? At the very least you can help by spreading the word to your favorite newsgroups, mailing lists and forums.
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters. Articles are the property of their respective owners. Unless otherwise stated in the body of the article, article content (C) 1994-2013 by James Mohr. All rights reserved. The stylized page/paper, as well as the terms "The Linux Tutorial", "The Linux Server Tutorial", "The Linux Knowledge Base and Tutorial" and "The place where you learn Linux" are service marks of James Mohr. All rights reserved.
The Linux Knowledge Base and Tutorial may contain links to sites on the Internet, which are owned and operated by third parties. The Linux Tutorial is not responsible for the content of any such third-party site. By viewing/utilizing this web site, you have agreed to our disclaimer, terms of use and privacy policy. Use of automated download software ("harvesters") such as wget, httrack, etc. causes the site to quickly exceed its bandwidth limitation and are therefore expressly prohibited. For more details on this, take a look here

PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.12 Seconds