PC World 1997 November/PCWorld_1997-11_cd.bin/software/programy/komix/DATA.Z/dbeng50w.cnt

Microsoft Windows Help File Content | 1996-06-15 | 87KB | 1,526 lines

:Base dbeng50w.hlp
:Title SQL Anywhere User's Guide
:Index Network Guide=servnt.hlp
:Index User's Guide=dbeng50w.hlp
:Link dbeng50w.hlp
1 Users Guide Volume I
2 Users Guide Volume I =[e-mail]
2 Introduction to SQL Anywhere 5.0
3 Introduction to SQL Anywhere 5.0 =[e-mail]
3 New Features in SQL Anywhere 5.0
4 New Features in SQL Anywhere 5.0 =[e-mail]
4 What's in a name? =[e-mail]
4 New features overview =[e-mail]
4 New features in the Watcom-SQL language =[e-mail]
4 New sample database =[e-mail]
3 Overview of SQL Anywhere
4 Overview of SQL Anywhere =[e-mail]
4 The SQL Anywhere engine and the SQL Anywhere server =[e-mail]
4 Running SQL Anywhere on a single computer
5 Running SQL Anywhere on a single computer =[e-mail]
5 The client application =[e-mail]
5 The SQL Anywhere database engine =[e-mail]
5 The database =[e-mail]
4 Running SQL Anywhere on a network
5 Running SQL Anywhere on a network =[e-mail]
5 SQL Anywhere multiplatform support =[e-mail]
5 Some database terms =[e-mail]
4 Running mixed operating systems on a single computer
5 Running mixed operating systems on a single computer =[e-mail]
5 DOS or Windows client applications on OS/2 =[e-mail]
5 DOS or Windows 3.x clients on Windows 95 or NT =[e-mail]
4 SQL Anywhere programming interfaces
5 SQL Anywhere programming interfaces =[e-mail]
5 Low-level programming interfaces =[e-mail]
5 High-level programming interfaces =[e-mail]
4 The SQL Anywhere programs
5 The SQL Anywhere programs =[e-mail]
5 The SQL Anywhere database engine and server =[e-mail]
5 The SQL Anywhere Desktop Runtime database engine =[e-mail]
5 The SQL Central database management program =[e-mail]
5 SQL Anywhere administration utilities =[e-mail]
2 Tutorials
3 Tutorials =[e-mail]
3 Managing Databases with SQL Central
4 Managing Databases with SQL Central =[e-mail]
4 SQL Central and database management =[e-mail]
4 Navigating the main SQL Central window
5 Navigating the main SQL Central window =[e-mail]
5 Start SQL Central =[e-mail]
5 Connecting to a database from SQL Central =[e-mail]
5 Viewing a database schema =[e-mail]
4 Adding a table to a database
5 Adding a table to a database =[e-mail]
5 Create an empty table =[e-mail]
5 Adding a column to a table using Add Column =[e-mail]
5 Dragging a column to a new table =[e-mail]
5 Creating a primary key =[e-mail]
5 Deleting tables using SQL Central =[e-mail]
4 Viewing and editing procedures
5 Viewing and editing procedures =[e-mail]
5 Viewing a procedure =[e-mail]
4 Managing users and groups
5 Managing users and groups =[e-mail]
5 Adding a group to the database =[e-mail]
5 Adding a user to the database =[e-mail]
5 Adding a user to a group =[e-mail]
3 Backing up a database using SQL Central =[e-mail]
4 Using the SQL Central online help
5 Using the SQL Central online help =[e-mail]
5 Using the online help Contents =[e-mail]
5 Using the online help Index =[e-mail]
5 Searching the text of the online help =[e-mail]
3 Using ISQL
4 Using ISQL =[e-mail]
4 The SQL Anywhere program group =[e-mail]
4 Starting SQL Anywhere =[e-mail]
4 Connecting to the sample database from ISQL =[e-mail]
4 Accessing Help from ISQL =[e-mail]
4 The ISQL command window =[e-mail]
4 Leaving ISQL =[e-mail]
4 Displaying data in ISQL
5 Displaying data in ISQL =[e-mail]
5 Scrolling the data window =[e-mail]
3 Command recall in ISQL =[e-mail]
3 Function keys =[e-mail]
3 Canceling an ISQL command =[e-mail]
3 What's next? =[e-mail]
3 Selecting Data from Database Tables
4 Selecting Data from Database Tables =[e-mail]
4 Looking at the information in a table =[e-mail]
4 Ordering query results =[e-mail]
4 Selecting columns from a table =[e-mail]
4 Selecting rows from a table =[e-mail]
4 Comparing dates in queries =[e-mail]
4 Compound search conditions in the WHERE clause =[e-mail]
4 Pattern matching in search conditions =[e-mail]
4 Matching rows by sound =[e-mail]
4 Short cuts for typing search conditions =[e-mail]
3 Joining Tables
4 Joining Tables =[e-mail]
4 Displaying a list of tables =[e-mail]
4 Joining tables with the cross product =[e-mail]
4 Restricting a join =[e-mail]
4 How tables are related
5 How tables are related =[e-mail]
5 Rows are identified by a primary key =[e-mail]
5 Tables are related by a foreign key =[e-mail]
4 Join operators
5 Join operators =[e-mail]
5 Joining tables using key joins =[e-mail]
5 Joining tables using natural joins =[e-mail]
3 Obtaining Aggregate Data
4 Obtaining Aggregate Data =[e-mail]
4 A first look at aggregate functions =[e-mail]
4 Using aggregate functions to obtain grouped data =[e-mail]
4 Restricting groups =[e-mail]
3 Updating the Database
4 Updating the Database =[e-mail]
4 Adding rows to a table =[e-mail]
4 Modifying rows in a table =[e-mail]
4 Canceling changes =[e-mail]
4 Making changes permanent =[e-mail]
4 Deleting rows =[e-mail]
4 Validity checking
5 Validity checking =[e-mail]
5 Inserting duplicate data =[e-mail]
5 Inserting incorrect values =[e-mail]
5 Errors on DELETE or UPDATE =[e-mail]
3 Introduction to Views
4 Introduction to Views =[e-mail]
4 Defining a view =[e-mail]
4 Using views for security =[e-mail]
3 Introduction to Subqueries
4 Introduction to Subqueries =[e-mail]
4 Preparing to use subqueries =[e-mail]
4 A simple subquery =[e-mail]
4 Comparisons using subqueries =[e-mail]
4 Using subqueries instead of joins =[e-mail]
3 Command Files
4 Command Files =[e-mail]
4 Entering multiple statements in the ISQL Command window =[e-mail]
4 Saving statements as command files =[e-mail]
4 Command files with parameters =[e-mail]
3 System Tables
4 System Tables =[e-mail]
4 The SYSCATALOG table =[e-mail]
4 The SYSCOLUMNS table =[e-mail]
4 Other system tables =[e-mail]
2 Using SQL Anywhere
3 Using SQL Anywhere =[e-mail]
3 Connecting to a Database
4 Connecting to a Database =[e-mail]
4 Connection overview
5 Connection overview =[e-mail]
5 Database connection parameters =[e-mail]
5 Connection keyword meanings =[e-mail]
5 How client applications connect to a database =[e-mail]
3 Connecting from the SQL Anywhere utilities =[e-mail]
4 Connecting from an ODBC-enabled application
5 Connecting from an ODBC-enabled application =[e-mail]
5 SQL Anywhere support for ODBC =[e-mail]
5 Using ODBC under Windows and Windows NT =[e-mail]
5 Files needed for ODBC connections =[e-mail]
5 Working with ODBC data sources =[e-mail]
5 Using the ODBC Administrator =[e-mail]
5 Adding an ODBC data source =[e-mail]
5 Some sample ODBC data sources =[e-mail]
5 Modifying an existing ODBC data source =[e-mail]
5 Removing an ODBC data source =[e-mail]
5 Using ODBC under OS/2 =[e-mail]
5 Using ODBC under DOS and QNX =[e-mail]
3 Designing Your Database
4 Designing Your Database =[e-mail]
4 Relational database concepts
5 Relational database concepts =[e-mail]
5 Database tables =[e-mail]
5 Keys in relational databases =[e-mail]
5 Each table has a primary key =[e-mail]
5 Tables are related by foreign keys =[e-mail]
5 Other database objects =[e-mail]
3 Planning the database  =[e-mail]
4 The design process
5 The design process  =[e-mail]
5 Step 1: identify entities and relationships =[e-mail]
5 Entity and relationship example =[e-mail]
5 Step 2: identify the required data =[e-mail]
5 Step 3: normalize the data =[e-mail]
5 Step 4: resolve the relationships =[e-mail]
5 Step 5: verify the design =[e-mail]
4 Designing the database table properties
5 Designing the database table properties =[e-mail]
5 Choosing column names =[e-mail]
5 Choosing data types for columns =[e-mail]
5 Choosing constraints =[e-mail]
5 Choosing primary and foreign keys =[e-mail]
3 Working with Database Objects
4 Working with Database Objects =[e-mail]
4 Using SQL Central to work with database objects =[e-mail]
4 Using ISQL to work with database objects =[e-mail]
4 Working with databases
5 Working with databases =[e-mail]
5 Initializing a database =[e-mail]
5 Adding database files =[e-mail]
5 Preallocating space for database files =[e-mail]
5 Erasing a database =[e-mail]
4 Working with tables
5 Working with tables =[e-mail]
5 Creating tables =[e-mail]
5 Altering tables =[e-mail]
5 Deleting tables =[e-mail]
5 Creating primary and foreign keys =[e-mail]
5 Table information in the system tables =[e-mail]
4 Working with views
5 Working with views =[e-mail]
5 Creating views =[e-mail]
5 Using views =[e-mail]
5 Using the WITH CHECK OPTION clause =[e-mail]
5 Modifying views =[e-mail]
5 Permissions on views =[e-mail]
5 Deleting views =[e-mail]
5 Views in the system tables =[e-mail]
4 Working with indexes
5 Working with indexes =[e-mail]
5 Indexes in the system tables =[e-mail]
3 Ensuring Data Integrity
4 Ensuring Data Integrity =[e-mail]
4 Data integrity overview
5 Data integrity overview =[e-mail]
5 How data can become invalid =[e-mail]
5 Integrity constraints belong in the database =[e-mail]
5 How database contents get changed =[e-mail]
5 Data integrity tools in SQL Anywhere =[e-mail]
5 SQL statements for implementing integrity constraints =[e-mail]
4 Using column defaults
5 Using column defaults =[e-mail]
5 Creating column defaults =[e-mail]
5 Modifying and deleting column defaults =[e-mail]
5 Working with column defaults in SQL Central =[e-mail]
5 Current date and time defaults =[e-mail]
5 The user ID default =[e-mail]
5 The autoincrement default =[e-mail]
5 The NULL default =[e-mail]
5 String and number defaults =[e-mail]
5 Constant expression defaults =[e-mail]
4 Using table and column constraints
5 Using table and column constraints =[e-mail]
5 Using CHECK conditions on columns =[e-mail]
5 Column CHECK conditions from user-defined data types =[e-mail]
5 Working with column constraints in SQL Central =[e-mail]
5 Using CHECK conditions on tables =[e-mail]
5 Modifying and deleting CHECK conditions =[e-mail]
4 Enforcing entity and referential integrity
5 Enforcing entity and referential integrity =[e-mail]
5 Enforcing entity integrity =[e-mail]
5 If a client application breaches entity integrity =[e-mail]
5 Primary keys enforce entity integrity =[e-mail]
5 Enforcing referential integrity =[e-mail]
5 Foreign keys enforce referential integrity =[e-mail]
5 Losing referential integrity =[e-mail]
5 If a client application breaches referential integrity =[e-mail]
5 Referential integrity actions =[e-mail]
5 Referential integrity checking =[e-mail]
3 Integrity rules in the system tables =[e-mail]
3 Using Transactions and Locks
4 Using Transactions and Locks =[e-mail]
4 An overview of transactions
5 An overview of transactions =[e-mail]
5 Transactions and data recovery =[e-mail]
5 Transactions and concurrency =[e-mail]
5 Three types of inconsistency =[e-mail]
5 Using locks to ensure consistency =[e-mail]
3 How locking works =[e-mail]
4 Isolation levels and consistency
5 Isolation levels and consistency =[e-mail]
5 Locks and isolation levels =[e-mail]
5 Changing the isolation level =[e-mail]
4 How SQL Anywhere handles locking conflicts
5 How SQL Anywhere handles locking conflicts =[e-mail]
5 Locking conflicts and transaction blocking =[e-mail]
5 Transaction blocking and deadlock =[e-mail]
4 Choosing an isolation level
5 Choosing an isolation level =[e-mail]
5 Typical level 0 transactions =[e-mail]
5 Transactions for which no updates are lost =[e-mail]
5 Serializable transactions =[e-mail]
3 Savepoints within transactions =[e-mail]
4 Particular concurrency issues
5 Particular concurrency issues =[e-mail]
5 Primary key generation =[e-mail]
5 Data definition statements and concurrency =[e-mail]
5 Coordinating transactions with multiple database engines =[e-mail]
4 Transactions and portable computers
5 Transactions and portable computers =[e-mail]
5 Applying updates from a portable computer =[e-mail]
5 Distributing applications that do not require server updates =[e-mail]
5 Working with large databases on portable computers =[e-mail]
3 Using Procedures, Triggers, and Batches
4 Using Procedures, Triggers, and Batches =[e-mail]
4 Procedure and trigger overview =[e-mail]
4 Benefits of procedures and triggers =[e-mail]
4 Introduction to procedures
5 Introduction to procedures =[e-mail]
5 Creating procedures =[e-mail]
5 Calling procedures =[e-mail]
5 Dropping procedures =[e-mail]
5 Permissions to execute procedures =[e-mail]
5 Returning procedure results in parameters =[e-mail]
5 Returning procedure results in result sets =[e-mail]
4 Introduction to user-defined functions
5 Introduction to user-defined functions =[e-mail]
5 Creating user-defined functions =[e-mail]
5 Calling user-defined functions =[e-mail]
5 Dropping user-defined functions =[e-mail]
5 Permissions to execute user-defined functions =[e-mail]
4 Introduction to triggers
5 Introduction to triggers =[e-mail]
5 Creating triggers =[e-mail]
5 Executing triggers =[e-mail]
5 Dropping triggers =[e-mail]
5 Trigger execution permissions =[e-mail]
3 Introduction to batches =[e-mail]
4 Control statements
5 Control statements =[e-mail]
5 Using compound statements =[e-mail]
5 Declarations in compound statements =[e-mail]
5 Atomic compound statements =[e-mail]
4 The structure of procedures and triggers
5 The structure of procedures and triggers =[e-mail]
5 SQL statements allowed in procedures and triggers =[e-mail]
5 Declaring procedure parameters =[e-mail]
5 Passing parameters to procedures =[e-mail]
5 Passing parameters to functions =[e-mail]
4 Returning results from procedures
5 Returning results from procedures =[e-mail]
5 Returning a value using the RETURN statement =[e-mail]
5 Returning results as procedure parameters =[e-mail]
5 Returning result sets from procedures =[e-mail]
5 Returning multiple result sets from procedures =[e-mail]
4 Using cursors in procedures and triggers
5 Using cursors in procedures and triggers =[e-mail]
5 Cursor management overview =[e-mail]
5 Using cursors on SELECT statements in procedures =[e-mail]
4 Errors and warnings in procedures and triggers
5 Errors and warnings in procedures and triggers =[e-mail]
5 Default error handling in procedures and triggers =[e-mail]
5 Default handling of warnings in procedures and triggers =[e-mail]
5 Using exception handlers in procedures and triggers =[e-mail]
5 Nested compound statements and exception handlers =[e-mail]
3 Using the EXECUTE IMMEDIATE statement in procedures =[e-mail]
3 Transactions and savepoints in procedures and triggers =[e-mail]
4 Some hints for writing procedures
5 Some hints for writing procedures =[e-mail]
5 Check if you need to change the command delimiter =[e-mail]
5 Remember to delimit statements within your procedure =[e-mail]
5 Use fully-qualified names for tables in procedures =[e-mail]
5 Specifying dates and times in procedures =[e-mail]
5 Verifying that procedure input arguments are passed correctly =[e-mail]
4 Statements allowed in batches
5 Statements allowed in batches =[e-mail]
5 Using SELECT statements in batches =[e-mail]
4 Calling external libraries from stored procedures
5 Calling external libraries from stored procedures =[e-mail]
5 Creating procedures and functions with external calls =[e-mail]
5 External function declarations =[e-mail]
5 How parameters are passed to the external function =[e-mail]
5 Special considerations when passing character types =[e-mail]
3 Monitoring and Improving Performance
4 Monitoring and Improving Performance =[e-mail]
4 Factors affecting database performance =[e-mail]
4 Using keys to improve query performance
5 Using keys to improve query performance =[e-mail]
5 Using ISQL to examine query performance =[e-mail]
5 Using primary keys to improve query performance =[e-mail]
5 Using foreign keys to improve query performance =[e-mail]
4 Using indexes to improve query performance
5 Using indexes to improve query performance =[e-mail]
5 How indexes work =[e-mail]
3 Search strategies for queries from more than one table =[e-mail]
3 Sorting query results =[e-mail]
3 Temporary tables used in query processing =[e-mail]
4 How the optimizer works
5 How the optimizer works =[e-mail]
5 Optimizer estimates =[e-mail]
5 Self tuning of the query optimizer =[e-mail]
5 Providing estimates to improve query performance =[e-mail]
4 Monitoring database performance
5 Monitoring database performance =[e-mail]
5 Obtaining database statistics from a client application =[e-mail]
5 Monitoring database statistics from SQL Central =[e-mail]
5 Monitoring database statistics from the NT Performance Monitor =[e-mail]
3 Database Collations
4 Database Collations =[e-mail]
4 Collation overview
5 Collation overview =[e-mail]
5 Character sets in applications and databases =[e-mail]
5 Character encodings =[e-mail]
5 Displaying your current character settings =[e-mail]
5 Collation sequences =[e-mail]
4 Support for multibyte character sets
5 Support for multibyte character sets =[e-mail]
5 Variable length character sets =[e-mail]
5 First-byte collation orderings =[e-mail]
3 Choosing a character set =[e-mail]
3 Creating custom collations =[e-mail]
4 The collation file format
5 The collation file format =[e-mail]
5 Comment lines =[e-mail]
5 The title line =[e-mail]
5 The collation sequence section =[e-mail]
5 The Encodings section =[e-mail]
5 The Properties section =[e-mail]
3 Importing and Exporting Data
4 Importing and Exporting Data =[e-mail]
4 Import and export overview
5 Import and export overview =[e-mail]
5 Input and output data formats =[e-mail]
4 Exporting data from a database
5 Exporting data from a database =[e-mail]
5 Unloading data using the UNLOAD TABLE statement =[e-mail]
5 Exporting data using the ISQL OUTPUT statement =[e-mail]
5 Output redirection =[e-mail]
5 NULL value output =[e-mail]
5 Unloading a database using DBUNLOAD =[e-mail]
4 Importing data into a database
5 Importing data into a database =[e-mail]
5 Loading data using the LOAD TABLE statement =[e-mail]
5 Importing data using the ISQL INPUT statement =[e-mail]
5 Loading data interactively =[e-mail]
5 Handling conversion errors on data import =[e-mail]
5 Loading data that does not match the table structure =[e-mail]
3 Tuning bulk operations =[e-mail]
3 Managing User IDs and Permissions
4 Managing User IDs and Permissions =[e-mail]
4 An overview of database permissions
5 An overview of database permissions =[e-mail]
5 DBA authority overview =[e-mail]
5 Resource authority overview =[e-mail]
5 Ownership permissions overview =[e-mail]
5 Table and views permissions overview =[e-mail]
5 Procedures permissions overview =[e-mail]
5 Group permissions overview =[e-mail]
4 Managing individual user IDs and permissions
5 Managing individual user IDs and permissions =[e-mail]
5 Creating new users =[e-mail]
5 Changing a password =[e-mail]
5 Granting DBA and resource authority =[e-mail]
5 Granting permissions on tables and views =[e-mail]
5 Granting users the right to grant permissions =[e-mail]
5 Granting permissions on procedures =[e-mail]
5 Execution permissions of triggers =[e-mail]
5 Revoking user permissions =[e-mail]
4 Managing groups
5 Managing groups =[e-mail]
5 Creating groups =[e-mail]
5 Granting group membership to users =[e-mail]
5 Permissions of groups =[e-mail]
5 Referring to tables owned by groups =[e-mail]
5 Groups without passwords =[e-mail]
5 Special groups =[e-mail]
3 Database object names and prefixes =[e-mail]
4 Using views and procedures for extra security
5 Using views and procedures for extra security =[e-mail]
5 Using views for tailored security =[e-mail]
5 Using procedures for tailored security =[e-mail]
3 How SQL Anywhere assesses user permissions =[e-mail]
3 Users and permissions in the system tables =[e-mail]
3 Backup and Data Recovery
4 Backup and Data Recovery =[e-mail]
4 System and media failures =[e-mail]
4 The SQL Anywhere logs
5 The SQL Anywhere logs =[e-mail]
5 The checkpoint log =[e-mail]
5 The rollback log =[e-mail]
5 The transaction log =[e-mail]
5 Converting transaction logs to SQL =[e-mail]
4 Using a transaction log mirror
5 Using a transaction log mirror =[e-mail]
5 Creating and dropping a transaction log mirror =[e-mail]
5 Erasing transaction log mirrors =[e-mail]
5 Validating the transaction log on database startup =[e-mail]
5 Recovering from a corrupt transaction log or mirror =[e-mail]
4 Backing up your database
5 Backing up your database =[e-mail]
5 Performing a full backup =[e-mail]
5 Performing an incremental backup =[e-mail]
3 Recovery from system failure =[e-mail]
4 Recovery from media failure
5 Recovery from media failure =[e-mail]
5 Media failure on the database file =[e-mail]
5 Media failure on the transaction log =[e-mail]
5 Recovering uncommitted changes =[e-mail]
3 Introduction to SQL Remote Replication
4 Introduction to SQL Remote Replication =[e-mail]
4 Introduction to data replication =[e-mail]
4 SQL Remote concepts
5 SQL Remote concepts =[e-mail]
5 Consolidated and remote databases =[e-mail]
5 Message-based replication =[e-mail]
5 The Message Agent =[e-mail]
5 Publications and subscriptions =[e-mail]
5 Remote database users =[e-mail]
4 SQL Remote features
5 SQL Remote features =[e-mail]
5 Transaction log-based replication =[e-mail]
5 Central administration =[e-mail]
5 Support for many subscribers =[e-mail]
5 Economical resource requirements =[e-mail]
3 Message systems supported by SQL Remote =[e-mail]
4 Tutorial: setting up SQL Remote using SQL Central
5 Tutorial: setting up SQL Remote using SQL Central =[e-mail]
5 Preparing for the SQL Central replication tutorial =[e-mail]
4 Set up the consolidated database in SQL Central
5 Set up the consolidated database in SQL Central =[e-mail]
5 Add a SQL Remote message type =[e-mail]
5 Add the publisher and remote user to the database =[e-mail]
5 Add publications and subscriptions =[e-mail]
3 Set up the remote database in SQL Central =[e-mail]
4 Tutorial: setting up SQL Remote using ISQL and DBXTRACT
5 Tutorial: setting up SQL Remote using ISQL and DBXTRACT =[e-mail]
5 Preparing for the replication tutorial =[e-mail]
4 Set up the consolidated database
5 Set up the consolidated database =[e-mail]
5 Create a SQL Remote message type =[e-mail]
5 Grant PUBLISH and REMOTE at the consolidated database =[e-mail]
5 Create publications and subscriptions =[e-mail]
4 Set up the remote database
5 Set up the remote database =[e-mail]
5 Extract the remote database information =[e-mail]
5 Load the remote database information =[e-mail]
4 Start replicating data
5 Start replicating data =[e-mail]
5 Send data from the consolidated database =[e-mail]
5 Receive data at the remote database =[e-mail]
5 Replicate from the remote database to the consolidated database =[e-mail]
3 A sample publication =[e-mail]
4 Some sample SQL Remote setups
5 Some sample SQL Remote setups =[e-mail]
5 Server-to-laptop replication for mobile workforces =[e-mail]
5 Server-to-server replication among offices =[e-mail]
3 SQL Remote Administration
4 SQL Remote Administration  =[e-mail]
4 SQL Remote administration overview =[e-mail]
4 Adding SQL Remote message types =[e-mail]
4 Managing SQL Remote permissions
5 Managing SQL Remote permissions =[e-mail]
5 Granting and revoking PUBLISH permissions =[e-mail]
5 Granting and revoking REMOTE and CONSOLIDATE permissions =[e-mail]
4 Setting up publications
5 Setting up publications =[e-mail]
5 Publishing a set of tables =[e-mail]
5 Publishing a subset of columns =[e-mail]
5 Publishing a subset of rows using a WHERE clause =[e-mail]
5 Publishing a subset of rows using a SUBSCRIBE BY expression =[e-mail]
5 Dropping publications =[e-mail]
5 Notes on publications =[e-mail]
4 Designing publications
5 Designing publications =[e-mail]
5 Replication error and conflict overview =[e-mail]
5 Designing to avoid primary key errors =[e-mail]
5 Handling UPDATE conflicts =[e-mail]
5 Designing to avoid referential integrity errors =[e-mail]
5 Designing triggers to avoid errors =[e-mail]
5 Using subqueries in publications  =[e-mail]
5 SUBSCRIBE BY subqueries returning multiple values =[e-mail]
3 Setting up subscriptions =[e-mail]
4 Synchronizing databases
5 Synchronizing databases =[e-mail]
5 Using the extraction utility to synchronize databases =[e-mail]
5 Limits to using the extraction utility =[e-mail]
5 Synchronizing data over a message system =[e-mail]
5 Notes on synchronization =[e-mail]
4 How statements are replicated by SQL Remote
5 How statements are replicated by SQL Remote =[e-mail]
5 Replication of inserts and deletes =[e-mail]
5 Replication of updates =[e-mail]
5 Replication of procedures and triggers =[e-mail]
5 Replication of procedures =[e-mail]
5 Replication of triggers =[e-mail]
5 Replication of data definition statements =[e-mail]
3 Managing a running SQL Remote setup: overview =[e-mail]
4 Running the SQL Remote Message Agent
5 Running the SQL Remote Message Agent =[e-mail]
5 The Message Agent and replication security =[e-mail]
4 The SQL Remote message tracking system
5 The SQL Remote message tracking system =[e-mail]
5 Status information in the SYSREMOTEUSER system table =[e-mail]
5 Tracking messages by transaction log offsets =[e-mail]
5 Handling of lost or corrupt messages =[e-mail]
4 Transaction log and backup management for SQL Remote
5 Transaction log and backup management for SQL Remote =[e-mail]
5 Using the DELETE_OLD_LOGS option =[e-mail]
5 Backup procedures at remote databases =[e-mail]
5 The Unload utility and replication =[e-mail]
4 Error reporting and conflict resolution in SQL Remote
5 Error reporting and conflict resolution in SQL Remote =[e-mail]
5 Error reporting and conflict resolution =[e-mail]
5 Error reporting in the Message Agent output =[e-mail]
5 RESOLVE UPDATE triggers =[e-mail]
5 UPDATE conflict resolution examples =[e-mail]
4 Using passthrough mode for administration
5 Using passthrough mode for administration =[e-mail]
5 Uses and limitations of passthrough mode =[e-mail]
3 Running Programs as Windows NT Services
4 Running Programs as Windows NT Services =[e-mail]
4 Introduction to Windows NT services =[e-mail]
4 The SQL Anywhere Service Manager
5 The SQL Anywhere Service Manager =[e-mail]
5 Service Manager polling frequency =[e-mail]
3 Adding a new SQL Anywhere service =[e-mail]
4 Configuring a SQL Anywhere service
5 Configuring a SQL Anywhere service =[e-mail]
5 Entering command-line switches =[e-mail]
5 Setting the startup option =[e-mail]
5 Setting the logon options =[e-mail]
5 Changing the executable file =[e-mail]
5 Changing the name of a service  =[e-mail]
5 Adding new databases to a server or engine service =[e-mail]
4 Starting and stopping services
5 Starting and stopping services =[e-mail]
5 Starting a SQL Anywhere service =[e-mail]
5 Stopping a SQL Anywhere service =[e-mail]
5 Pausing a SQL Anywhere service =[e-mail]
4 Removing a SQL Anywhere service
5 Removing a SQL Anywhere service =[e-mail]
5 Possible problems running more than one server service =[e-mail]
3 Monitoring a SQL Anywhere network server service =[e-mail]
3 The Windows NT Control Panel Service Manager =[e-mail]
2 Transact-SQL Compatibility
3 Transact-SQL Compatibility =[e-mail]
3 Using Transact-SQL with SQL Anywhere
4 Using Transact-SQL with SQL Anywhere =[e-mail]
4 An overview of SQL Anywhere support for Transact-SQL =[e-mail]
4 SQL Server and SQL Anywhere architectures
5 SQL Server and SQL Anywhere architectures =[e-mail]
5 Servers and databases in SQL Server and SQL Anywhere =[e-mail]
5 System tables in SQL Anywhere and SQL Server =[e-mail]
5 Administrative roles in SQL Server and SQL Anywhere =[e-mail]
5 Users and groups in SQL Anywhere and SQL Server =[e-mail]
3 General guidelines for writing portable SQL =[e-mail]
4 Configuring SQL Anywhere for Transact-SQL compatibility
5 Configuring SQL Anywhere for Transact-SQL compatibility =[e-mail]
5 Creating a Transact-SQL-compatible database =[e-mail]
5 Setting options for Transact-SQL compatibility =[e-mail]
5 Case-sensitivity in SQL Server and SQL Anywhere databases =[e-mail]
5 Ensuring compatible object names =[e-mail]
4 Using compatible data types
5 Using compatible data types =[e-mail]
5 Integer data types =[e-mail]
5 Decimal data types =[e-mail]
5 Compatibility of character data types =[e-mail]
5 Compatibility of binary data types =[e-mail]
5 Money data types =[e-mail]
5 Bit data type =[e-mail]
5 Compatibility of date and time data types =[e-mail]
5 The special Transact-SQL timestamp column and data type =[e-mail]
5 The special identity column =[e-mail]
5 Compatibility of user-defined data types =[e-mail]
4 Local and global variables
5 Local and global variables =[e-mail]
5 Local variable support =[e-mail]
5 Global variable support =[e-mail]
5 Obtaining the values of variables =[e-mail]
4 Building compatible expressions
5 Building compatible expressions =[e-mail]
5 Compatibility of constants =[e-mail]
5 Compatibility of operators =[e-mail]
4 Using compatible functions
5 Using compatible functions =[e-mail]
5 Compatibility of aggregate functions =[e-mail]
5 Compatibility of numeric functions =[e-mail]
5 Compatibility of string functions =[e-mail]
5 Compatibility of date and time functions =[e-mail]
5 Compatibility of data type conversion functions =[e-mail]
5 Compatibility of miscellaneous functions =[e-mail]
5 Compatibility of text and image functions =[e-mail]
5 Compatibility of system functions =[e-mail]
4 Building compatible search conditions
5 Building compatible search conditions =[e-mail]
5 Compatibility of comparison conditions =[e-mail]
5 Compatibility of comparison operators =[e-mail]
5 Compatibility of BETWEEN and LIKE conditions =[e-mail]
5 Compatibility of IN conditions =[e-mail]
5 Compatibility of ALL and ANY conditions =[e-mail]
5 Compatibility of EXISTS conditions =[e-mail]
5 Compatibility of IS NULL conditions =[e-mail]
5 Providing estimates for conditions =[e-mail]
5 Conditions using logical operators =[e-mail]
4 Other language elements
5 Other language elements =[e-mail]
5 Compatible comment indicators =[e-mail]
4 Transact-SQL statement reference
5 Transact-SQL statement reference =[e-mail]
5 Transact-SQL BEGIN TRANSACTION statement =[e-mail]
5 Transact-SQL COMMIT statement =[e-mail]
5 Transact-SQL DATABASE statements =[e-mail]
5 Transact-SQL CREATE DEFAULT and CREATE RULE statements =[e-mail]
5 Transact-SQL CREATE INDEX statement =[e-mail]
5 Transact-SQL CREATE SCHEMA statement =[e-mail]
5 Transact-SQL CREATE TABLE statement =[e-mail]
5 Transact-SQL DELETE statement =[e-mail]
5 Transact-SQL DISK statements =[e-mail]
5 Transact-SQL GRANT and REVOKE statements =[e-mail]
5 Transact-SQL INSERT statement =[e-mail]
5 Transact-SQL joins =[e-mail]
5 Transact-SQL READTEXT statement =[e-mail]
5 Transact-SQL ROLLBACK statement =[e-mail]
5 Transact-SQL SELECT statement =[e-mail]
5 Transact-SQL SET statement =[e-mail]
5 Transact-SQL UPDATE statement =[e-mail]
5 Transact-SQL WRITETEXT statement =[e-mail]
3 Compatible system catalog information =[e-mail]
4 SQL Server system and catalog procedures
5 SQL Server system and catalog procedures =[e-mail]
5 SQL Server system procedures =[e-mail]
5 SQL Server catalog procedures =[e-mail]
4 Implicit data type conversion
5 Implicit data type conversion =[e-mail]
5 Differences in string to datetime conversions =[e-mail]
3 Transact-SQL Procedure Language
4 Transact-SQL Procedure Language =[e-mail]
4 Transact-SQL procedure language overview
5 Transact-SQL procedure language overview =[e-mail]
5 Mixing Transact-SQL and Watcom-SQL dialects =[e-mail]
4 Automatic translation of SQL statements
5 Automatic translation of SQL statements =[e-mail]
5 Using SQL Central to translate stored procedures =[e-mail]
3 Transact-SQL stored procedure overview =[e-mail]
3 Transact-SQL trigger overview =[e-mail]
3 Transact-SQL batch overview =[e-mail]
4 Supported Transact-SQL procedure language statements
5 Supported Transact-SQL procedure language statements =[e-mail]
5 Transact-SQL BEGIN ... END statement =[e-mail]
5 Transact-SQL CREATE PROCEDURE statement
6 Transact-SQL CREATE PROCEDURE statement =[e-mail]
6 Comparison of Transact-SQL and Watcom-SQL CREATE PROCEDURE statements =[e-mail]
4 Transact-SQL CREATE TRIGGER statement =[e-mail]
4 Transact-SQL EXECUTE statement =[e-mail]
4 Transact-SQL GOTO statement =[e-mail]
4 Transact-SQL IF statement =[e-mail]
4 Transact-SQL PRINT statement =[e-mail]
4 Transact-SQL RAISERROR statement =[e-mail]
4 The Transact-SQL RETURN statement =[e-mail]
4 Transact-SQL WHILE statement =[e-mail]
3 Returning result sets from Transact-SQL procedures =[e-mail]
4 Variable and cursor declarations
5 Variable and cursor declarations =[e-mail]
5 Transact-SQL DECLARE CURSOR statement =[e-mail]
5 Transact-SQL DECLARE statement
6 Transact-SQL DECLARE statement =[e-mail]
6 Assigning values to variables in Transact-SQL =[e-mail]
4 Error handling in Transact-SQL procedures
5 Error handling in Transact-SQL procedures =[e-mail]
5 Using the RAISERROR statement in procedures =[e-mail]
5 Transact-SQL-like error handling in the Watcom-SQL dialect =[e-mail]
3 Using the Open Server Gateway
4 Using the Open Server Gateway =[e-mail]
4 Open Server Gateway overview =[e-mail]
4 Open Server Gateway architecture
5 Open Server Gateway architecture =[e-mail]
5 What you need to use the Open Server Gateway =[e-mail]
4 Setting up the Open Server Gateway
5 Setting up the Open Server Gateway =[e-mail]
5 Starting the Open Server Gateway =[e-mail]
4 Events handled by Open Server Gateway
5 Events handled by Open Server Gateway =[e-mail]
5 Standard event handling in Open Server Gateway =[e-mail]
2 The SQL Anywhere Programming Interfaces
3 The SQL Anywhere Programming Interfaces =[e-mail]
3 Programming Interfaces =[e-mail]
3 The Embedded SQL Interface
4 The Embedded SQL Interface =[e-mail]
4 The C language SQL preprocessor
5 The C language SQL preprocessor =[e-mail]
5 Supported compilers =[e-mail]
5 Development process for Windows 3.x and 95, OS/2, or Windows NT =[e-mail]
5 Development process for DOS or QNX =[e-mail]
5 Running the SQL preprocessor =[e-mail]
5 Embedded SQL header files =[e-mail]
5 Embedded SQL libraries =[e-mail]
5 A simple example =[e-mail]
5 Structure of Embedded SQL programs =[e-mail]
5 Authorization =[e-mail]
3 Embedded SQL interface data types =[e-mail]
4 Host variables
5 Host variables =[e-mail]
5 Host variable declarations =[e-mail]
5 C host variable types =[e-mail]
5 Host variable usage =[e-mail]
5 Indicator variables =[e-mail]
3 The SQL communication area =[e-mail]
4 Fetching data
5 Fetching data =[e-mail]
5 Embedded SELECT =[e-mail]
5 Cursors in Embedded SQL =[e-mail]
4 Static vs dynamic SQL
5 Static vs dynamic SQL =[e-mail]
5 Static statements =[e-mail]
5 Dynamic statements =[e-mail]
5 Dynamic SELECT statement =[e-mail]
5 Fetching more than one row at a time =[e-mail]
4 The SQL descriptor area
5 The SQL descriptor area =[e-mail]
5 Length field values =[e-mail]
4 SQL procedures in Embedded SQL
5 SQL procedures in Embedded SQL =[e-mail]
5 Simple procedures =[e-mail]
5 Procedures with result sets =[e-mail]
5 Multi-Threaded or Reentrant Code =[e-mail]
5 Multiple SQLCAs =[e-mail]
5 Connection Management with Multiple SQLCAs =[e-mail]
4 Library functions
5 Library functions =[e-mail]
5 Interface initialization functions =[e-mail]
5 Connection and engine management functions =[e-mail]
5 SQLDA management functions =[e-mail]
5 Backup functions =[e-mail]
5 Other functions =[e-mail]
5 Aborting a request =[e-mail]
5 Windows 3.x request management =[e-mail]
5 Multiple SQLCA management =[e-mail]
5 Memory allocation in DOS and QNX =[e-mail]
5 DOS interrupt processing and request management =[e-mail]
3 Embedded SQL commands =[e-mail]
4 Database examples
5 Database examples =[e-mail]
5 Building the examples =[e-mail]
5 Running the example programs =[e-mail]
5 Static cursor example =[e-mail]
5 Dynamic cursor example =[e-mail]
5 NT Service examples =[e-mail]
3 SQLDEF.H header file =[e-mail]
3 ODBC Programming
4 ODBC Programming =[e-mail]
4 ODBC C language programming
5 ODBC C language programming =[e-mail]
5 Fundamentals =[e-mail]
5 Compiling and linking an ODBC application =[e-mail]
5 A first example =[e-mail]
5 Error checking =[e-mail]
5 Cursors in ODBC =[e-mail]
5 Procedures and triggers in ODBC =[e-mail]
5 ODBC conformance =[e-mail]
5 The sample program =[e-mail]
3 ODBC programming for the Macintosh =[e-mail]
3 The WSQL DDE Server
4 The WSQL DDE Server =[e-mail]
4 DDE concepts
5 DDE concepts =[e-mail]
5 What is DDE? =[e-mail]
5 DDE conversations =[e-mail]
5 Sending and receiving data and commands using DDE =[e-mail]
5 DDE links =[e-mail]
4 Using WSQL DDE Server
5 Using WSQL DDE Server =[e-mail]
5 The WSQL DDE Server window =[e-mail]
5 Initiating a DDE conversation with WSQL DDE Server =[e-mail]
5 Communicating with the WSQL DDE Server =[e-mail]
3 Excel and WSQL DDE Server =[e-mail]
3 Word and WSQL DDE Server =[e-mail]
4 Visual Basic and WSQL DDE Server
5 Visual Basic and WSQL DDE Server =[e-mail]
5 The test application =[e-mail]
5 Running the test application =[e-mail]
3 The WSQL HLI Interface
4 The WSQL HLI Interface =[e-mail]
4 DLL concepts =[e-mail]
4 Using WSQL HLI =[e-mail]
4 Host variables with WSQL HLI =[e-mail]
4 WSQL HLI functions
5 WSQL HLI functions =[e-mail]
5 wsqlexec =[e-mail]
5 wsqlgetfield =[e-mail]
5 wsqlgetcolumnname =[e-mail]
5 wsqlquerytomemdelim =[e-mail]
5 wsqlquerytomem =[e-mail]
5 wsqllasterror =[e-mail]
5 wsqlregisterfuncs =[e-mail]
3 wsqlexec command strings =[e-mail]
4 WSQL HLI and Visual Basic
5 WSQL HLI and Visual Basic =[e-mail]
5 Visual Basic example =[e-mail]
5 The sample application =[e-mail]
5 Running the sample application =[e-mail]
4 WSQL HLI and REXX
5 WSQL HLI and REXX =[e-mail]
5 Error codes and messages =[e-mail]
5 REXX examples =[e-mail]
1 Users Guide Volume II
2 Users Guide Volume II =[e-mail]
2 SQL Anywhere Reference
3 SQL Anywhere Reference =[e-mail]
3 SQL Anywhere Components
4 SQL Anywhere Components =[e-mail]
4 SQL Anywhere components overview =[e-mail]
4 Environment variables
5 Environment variables =[e-mail]
5 SQLANY environment variable =[e-mail]
5 SQLCONNECT environment variable =[e-mail]
5 SQLPATH environment variable =[e-mail]
5 SQLREMOTE environment variable =[e-mail]
5 SQLSTART environment variable =[e-mail]
5 TMP environment variable =[e-mail]
3 Software component return codes =[e-mail]
3 The database engine =[e-mail]
4 The Backup utility
5 The Backup utility =[e-mail]
5 Backing up a database from SQL Central =[e-mail]
5 Backing up a database from the ISQL Tools window =[e-mail]
5 Backing up a database using the DBTOOL statement =[e-mail]
5 The DBBACKUP command-line utility =[e-mail]
5 Backup utility options =[e-mail]
4 The Collation utility
5 The Collation utility =[e-mail]
5 Extracting a collation in the ISQL Database Tools window =[e-mail]
5 Extracting a collation using the DBTOOL statement =[e-mail]
5 The DBCOLLAT command-line utility =[e-mail]
5 Collation utility options =[e-mail]
4 The Compression utility
5 The Compression utility =[e-mail]
5 Compressing a database in SQL Central =[e-mail]
5 Compressing a database from the ISQL Tools window =[e-mail]
5 Compressing a database using the DBTOOL statement =[e-mail]
5 The DBSHRINK command-line utility =[e-mail]
5 Compression utility options =[e-mail]
4 The Erase utility
5 The Erase utility =[e-mail]
5 Erasing a database from SQL Central =[e-mail]
5 Erasing a database from the ISQL Tools window =[e-mail]
5 Erasing a database using the DBTOOL statement =[e-mail]
5 The DBERASE command-line utility =[e-mail]
5 Erase utility options =[e-mail]
4 The Information utility
5 The Information utility =[e-mail]
5 Obtaining database information in the ISQL Tools window =[e-mail]
5 Obtaining database information using the DBTOOL statement =[e-mail]
5 The DBINFO command-line utility =[e-mail]
5 Information utility options =[e-mail]
4 The Initialization utility
5 The Initialization utility =[e-mail]
5 Creating a database in SQL Central =[e-mail]
5 Creating a database from the ISQL Tools window =[e-mail]
5 Creating a database using the DBTOOL statement =[e-mail]
5 The DBINIT command-line utility =[e-mail]
5 Initialization utility options =[e-mail]
4 The ISQL utility
5 The ISQL utility =[e-mail]
5 Commands available in ISQL =[e-mail]
5 Starting ISQL from SQL Central =[e-mail]
4 The Log Translation utility
5 The Log Translation utility =[e-mail]
5 Translating a transaction log in SQL Central =[e-mail]
5 Translating a transaction log from the ISQL Tools window =[e-mail]
5 Translating a transaction log using the DBTOOL statement =[e-mail]
5 The DBTRAN command-line utility =[e-mail]
5 Log translation utility options =[e-mail]
3 The Open Server Gateway =[e-mail]
3 The Open Server Information utility =[e-mail]
3 The Open Server Stop utility =[e-mail]
3 The REBUILD batch or command file =[e-mail]
4 The SQL Remote Database Extraction utility
5 The SQL Remote Database Extraction utility =[e-mail]
5 Extracting a remote database in SQL Central =[e-mail]
5 The DBXTRACT command-line utility =[e-mail]
5 Extraction utility options =[e-mail]
3 The SQL Remote Message Agent =[e-mail]
4 The Stop utility
5 The Stop utility =[e-mail]
5 The DBSTOP command-line utility =[e-mail]
5 Stop utility options =[e-mail]
4 The Transaction Log utility
5 The Transaction Log utility =[e-mail]
5 Changing a log file name from SQL Central =[e-mail]
5 Changing a log file name from the ISQL Tools window =[e-mail]
5 Changing a log filename from the DBTOOL statement =[e-mail]
5 The DBLOG command-line utility =[e-mail]
5 Transaction log utility options =[e-mail]
4 The Uncompression utility
5 The Uncompression utility =[e-mail]
5 Uncompressing a database in SQL Central =[e-mail]
5 Uncompressing a database from the ISQL Tools window =[e-mail]
5 Uncompressing a database using the DBTOOL statement =[e-mail]
5 The DBEXPAND command-line utility =[e-mail]
5 Uncompression utility options =[e-mail]
4 The Unload utility
5 The Unload utility =[e-mail]
5 Unloading a database from SQL Central =[e-mail]
5 Unloading a database from the ISQL Tools window =[e-mail]
5 Unloading a database from the DBTOOL statement =[e-mail]
5 The DBUNLOAD command-line utility =[e-mail]
5 Unload utility options =[e-mail]
4 The Upgrade utility
5 The Upgrade utility =[e-mail]
5 Upgrading a database from SQL Central =[e-mail]
5 Upgrading databases too old for the Upgrade utility =[e-mail]
5 The DBUPGRAD command-line utility =[e-mail]
5 Upgrade utility options =[e-mail]
4 The Validation utility
5 The Validation utility =[e-mail]
5 Validating a database from SQL Central =[e-mail]
5 Validating a database from the ISQL Tools window =[e-mail]
5 Using the Validation utility from the DBTOOL statement =[e-mail]
5 Using the DBVALID command line utility =[e-mail]
5 Validation utility options =[e-mail]
4 The Write File utility
5 The Write File utility =[e-mail]
5 Creating a write file from SQL Central =[e-mail]
5 Creating a write file from the ISQL Tools window =[e-mail]
5 Creating a write file using the DBTOOL statement =[e-mail]
5 The DBWRITE command-line utility =[e-mail]
5 Write file utility options =[e-mail]
3 The SQL Preprocessor =[e-mail]
3 Watcom-SQL Language Reference
4 Watcom-SQL Language Reference =[e-mail]
4 Syntax conventions =[e-mail]
4 Watcom-SQL language elements =[e-mail]
4 Data types
5 Data types =[e-mail]
5 Character data types =[e-mail]
5 Numeric data types =[e-mail]
5 Date and time data types =[e-mail]
5 Binary data types =[e-mail]
5 User-defined data types =[e-mail]
5 Data type conversions =[e-mail]
4 Functions
5 Functions =[e-mail]
5 Aggregate functions =[e-mail]
5 Numeric functions =[e-mail]
5 String functions =[e-mail]
5 Date and time functions =[e-mail]
5 Data type conversion functions =[e-mail]
5 System functions =[e-mail]
5 Miscellaneous functions =[e-mail]
4 Expressions
5 Expressions =[e-mail]
5 Constants in expressions =[e-mail]
5 Column names in expressions =[e-mail]
5 Watcom-SQL variables =[e-mail]
5 Functions in expressions =[e-mail]
5 Subqueries in expressions =[e-mail]
5 Watcom-SQL Operators =[e-mail]
4 Search conditions
5 Search conditions =[e-mail]
5 Subqueries in search conditions =[e-mail]
5 Comparison conditions =[e-mail]
5 BETWEEN conditions =[e-mail]
5 LIKE conditions =[e-mail]
5 IN conditions =[e-mail]
5 ALL or ANY conditions =[e-mail]
5 EXISTS conditions =[e-mail]
5 IS NULL conditions =[e-mail]
5 Conditions with logical operators =[e-mail]
5 NOT conditions =[e-mail]
5 Truth value conditions =[e-mail]
5 Three-valued logic =[e-mail]
3 Comments in Watcom-SQL =[e-mail]
4 SQL statement syntax
5 SQL statement syntax =[e-mail]
5 ALTER DBSPACE statement =[e-mail]
5 ALTER PROCEDURE statement =[e-mail]
5 ALTER PUBLICATION statement =[e-mail]
5 ALTER REMOTE MESSAGE TYPE statement =[e-mail]
5 ALTER TABLE statement =[e-mail]
5 CALL statement =[e-mail]
5 CASE statement =[e-mail]
5 CHECKPOINT statement =[e-mail]
5 CLOSE statement =[e-mail]
5 COMMENT statement =[e-mail]
5 COMMIT statement =[e-mail]
5 Compound statements =[e-mail]
5 CONFIGURE statement =[e-mail]
5 CONNECT statement =[e-mail]
5 CREATE DATATYPE statement =[e-mail]
5 CREATE DBSPACE statement =[e-mail]
5 CREATE FUNCTION statement =[e-mail]
5 CREATE INDEX statement =[e-mail]
5 CREATE PROCEDURE statement =[e-mail]
5 CREATE PUBLICATION statement =[e-mail]
5 CREATE REMOTE MESSAGE TYPE statement =[e-mail]
5 CREATE SCHEMA statement =[e-mail]
5 CREATE SUBSCRIPTION statement =[e-mail]
5 CREATE TABLE statement
6 CREATE TABLE statement =[e-mail]
6 Integrity constraints =[e-mail]
4 CREATE TRIGGER statement =[e-mail]
4 CREATE VARIABLE statement =[e-mail]
4 CREATE VIEW statement =[e-mail]
4 DBTOOL statement =[e-mail]
4 Declaration section =[e-mail]
4 DECLARE CURSOR statement =[e-mail]
4 DECLARE TEMPORARY TABLE statement =[e-mail]
4 DELETE statement =[e-mail]
4 DELETE positioned statement =[e-mail]
4 DESCRIBE statement =[e-mail]
4 DISCONNECT statement =[e-mail]
4 DROP statement =[e-mail]
4 DROP CONNECTION statement =[e-mail]
4 DROP OPTIMIZER STATISTICS statement =[e-mail]
4 DROP PUBLICATION statement =[e-mail]
4 DROP REMOTE MESSAGE TYPE statement =[e-mail]
4 DROP STATEMENT statement =[e-mail]
4 DROP VARIABLE statement =[e-mail]
4 DROP SUBSCRIPTION statement =[e-mail]
4 EXECUTE statement =[e-mail]
4 EXECUTE IMMEDIATE statement =[e-mail]
4 EXIT statement =[e-mail]
4 EXPLAIN statement =[e-mail]
4 FETCH statement =[e-mail]
4 FOR statement =[e-mail]
5 FROM clause
6 FROM clause =[e-mail]
6 Joining tables =[e-mail]
6 Cross joins =[e-mail]
6 Generated join conditions =[e-mail]
6 Natural joins =[e-mail]
6 Key joins =[e-mail]
6 INNER JOIN and OUTER JOIN =[e-mail]
6 Join conditions =[e-mail]
6 Join abbreviations =[e-mail]
4 GET DATA statement =[e-mail]
4 GET OPTION statement =[e-mail]
4 GRANT statement =[e-mail]
4 GRANT CONSOLIDATE statement =[e-mail]
4 GRANT PUBLISH statement =[e-mail]
4 GRANT REMOTE statement =[e-mail]
4 HELP statement =[e-mail]
4 IF statement =[e-mail]
4 INCLUDE statement =[e-mail]
4 INPUT statement =[e-mail]
4 INSERT statement =[e-mail]
4 LEAVE statement =[e-mail]
4 LOAD TABLE statement =[e-mail]
4 LOOP statement =[e-mail]
4 MESSAGE statement =[e-mail]
4 NULL value =[e-mail]
4 OPEN statement =[e-mail]
4 OUTPUT statement =[e-mail]
4 PARAMETERS statement =[e-mail]
4 PASSTHROUGH statement =[e-mail]
4 PREPARE statement =[e-mail]
4 PREPARE TO COMMIT statement =[e-mail]
4 PUT statement =[e-mail]
4 READ statement =[e-mail]
4 RELEASE SAVEPOINT statement =[e-mail]
4 RESIGNAL statement =[e-mail]
4 RESUME statement =[e-mail]
4 RETURN statement =[e-mail]
4 REVOKE statement =[e-mail]
4 REVOKE CONSOLIDATE statement =[e-mail]
4 REVOKE PUBLISH statement =[e-mail]
4 REVOKE REMOTE statement =[e-mail]
4 ROLLBACK statement =[e-mail]
4 ROLLBACK TO SAVEPOINT statement =[e-mail]
4 SAVEPOINT statement =[e-mail]
4 SELECT statement =[e-mail]
4 SET CONNECTION statement =[e-mail]
5 SET OPTION statement
6 SET OPTION statement =[e-mail]
6 Database options =[e-mail]
6 Replication options =[e-mail]
6 ISQL options =[e-mail]
4 SET SQLCA statement =[e-mail]
4 SET statement =[e-mail]
4 SIGNAL statement =[e-mail]
4 START DATABASE statement =[e-mail]
4 START ENGINE statement =[e-mail]
4 START SUBSCRIPTION statement =[e-mail]
4 STOP DATABASE statement =[e-mail]
4 STOP ENGINE statement =[e-mail]
4 STOP SUBSCRIPTION statement =[e-mail]
4 SYNCHRONIZE SUBSCRIPTION statement =[e-mail]
4 SYSTEM statement =[e-mail]
4 TRUNCATE TABLE statement =[e-mail]
4 UNION operation =[e-mail]
4 UNLOAD TABLE statement =[e-mail]
4 UPDATE statement =[e-mail]
4 UPDATE (positioned) statement =[e-mail]
4 VALIDATE TABLE statement =[e-mail]
4 WHENEVER statement =[e-mail]
3 SQL Anywhere Database Error Messages
4 SQL Anywhere Database Error Messages =[e-mail]
4 Error message index by SQLCODE =[e-mail]
4 Error messages index by SQLSTATE =[e-mail]
4 Alphabetic list of error messages
5 Alphabetic list of error messages =[e-mail]
5 (no message) =[e-mail]
5 A parameter to an external function is an unsupported datatype =[e-mail]
5 A thread used internally could not be started =[e-mail]
5 Aggregate functions not allowed on this statement =[e-mail]
5 All threads are blocked =[e-mail]
5 ALTER clause conflict =[e-mail]
5 An argument passed to a SQL Anywhere HLI function was invalid =[e-mail]
5 Attempted two active database requests =[e-mail]
5 Authentication violation =[e-mail]
5 Calling functions outside the database engine is not supported =[e-mail]
5 Can only describe a SELECT statement =[e-mail]
5 Cannot alter a column in an index =[e-mail]
5 Cannot be started -- %1 =[e-mail]
5 Cannot convert %1 to a %2 =[e-mail]
5 Cannot delete a column referenced in a trigger definition =[e-mail]
5 Cannot drop a user that owns messages or datatypes =[e-mail]
5 Cannot drop a user that owns procedures in runtime engine =[e-mail]
5 Cannot drop a user that owns tables in runtime engine =[e-mail]
5 Cannot find index named '%1' =[e-mail]
5 Cannot modify column '%1' in table '%2' =[e-mail]
5 Cannot open log file %1 =[e-mail]
5 Cannot outer join a view with a UNION or GROUP BY =[e-mail]
5 Cannot uniquely identify rows in cursor =[e-mail]
5 Cannot update an expression =[e-mail]
5 CHECKPOINT command requires a rollback log =[e-mail]
5 Client/server communications protocol mismatch =[e-mail]
5 Column %1 in foreign key has a different definition than primary key =[e-mail]
5 Column '%1' found in more than one table -- need a correlation name =[e-mail]
5 Column '%1' in table '%2' cannot be NULL =[e-mail]
5 Column '%1' not found =[e-mail]
5 COMMIT/ROLLBACK not allowed within atomic operation =[e-mail]
5 COMMIT/ROLLBACK not allowed within trigger actions =[e-mail]
5 Communication buffer underflow =[e-mail]
5 Communication error =[e-mail]
5 Connection not found =[e-mail]
5 Connection was terminated =[e-mail]
5 Connections to database have been disabled =[e-mail]
5 Correlation name '%1' not found =[e-mail]
5 Could not allocate resources to call external function =[e-mail]
5 Could not find the named function in the dynamic library =[e-mail]
5 Could not load the dynamic library =[e-mail]
5 Cursor already open =[e-mail]
5 Cursor has not been declared =[e-mail]
5 Cursor not open =[e-mail]
5 Cursor operation conflict =[e-mail]
5 Data definition statements not allowed in procedures or triggers =[e-mail]
5 Database backup not started =[e-mail]
5 Database engine already running =[e-mail]
5 Database engine not running =[e-mail]
5 Database engine not running in multi-user mode =[e-mail]
5 Database name not unique =[e-mail]
5 Database name required to start engine =[e-mail]
5 Database was initialized with an older version of the software =[e-mail]
5 Database's page size too big =[e-mail]
5 Dblib/database engine version mismatch =[e-mail]
5 Dbspace '%1' not found =[e-mail]
5 Deadlock detected =[e-mail]
5 Disallowed language extension detected in syntax near '%1' =[e-mail]
5 Disk full -- transaction rolled back =[e-mail]
5 Division by zero =[e-mail]
5 Do not have permission to %1 =[e-mail]
5 Duplicate insert column =[e-mail]
5 Duplicate referencing column =[e-mail]
5 Dynamic memory exhausted! =[e-mail]
5 Error inserting into cursor =[e-mail]
5 Error number %1 for RAISERROR is less than 17000 =[e-mail]
5 Error opening cursor =[e-mail]
5 Error writing to log file =[e-mail]
5 Feature '%1' not implemented =[e-mail]
5 Foreign key '%1' for table '%2' duplicates an existing foreign key =[e-mail]
5 Foreign key name '%1' not found =[e-mail]
5 Format string argument number %1 is invalid =[e-mail]
5 Function or column reference to '%1' in the select list must also appear in a GROUP BY =[e-mail]
5 GRANT of column permission on view not allowed =[e-mail]
5 I/O error %1 -- transaction rolled back =[e-mail]
5 Identifier '%1' too long =[e-mail]
5 Incomplete transactions prevent transaction log renaming =[e-mail]
5 Index '%1' for table '%2' would not be unique =[e-mail]
5 Index name '%1' not unique =[e-mail]
5 INSERT/DELETE on cursor can modify only one table =[e-mail]
5 Internal database error %1 -- transaction rolled back =[e-mail]
5 Invalid absolute or relative offset in FETCH =[e-mail]
5 Invalid column number =[e-mail]
5 Invalid data conversion =[e-mail]
5 Invalid database engine command line =[e-mail]
5 Invalid datatype for column in WRITETEXT or READTEXT =[e-mail]
5 Invalid escape character '%1' =[e-mail]
5 Invalid escape sequence '%1' =[e-mail]
5 Invalid expression near '%1' =[e-mail]
5 Invalid host variable =[e-mail]
5 Invalid local database switch =[e-mail]
5 Invalid operation for this cursor =[e-mail]
5 Invalid option '%1' -- no PUBLIC setting exists =[e-mail]
5 Invalid parameter =[e-mail]
5 Invalid prepared statement type =[e-mail]
5 Invalid REFERENCES clause in trigger definition =[e-mail]
5 Invalid setting for option '%1' =[e-mail]
5 Invalid SQL Anywhere HLI callback function =[e-mail]
5 Invalid SQL Anywhere HLI command syntax =[e-mail]
5 Invalid SQL Anywhere HLI cursor name =[e-mail]
5 Invalid SQL Anywhere HLI host variable name =[e-mail]
5 Invalid SQL Anywhere HLI host variable value =[e-mail]
5 Invalid SQL Anywhere HLI statement name =[e-mail]
5 Invalid statement =[e-mail]
5 Invalid TEXTPTR value used with WRITETEXT or READTEXT =[e-mail]
5 Invalid type on DESCRIBE statement =[e-mail]
5 Invalid userid and password on preprocessed module =[e-mail]
5 Invalid userid or password =[e-mail]
5 Invalid value for column '%1' in table '%2' =[e-mail]
5 Item '%1' already exists =[e-mail]
5 Label '%1' not found =[e-mail]
5 Language extension =[e-mail]
5 Language extension detected in syntax =[e-mail]
5 Mismatch between external function platform specifier and current operating system =[e-mail]
5 More than one table is identified as '%1' =[e-mail]
5 Need a dynamic library name =[e-mail]
5 No current row of cursor =[e-mail]
5 No indicator variable provided for NULL result =[e-mail]
5 No primary key value for foreign key '%1' in table '%2' =[e-mail]
5 Not allowed while %1 is using the database =[e-mail]
5 Not connected to SQL database =[e-mail]
5 Not enough fields allocated in SQLDA =[e-mail]
5 Not enough memory to start =[e-mail]
5 Not enough values for host variables =[e-mail]
5 Null value eliminated in aggregate function =[e-mail]
5 Number in ORDER BY is too large =[e-mail]
5 Number of columns does not match SELECT =[e-mail]
5 Operation would cause a group cycle =[e-mail]
5 Parameter '%1' not found in procedure '%2' =[e-mail]
5 Parameter name missing in call to procedure '%1' =[e-mail]
5 Passthrough statement inconsistent with current passthrough =[e-mail]
5 Primary key column '%1' already defined =[e-mail]
5 Primary key for row in table '%1' is referenced in another table =[e-mail]
5 Primary key for table '%1' is not unique =[e-mail]
5 Procedure '%1' not found =[e-mail]
5 Procedure has completed =[e-mail]
5 Procedure in use =[e-mail]
5 Procedure or trigger calls have nested too deeply =[e-mail]
5 Publication '%1' not found =[e-mail]
5 RAISERROR executed:  %1 =[e-mail]
5 Remote message type '%1' not found =[e-mail]
5 Remote statement failed =[e-mail]
5 Request denied -- no active databases =[e-mail]
5 Request to start/stop database denied =[e-mail]
5 Result set not allowed from within an atomic compound statement =[e-mail]
5 Right truncation of string data =[e-mail]
5 ROLLBACK TO SAVEPOINT not allowed =[e-mail]
5 Row has been updated since last time read =[e-mail]
5 Row has changed since last read -- operation cancelled =[e-mail]
5 Row not found =[e-mail]
5 Run time SQL error  --  %1 =[e-mail]
5 Savepoint '%1' not found =[e-mail]
5 Savepoints require a rollback log =[e-mail]
5 SELECT lists in UNION do not match in length =[e-mail]
5 SELECT returns more than one row =[e-mail]
5 Server/database engine version mismatch =[e-mail]
5 Specified database is invalid =[e-mail]
5 Specified database not found =[e-mail]
5 SQL Anywhere HLI internal error =[e-mail]
5 SQL statement error =[e-mail]
5 Sqlpp/dblib version mismatch =[e-mail]
5 Statement interrupted by user =[e-mail]
5 Subquery allowed only one select list item =[e-mail]
5 Subquery cannot return more than one result =[e-mail]
5 Subscription to '%1' for '%2' already exists =[e-mail]
5 Subscription to '%1' for '%2' not found =[e-mail]
5 Syntax error near '%1' =[e-mail]
5 Table '%1' has no primary key =[e-mail]
5 Table '%1' has publications =[e-mail]
5 Table '%1' is in an outer join cycle =[e-mail]
5 Table '%1' not found =[e-mail]
5 Table '%1' requires a unique correlation name =[e-mail]
5 Table already has a primary key =[e-mail]
5 Table cannot have two primary keys =[e-mail]
5 Table in use =[e-mail]
5 Table must be empty =[e-mail]
5 Terminated by user -- transaction rolled back =[e-mail]
5 The selected database is currently inactive =[e-mail]
5 The supplied buffer was too small to hold all requested query results =[e-mail]
5 There are still active database connections =[e-mail]
5 There is already a variable named '%1' =[e-mail]
5 There is more than one way to join '%1' to '%2' =[e-mail]
5 There is no way to join '%1' to '%2' =[e-mail]
5 Too many columns in table =[e-mail]
5 Too many connections to database =[e-mail]
5 Too many parameters to this external procedure call =[e-mail]
5 Transact SQL feature not supported =[e-mail]
5 Trigger '%1' not found =[e-mail]
5 Trigger definition conflicts with existing triggers =[e-mail]
5 Triggers and procedures not supported in desktop engine =[e-mail]
5 Unable to delete database file =[e-mail]
5 Unable to find in index '%1' for table '%2' =[e-mail]
5 Unable to start database engine =[e-mail]
5 Unable to start specified database =[e-mail]
5 Unknown backup operation =[e-mail]
5 Unknown function '%1' =[e-mail]
5 Unterminated C string =[e-mail]
5 Update operation attempted on a read-only cursor =[e-mail]
5 Update operation attempted on non-updatable query =[e-mail]
5 User '%1' already has grant permission =[e-mail]
5 User '%1' has the row in '%2' locked =[e-mail]
5 User '%1' is already the publisher for this database =[e-mail]
5 User '%1' is not a remote user for this database =[e-mail]
5 User '%1' is not a user group =[e-mail]
5 User message %1 already exists =[e-mail]
5 User message %1 not found =[e-mail]
5 User-defined exception signalled =[e-mail]
5 User-defined type %1 not found =[e-mail]
5 Userid '%1' does not exist =[e-mail]
5 Using temporary table =[e-mail]
5 Value %1 out of range for destination =[e-mail]
5 Value for column '%1' in table '%2' has changed =[e-mail]
5 Value truncated =[e-mail]
5 Variable '%1' not found =[e-mail]
5 Warning =[e-mail]
5 WITH CHECK OPTION violated for view '%1' =[e-mail]
5 Wrong number of parameters to function '%1' =[e-mail]
5 Wrong number of values for INSERT =[e-mail]
5 Wrong number of variables in FETCH =[e-mail]
3 Internal errors (assertion failed) =[e-mail]
3 SQL Preprocessor Error Messages
4 SQL Preprocessor Error Messages =[e-mail]
4 SQLPP errors
5 SQLPP errors =[e-mail]
5 subscript value %ld too large =[e-mail]
5 combined pointer and arrays not supported for hosttypes =[e-mail]
5 only one dimensional arrays supported for char type =[e-mail]
5 VARCHAR type must have a length =[e-mail]
5 arrays of VARCHAR not supported =[e-mail]
5 VARCHAR host variables cannot be pointers =[e-mail]
5 initializer not allowed on VARCHAR host variable =[e-mail]
5 FIXCHAR type must have a length =[e-mail]
5 arrays of FIXCHAR not supported =[e-mail]
5 arrays of int not supported =[e-mail]
5 precision must be specified for decimal type =[e-mail]
5 arrays of decimal not allowed =[e-mail]
5 Unknown hostvar type =[e-mail]
5 invalid integer =[e-mail]
5 '%s' host variable must be a C string type =[e-mail]
5 '%s' symbol already defined =[e-mail]
5 invalid type for sql statement variable =[e-mail]
5 Cannot find include file '%s' =[e-mail]
5 host variable '%s' is unknown =[e-mail]
5 indicator variable '%s' is unknown =[e-mail]
5 invalid type for indicator variable '%s' =[e-mail]
5 invalid host variable type on '%s' =[e-mail]
5 host variable '%s' has two different definitions =[e-mail]
5 statement '%s' not previously prepared =[e-mail]
5 cursor '%s' not previously declared =[e-mail]
5 unknown statement '%s' =[e-mail]
5 host variables not allowed for this cursor =[e-mail]
5 host variables specified twice - on declare and open =[e-mail]
5 must specify a host list or using clause on %s =[e-mail]
5 no INTO clause on SELECT statement =[e-mail]
5 incorrect Embedded SQL syntax =[e-mail]
5 missing ending quote of string =[e-mail]
5 token too long =[e-mail]
5 '%s' host variable must be an integer type =[e-mail]
4 SQLPP warnings
5 SQLPP warnings =[e-mail]
5 Into clause not allowed on declare cursor - ignored =[e-mail]
5 unrecognized SQL syntax =[e-mail]
5 unknown sql function '%s' =[e-mail]
5 wrong number of parms to sql function '%s' =[e-mail]
5 static statement names will not work properly if used by 2 threads =[e-mail]
3 Differences from Other SQL Dialects
4 Differences from Other SQL Dialects =[e-mail]
4 SQL Anywhere features =[e-mail]
2 SQL Anywhere Limitations  =[e-mail]
3 SQL Anywhere Keywords
4 SQL Anywhere Keywords =[e-mail]
4 Alphabetical list of keywords =[e-mail]
3 SQL Anywhere System Procedures and Functions
4 SQL Anywhere System Procedures and Functions =[e-mail]
4 System procedure overview =[e-mail]
4 Catalog stored procedures =[e-mail]
4 System extended stored procedures
5 System extended stored procedures =[e-mail]
5 MAPI system extended stored procedures
6 MAPI system extended stored procedures =[e-mail]
6 xp_startmail system procedure =[e-mail]
6 xp_sendmail system procedure =[e-mail]
6 xp_stopmail system procedure =[e-mail]
5 Other system extended stored procedures
6 Other system extended stored procedures =[e-mail]
6 xp_cmdshell system procedure =[e-mail]
6 xp_sprintf system procedure =[e-mail]
6 xp_scanf system procedure =[e-mail]
3 SQL Anywhere System Tables
4 SQL Anywhere System Tables =[e-mail]
4 System tables diagram =[e-mail]
4 Alphabetical list of system tables
5 Alphabetical list of system tables =[e-mail]
5 DUMMY system table =[e-mail]
5 SYSARTICLE system table =[e-mail]
5 SYSARTICLECOL system table =[e-mail]
5 SYSCOLLATE system table =[e-mail]
5 SYSCOLPERM system table =[e-mail]
5 SYSCOLUMN system table =[e-mail]
5 SYSDOMAIN system table =[e-mail]
5 SYSFILE system table =[e-mail]
5 SYSFKCOL system table =[e-mail]
5 SYSFOREIGNKEY system table =[e-mail]
5 SYSGROUP system table =[e-mail]
5 SYSINDEX system table =[e-mail]
5 SYSINFO system table =[e-mail]
5 SYSIXCOL system table =[e-mail]
5 SYSOPTION system table =[e-mail]
5 SYSPROCEDURE system table =[e-mail]
5 SYSPROCPARM system table =[e-mail]
5 SYSPROCPERM system table =[e-mail]
5 SYSPUBLICATION system table =[e-mail]
5 SYSREMOTEUSER system table =[e-mail]
5 SYSSUBSCRIPTION system table =[e-mail]
5 SYSTABLE system table =[e-mail]
5 SYSTABLEPERM system table =[e-mail]
5 SYSTRIGGER system table =[e-mail]
5 SYSUSERMESSAGES system table =[e-mail]
5 SYSUSERPERM system table =[e-mail]
5 SYSUSERTYPE system table =[e-mail]
3 SQL Anywhere System Views
4 SQL Anywhere System Views =[e-mail]
4 Alphabetical list of views
5 Alphabetical list of views =[e-mail]
5 SYS.SYSCATALOG =[e-mail]
5 SYS.SYSCOLAUTH =[e-mail]
5 SYS.SYSCOLUMNS =[e-mail]
5 SYS.SYSFOREIGNKEYS =[e-mail]
5 SYS.SYSGROUPS =[e-mail]
5 SYS.SYSINDEXES =[e-mail]
5 SYS.SYSOPTIONS =[e-mail]
5 SYS.SYSPROCPARMS =[e-mail]
5 SYS.SYSREMOTEUSERS =[e-mail]
5 SYS.SYSTABAUTH =[e-mail]
5 SYS.SYSTRIGGERS =[e-mail]
5 SYS.SYSUSERAUTH =[e-mail]
5 SYS.SYSUSERLIST =[e-mail]
5 SYS.SYSUSEROPTIONS =[e-mail]
5 SYS.SYSUSERPERMS =[e-mail]
5 SYS.SYSVIEWS =[e-mail]
:include servnt.cnt