PC World 1998 October/PCWorld_1998-10_cd.bin/software/prehled/komix/DATA.Z/dbeng50w.cnt

Microsoft Windows Help File Content | 1997-05-27 | 91KB | 1,719 lines

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