<HTML ><HEAD ><TITLE >Sybase Adaptive Server Anywhere for Linux HOWTO</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.63 "><LINK REL="NEXT" TITLE="Introduction" HREF="intro.html"></HEAD ><BODY CLASS="ARTICLE" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="ARTICLE" ><DIV CLASS="TITLEPAGE" ><H1 CLASS="TITLE" ><A NAME="AEN2" >Sybase Adaptive Server Anywhere for Linux HOWTO</A ></H1 ><DIV CLASS="AUTHORGROUP" ><A NAME="AEN4" ></A ><H3 CLASS="AUTHOR" ><A NAME="AEN5" >Aylwin Lo</A ></H3 ><H3 CLASS="AUTHOR" ><A NAME="AEN8" >Tom Slee</A ></H3 ><DIV CLASS="AFFILIATION" ><SPAN CLASS="ORGNAME" >Sybase Inc.<BR></SPAN ><DIV CLASS="ADDRESS" ><P CLASS="ADDRESS" > Tom.Slee@sybase.com<br> </P ></DIV ></DIV ></DIV ><DIV CLASS="REVHISTORY" ><TABLE WIDTH="100%" BORDER="0" ><TR ><TH ALIGN="LEFT" VALIGN="TOP" COLSPAN="3" ><B >Revision History</B ></TH ></TR ><TR ><TD ALIGN="LEFT" >Revision 1.0</TD ><TD ALIGN="LEFT" >2001-04-26</TD ><TD ALIGN="LEFT" >Revised by: al</TD ></TR ><TR ><TD ALIGN="LEFT" COLSPAN="3" >First public release.</TD ></TR ></TABLE ></DIV ><DIV ><DIV CLASS="ABSTRACT" ><A NAME="AEN21" ></A ><P ></P ><P > 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. </P ><P ></P ></DIV ></DIV ><HR></DIV ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT >1. <A HREF="intro.html" >Introduction</A ></DT ><DD ><DL ><DT >1.1. <A HREF="intro.html#AEN26" >New versions of this document</A ></DT ><DT >1.2. <A HREF="intro.html#AEN30" >Content and Audience</A ></DT ><DT >1.3. <A HREF="intro.html#AEN35" >Adaptive Server Anywhere features</A ></DT ><DT >1.4. <A HREF="intro.html#AEN69" >Quirks</A ></DT ><DD ><DL ><DT >1.4.1. <A HREF="intro.html#AEN71" >Alt and Function keys</A ></DT ></DL ></DD ><DT >1.5. <A HREF="intro.html#DBCONCEPTS" >What's a Relational Database?</A ></DT ><DD ><DL ><DT >1.5.1. <A HREF="intro.html#AEN79" >Definition</A ></DT ><DT >1.5.2. <A HREF="intro.html#AEN84" >Example</A ></DT ><DT >1.5.3. <A HREF="intro.html#AEN303" >Primary and Foreign Keys</A ></DT ></DL ></DD ></DL ></DD ><DT >2. <A HREF="requirements.html" >Requirements</A ></DT ><DD ><DL ><DT >2.1. <A HREF="requirements.html#AEN315" >System requirements</A ></DT ><DT >2.2. <A HREF="requirements.html#AEN327" >Supported distributions</A ></DT ></DL ></DD ><DT >3. <A HREF="install.html" >Installation</A ></DT ><DD ><DL ><DT >3.1. <A HREF="install.html#AEN343" >Process</A ></DT ><DT >3.2. <A HREF="install.html#AEN365" >Distribution-specific considerations (for TurboLinux and Caldera)</A ></DT ><DT >3.3. <A HREF="install.html#AEN374" >Setting the Environment Variables</A ></DT ><DT >3.4. <A HREF="install.html#AEN399" >Where did it get installed?</A ></DT ></DL ></DD ><DT >4. <A HREF="x428.html" >Creating, Running and Connecting to Databases</A ></DT ><DD ><DL ><DT >4.1. <A HREF="x428.html#AEN430" >Creating a database</A ></DT ><DD ><DL ><DT >4.1.1. <A HREF="x428.html#ASA-41HTMLTOC511556197" >Creating a database from the command prompt</A ></DT ><DT >4.1.2. <A HREF="x428.html#ASA-41HTMLTOC511556198" >Creating a database from Sybase Central</A ></DT ></DL ></DD ><DT >4.2. <A HREF="x428.html#AEN461" >Running a database server and starting databases</A ></DT ><DD ><DL ><DT >4.2.1. <A HREF="x428.html#AEN527" >Running the server as a daemon</A ></DT ></DL ></DD ><DT >4.3. <A HREF="x428.html#AEN534" >Stopping the database server</A ></DT ><DT >4.4. <A HREF="x428.html#AEN569" >Stopping databases</A ></DT ><DT >4.5. <A HREF="x428.html#AEN576" >Connecting to a database</A ></DT ><DD ><DL ><DT >4.5.1. <A HREF="x428.html#AEN593" >Connection strings</A ></DT ><DT >4.5.2. <A HREF="x428.html#AEN606" >Connecting from Interactive SQL</A ></DT ><DT >4.5.3. <A HREF="x428.html#AEN609" >Connecting via ODBC</A ></DT ><DD ><DL ><DT >4.5.3.1. <A HREF="x428.html#AEN612" >Setting up ODBC with Adaptive Server Anywhere</A ></DT ><DT >4.5.3.2. <A HREF="x428.html#AEN625" >About ODBC data sources</A ></DT ><DT >4.5.3.3. <A HREF="x428.html#AEN669" >Connecting to an ODBC data source</A ></DT ></DL ></DD ></DL ></DD ></DL ></DD ><DT >5. <A HREF="backup.html" >Backing up and Restoring a Database</A ></DT ><DD ><DL ><DT >5.1. <A HREF="backup.html#AEN680" >Creating a Backup of the Database</A ></DT ><DD ><DL ><DT >5.1.1. <A HREF="backup.html#AEN683" >Full vs. Incremental Backups</A ></DT ><DT >5.1.2. <A HREF="backup.html#AEN687" >Online vs. Offline Backups</A ></DT ><DT >5.1.3. <A HREF="backup.html#AEN692" >Server-side vs. Client-side Backups</A ></DT ><DT >5.1.4. <A HREF="backup.html#AEN697" >How to make a backup</A ></DT ><DD ><DL ><DT >5.1.4.1. <A HREF="backup.html#AEN699" >From the command line</A ></DT ><DT >5.1.4.2. <A HREF="backup.html#AEN723" >From SQL</A ></DT ><DT >5.1.4.3. <A HREF="backup.html#AEN728" >From Sybase Central</A ></DT ></DL ></DD ></DL ></DD ><DT >5.2. <A HREF="backup.html#AEN731" >Validating the database and its backup</A ></DT ><DT >5.3. <A HREF="backup.html#AEN735" >Recovering the database</A ></DT ></DL ></DD ><DT >6. <A HREF="manage.html" >Managing a Database</A ></DT ><DD ><DL ><DT >6.1. <A HREF="manage.html#AEN740" >Tables</A ></DT ><DD ><DL ><DT >6.1.1. <A HREF="manage.html#AEN758" >Creating a Table</A ></DT ><DT >6.1.2. <A HREF="manage.html#AEN772" >Making Alterations to Tables</A ></DT ></DL ></DD ><DT >6.2. <A HREF="manage.html#AEN792" >Users, permissions, and authorities</A ></DT ><DD ><DL ><DT >6.2.1. <A HREF="manage.html#AEN796" >User IDs</A ></DT ><DD ><DL ><DT >6.2.1.1. <A HREF="manage.html#AEN798" >Special user IDs</A ></DT ><DT >6.2.1.2. <A HREF="manage.html#AEN804" >Creating new user IDs</A ></DT ></DL ></DD ><DT >6.2.2. <A HREF="manage.html#AEN813" >Permissions</A ></DT ><DT >6.2.3. <A HREF="manage.html#AEN855" >Authorities</A ></DT ><DD ><DL ><DT >6.2.3.1. <A HREF="manage.html#AEN858" >RESOURCE authority</A ></DT ><DT >6.2.3.2. <A HREF="manage.html#AEN863" >DBA authority</A ></DT ></DL ></DD ><DT >6.2.4. <A HREF="manage.html#AEN868" >Removing Users and Revoking Permissions</A ></DT ><DT >6.2.5. <A HREF="manage.html#AEN880" >Changing Passwords</A ></DT ></DL ></DD ><DT >6.3. <A HREF="manage.html#AEN888" >Making the database more secure</A ></DT ><DD ><DL ><DT >6.3.1. <A HREF="manage.html#AEN923" >Increasing password security</A ></DT ><DT >6.3.2. <A HREF="manage.html#AEN929" >Views, procedures, and triggers</A ></DT ><DT >6.3.3. <A HREF="manage.html#AEN935" >Encrypting client/server communications</A ></DT ></DL ></DD ></DL ></DD ><DT >7. <A HREF="moreinfo.html" >Where to get more information</A ></DT ><DT >8. <A HREF="legal.html" >Legalities and Acknowledgements</A ></DT ><DD ><DL ><DT >8.1. <A HREF="legal.html#AEN963" >Copyright and Licenses</A ></DT ><DT >8.2. <A HREF="legal.html#AEN977" >Names and Contacts</A ></DT ><DT >8.3. <A HREF="legal.html#AEN981" >Acknowledgement</A ></DT ></DL ></DD ></DL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" > </TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="intro.html" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" > </TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Introduction</TD ></TR ></TABLE ></DIV ></BODY ></HTML >