: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 =HDK3B9ACA50@dbeng50w.hlp 2 Introduction to SQL Anywhere 5.0 3 Introduction to SQL Anywhere 5.0 =HDK3B9ACA60@dbeng50w.hlp 3 New Features in SQL Anywhere 5.0 4 New Features in SQL Anywhere 5.0 =HDK3B9ACA70@dbeng50w.hlp 4 What's in a name? =HDK3B9ACA80@dbeng50w.hlp 4 New features overview =HDK3B9ACA90@dbeng50w.hlp 4 New features in the Watcom-SQL language =HDK3B9ACAA0@dbeng50w.hlp 4 New sample database =HDK3B9ACAB0@dbeng50w.hlp 3 Overview of SQL Anywhere 4 Overview of SQL Anywhere =HDK3B9ACAC0@dbeng50w.hlp 4 The SQL Anywhere engine and the SQL Anywhere server =HDK3B9ACAD0@dbeng50w.hlp 4 Running SQL Anywhere on a single computer 5 Running SQL Anywhere on a single computer =HDK3B9ACAE0@dbeng50w.hlp 5 The client application =HDK3B9ACAF0@dbeng50w.hlp 5 The SQL Anywhere database engine =HDK3B9ACB00@dbeng50w.hlp 5 The database =HDK3B9ACB10@dbeng50w.hlp 4 Running SQL Anywhere on a network 5 Running SQL Anywhere on a network =HDK3B9ACB20@dbeng50w.hlp 5 SQL Anywhere multiplatform support =HDK3B9ACB30@dbeng50w.hlp 5 Some database terms =HDK3B9ACB40@dbeng50w.hlp 4 Running mixed operating systems on a single computer 5 Running mixed operating systems on a single computer =HDK3B9ACB50@dbeng50w.hlp 5 DOS or Windows client applications on OS/2 =HDK3B9ACB60@dbeng50w.hlp 5 DOS or Windows 3.x clients on Windows 95 or NT =HDK3B9ACB70@dbeng50w.hlp 4 SQL Anywhere programming interfaces 5 SQL Anywhere programming interfaces =HDK3B9ACB80@dbeng50w.hlp 5 Low-level programming interfaces =HDK3B9ACB90@dbeng50w.hlp 5 High-level programming interfaces =HDK3B9ACBA0@dbeng50w.hlp 4 The SQL Anywhere programs 5 The SQL Anywhere programs =HDK3B9ACBB0@dbeng50w.hlp 5 The SQL Anywhere database engine and server =HDK3B9ACBC0@dbeng50w.hlp 5 The SQL Anywhere Desktop Runtime database engine =HDK3B9ACBD0@dbeng50w.hlp 5 The SQL Central database management program =HDK3B9ACBE0@dbeng50w.hlp 5 SQL Anywhere administration utilities =HDK3B9ACBF0@dbeng50w.hlp 2 Tutorials 3 Tutorials =HDK3B9ACC00@dbeng50w.hlp 3 Managing Databases with SQL Central 4 Managing Databases with SQL Central =HDK3B9ACC10@dbeng50w.hlp 4 SQL Central and database management =HDK3B9ACC20@dbeng50w.hlp 4 Navigating the main SQL Central window 5 Navigating the main SQL Central window =HDK3B9ACC30@dbeng50w.hlp 5 Start SQL Central =HDK3B9ACC40@dbeng50w.hlp 5 Connecting to a database from SQL Central =HDK3B9ACC50@dbeng50w.hlp 5 Viewing a database schema =HDK3B9ACC60@dbeng50w.hlp 4 Adding a table to a database 5 Adding a table to a database =HDK3B9ACC70@dbeng50w.hlp 5 Create an empty table =HDK3B9ACC80@dbeng50w.hlp 5 Adding a column to a table using Add Column =HDK3B9ACC90@dbeng50w.hlp 5 Dragging a column to a new table =HDK3B9ACCA0@dbeng50w.hlp 5 Creating a primary key =HDK3B9ACCB0@dbeng50w.hlp 5 Deleting tables using SQL Central =HDK3B9ACCC0@dbeng50w.hlp 4 Viewing and editing procedures 5 Viewing and editing procedures =HDK3B9ACCD0@dbeng50w.hlp 5 Viewing a procedure =HDK3B9ACCE0@dbeng50w.hlp 4 Managing users and groups 5 Managing users and groups =HDK3B9ACCF0@dbeng50w.hlp 5 Adding a group to the database =HDK3B9ACD00@dbeng50w.hlp 5 Adding a user to the database =HDK3B9ACD10@dbeng50w.hlp 5 Adding a user to a group =HDK3B9ACD20@dbeng50w.hlp 3 Backing up a database using SQL Central =HDK3B9ACD30@dbeng50w.hlp 4 Using the SQL Central online help 5 Using the SQL Central online help =HDK3B9ACD40@dbeng50w.hlp 5 Using the online help Contents =HDK3B9ACD50@dbeng50w.hlp 5 Using the online help Index =HDK3B9ACD60@dbeng50w.hlp 5 Searching the text of the online help =HDK3B9ACD70@dbeng50w.hlp 3 Using ISQL 4 Using ISQL =HDK3B9ACD80@dbeng50w.hlp 4 The SQL Anywhere program group =HDK3B9ACD90@dbeng50w.hlp 4 Starting SQL Anywhere =HDK3B9ACDA0@dbeng50w.hlp 4 Connecting to the sample database from ISQL =HDK3B9ACDB0@dbeng50w.hlp 4 Accessing Help from ISQL =HDK3B9ACDC0@dbeng50w.hlp 4 The ISQL command window =HDK3B9ACDD0@dbeng50w.hlp 4 Leaving ISQL =HDK3B9ACDE0@dbeng50w.hlp 4 Displaying data in ISQL 5 Displaying data in ISQL =HDK3B9ACDF0@dbeng50w.hlp 5 Scrolling the data window =HDK3B9ACE00@dbeng50w.hlp 3 Command recall in ISQL =HDK3B9ACE10@dbeng50w.hlp 3 Function keys =HDK3B9ACE20@dbeng50w.hlp 3 Canceling an ISQL command =HDK3B9ACE30@dbeng50w.hlp 3 What's next? =HDK3B9ACE40@dbeng50w.hlp 3 Selecting Data from Database Tables 4 Selecting Data from Database Tables =HDK3B9ACE50@dbeng50w.hlp 4 Looking at the information in a table =HDK3B9ACE60@dbeng50w.hlp 4 Ordering query results =HDK3B9ACE70@dbeng50w.hlp 4 Selecting columns from a table =HDK3B9ACE80@dbeng50w.hlp 4 Selecting rows from a table =HDK3B9ACE90@dbeng50w.hlp 4 Comparing dates in queries =HDK3B9ACEA0@dbeng50w.hlp 4 Compound search conditions in the WHERE clause =HDK3B9ACEB0@dbeng50w.hlp 4 Pattern matching in search conditions =HDK3B9ACEC0@dbeng50w.hlp 4 Matching rows by sound =HDK3B9ACED0@dbeng50w.hlp 4 Short cuts for typing search conditions =HDK3B9ACEE0@dbeng50w.hlp 3 Joining Tables 4 Joining Tables =HDK3B9ACEF0@dbeng50w.hlp 4 Displaying a list of tables =HDK3B9ACF00@dbeng50w.hlp 4 Joining tables with the cross product =HDK3B9ACF10@dbeng50w.hlp 4 Restricting a join =HDK3B9ACF20@dbeng50w.hlp 4 How tables are related 5 How tables are related =HDK3B9ACF30@dbeng50w.hlp 5 Rows are identified by a primary key =HDK3B9ACF40@dbeng50w.hlp 5 Tables are related by a foreign key =HDK3B9ACF50@dbeng50w.hlp 4 Join operators 5 Join operators =HDK3B9ACF60@dbeng50w.hlp 5 Joining tables using key joins =HDK3B9ACF70@dbeng50w.hlp 5 Joining tables using natural joins =HDK3B9ACF80@dbeng50w.hlp 3 Obtaining Aggregate Data 4 Obtaining Aggregate Data =HDK3B9ACF90@dbeng50w.hlp 4 A first look at aggregate functions =HDK3B9ACFA0@dbeng50w.hlp 4 Using aggregate functions to obtain grouped data =HDK3B9ACFB0@dbeng50w.hlp 4 Restricting groups =HDK3B9ACFC0@dbeng50w.hlp 3 Updating the Database 4 Updating the Database =HDK3B9ACFD0@dbeng50w.hlp 4 Adding rows to a table =HDK3B9ACFE0@dbeng50w.hlp 4 Modifying rows in a table =HDK3B9ACFF0@dbeng50w.hlp 4 Canceling changes =HDK3B9AD000@dbeng50w.hlp 4 Making changes permanent =HDK3B9AD010@dbeng50w.hlp 4 Deleting rows =HDK3B9AD020@dbeng50w.hlp 4 Validity checking 5 Validity checking =HDK3B9AD030@dbeng50w.hlp 5 Inserting duplicate data =HDK3B9AD040@dbeng50w.hlp 5 Inserting incorrect values =HDK3B9AD050@dbeng50w.hlp 5 Errors on DELETE or UPDATE =HDK3B9AD060@dbeng50w.hlp 3 Introduction to Views 4 Introduction to Views =HDK3B9AD070@dbeng50w.hlp 4 Defining a view =HDK3B9AD080@dbeng50w.hlp 4 Using views for security =HDK3B9AD090@dbeng50w.hlp 3 Introduction to Subqueries 4 Introduction to Subqueries =HDK3B9AD0A0@dbeng50w.hlp 4 Preparing to use subqueries =HDK3B9AD0B0@dbeng50w.hlp 4 A simple subquery =HDK3B9AD0C0@dbeng50w.hlp 4 Comparisons using subqueries =HDK3B9AD0D0@dbeng50w.hlp 4 Using subqueries instead of joins =HDK3B9AD0E0@dbeng50w.hlp 3 Command Files 4 Command Files =HDK3B9AD0F0@dbeng50w.hlp 4 Entering multiple statements in the ISQL Command window =HDK3B9AD100@dbeng50w.hlp 4 Saving statements as command files =HDK3B9AD110@dbeng50w.hlp 4 Command files with parameters =HDK3B9AD120@dbeng50w.hlp 3 System Tables 4 System Tables =HDK3B9AD130@dbeng50w.hlp 4 The SYSCATALOG table =HDK3B9AD140@dbeng50w.hlp 4 The SYSCOLUMNS table =HDK3B9AD150@dbeng50w.hlp 4 Other system tables =HDK3B9AD160@dbeng50w.hlp 2 Using SQL Anywhere 3 Using SQL Anywhere =HDK3B9AD170@dbeng50w.hlp 3 Connecting to a Database 4 Connecting to a Database =HDK3B9AD180@dbeng50w.hlp 4 Connection overview 5 Connection overview =HDK3B9AD190@dbeng50w.hlp 5 Database connection parameters =HDK3B9AD1A0@dbeng50w.hlp 5 Connection keyword meanings =HDK3B9AD1B0@dbeng50w.hlp 5 How client applications connect to a database =HDK3B9AD1C0@dbeng50w.hlp 3 Connecting from the SQL Anywhere utilities =HDK3B9AD1D0@dbeng50w.hlp 4 Connecting from an ODBC-enabled application 5 Connecting from an ODBC-enabled application =HDK3B9AD1E0@dbeng50w.hlp 5 SQL Anywhere support for ODBC =HDK3B9AD1F0@dbeng50w.hlp 5 Using ODBC under Windows and Windows NT =HDK3B9AD200@dbeng50w.hlp 5 Files needed for ODBC connections =HDK3B9AD210@dbeng50w.hlp 5 Working with ODBC data sources =HDK3B9AD220@dbeng50w.hlp 5 Using the ODBC Administrator =HDK3B9AD230@dbeng50w.hlp 5 Adding an ODBC data source =HDK3B9AD240@dbeng50w.hlp 5 Some sample ODBC data sources =HDK3B9AD250@dbeng50w.hlp 5 Modifying an existing ODBC data source =HDK3B9AD260@dbeng50w.hlp 5 Removing an ODBC data source =HDK3B9AD270@dbeng50w.hlp 5 Using ODBC under OS/2 =HDK3B9AD280@dbeng50w.hlp 5 Using ODBC under DOS and QNX =HDK3B9AD290@dbeng50w.hlp 3 Designing Your Database 4 Designing Your Database =HDK3B9AD2A0@dbeng50w.hlp 4 Relational database concepts 5 Relational database concepts =HDK3B9AD2B0@dbeng50w.hlp 5 Database tables =HDK3B9AD2C0@dbeng50w.hlp 5 Keys in relational databases =HDK3B9AD2D0@dbeng50w.hlp 5 Each table has a primary key =HDK3B9AD2E0@dbeng50w.hlp 5 Tables are related by foreign keys =HDK3B9AD2F0@dbeng50w.hlp 5 Other database objects =HDK3B9AD300@dbeng50w.hlp 3 Planning the database =HDK3B9AD310@dbeng50w.hlp 4 The design process 5 The design process =HDK3B9AD320@dbeng50w.hlp 5 Step 1: identify entities and relationships =HDK3B9AD330@dbeng50w.hlp 5 Entity and relationship example =HDK3B9AD340@dbeng50w.hlp 5 Step 2: identify the required data =HDK3B9AD350@dbeng50w.hlp 5 Step 3: normalize the data =HDK3B9AD360@dbeng50w.hlp 5 Step 4: resolve the relationships =HDK3B9AD370@dbeng50w.hlp 5 Step 5: verify the design =HDK3B9AD380@dbeng50w.hlp 4 Designing the database table properties 5 Designing the database table properties =HDK3B9AD390@dbeng50w.hlp 5 Choosing column names =HDK3B9AD3A0@dbeng50w.hlp 5 Choosing data types for columns =HDK3B9AD3B0@dbeng50w.hlp 5 Choosing constraints =HDK3B9AD3C0@dbeng50w.hlp 5 Choosing primary and foreign keys =HDK3B9AD3D0@dbeng50w.hlp 3 Working with Database Objects 4 Working with Database Objects =HDK3B9AD3E0@dbeng50w.hlp 4 Using SQL Central to work with database objects =HDK3B9AD3F0@dbeng50w.hlp 4 Using ISQL to work with database objects =HDK3B9AD400@dbeng50w.hlp 4 Working with databases 5 Working with databases =HDK3B9AD410@dbeng50w.hlp 5 Initializing a database =HDK3B9AD420@dbeng50w.hlp 5 Adding database files =HDK3B9AD430@dbeng50w.hlp 5 Preallocating space for database files =HDK3B9AD440@dbeng50w.hlp 5 Erasing a database =HDK3B9AD450@dbeng50w.hlp 4 Working with tables 5 Working with tables =HDK3B9AD460@dbeng50w.hlp 5 Creating tables =HDK3B9AD470@dbeng50w.hlp 5 Altering tables =HDK3B9AD480@dbeng50w.hlp 5 Deleting tables =HDK3B9AD490@dbeng50w.hlp 5 Creating primary and foreign keys =HDK3B9AD4A0@dbeng50w.hlp 5 Table information in the system tables =HDK3B9AD4B0@dbeng50w.hlp 4 Working with views 5 Working with views =HDK3B9AD4C0@dbeng50w.hlp 5 Creating views =HDK3B9AD4D0@dbeng50w.hlp 5 Using views =HDK3B9AD4E0@dbeng50w.hlp 5 Using the WITH CHECK OPTION clause =HDK3B9AD4F0@dbeng50w.hlp 5 Modifying views =HDK3B9AD500@dbeng50w.hlp 5 Permissions on views =HDK3B9AD510@dbeng50w.hlp 5 Deleting views =HDK3B9AD520@dbeng50w.hlp 5 Views in the system tables =HDK3B9AD530@dbeng50w.hlp 4 Working with indexes 5 Working with indexes =HDK3B9AD540@dbeng50w.hlp 5 Indexes in the system tables =HDK3B9AD550@dbeng50w.hlp 3 Ensuring Data Integrity 4 Ensuring Data Integrity =HDK3B9AD560@dbeng50w.hlp 4 Data integrity overview 5 Data integrity overview =HDK3B9AD570@dbeng50w.hlp 5 How data can become invalid =HDK3B9AD580@dbeng50w.hlp 5 Integrity constraints belong in the database =HDK3B9AD590@dbeng50w.hlp 5 How database contents get changed =HDK3B9AD5A0@dbeng50w.hlp 5 Data integrity tools in SQL Anywhere =HDK3B9AD5B0@dbeng50w.hlp 5 SQL statements for implementing integrity constraints =HDK3B9AD5C0@dbeng50w.hlp 4 Using column defaults 5 Using column defaults =HDK3B9AD5D0@dbeng50w.hlp 5 Creating column defaults =HDK3B9AD5E0@dbeng50w.hlp 5 Modifying and deleting column defaults =HDK3B9AD5F0@dbeng50w.hlp 5 Working with column defaults in SQL Central =HDK3B9AD600@dbeng50w.hlp 5 Current date and time defaults =HDK3B9AD610@dbeng50w.hlp 5 The user ID default =HDK3B9AD620@dbeng50w.hlp 5 The autoincrement default =HDK3B9AD630@dbeng50w.hlp 5 The NULL default =HDK3B9AD640@dbeng50w.hlp 5 String and number defaults =HDK3B9AD650@dbeng50w.hlp 5 Constant expression defaults =HDK3B9AD660@dbeng50w.hlp 4 Using table and column constraints 5 Using table and column constraints =HDK3B9AD670@dbeng50w.hlp 5 Using CHECK conditions on columns =HDK3B9AD680@dbeng50w.hlp 5 Column CHECK conditions from user-defined data types =HDK3B9AD690@dbeng50w.hlp 5 Working with column constraints in SQL Central =HDK3B9AD6A0@dbeng50w.hlp 5 Using CHECK conditions on tables =HDK3B9AD6B0@dbeng50w.hlp 5 Modifying and deleting CHECK conditions =HDK3B9AD6C0@dbeng50w.hlp 4 Enforcing entity and referential integrity 5 Enforcing entity and referential integrity =HDK3B9AD6D0@dbeng50w.hlp 5 Enforcing entity integrity =HDK3B9AD6E0@dbeng50w.hlp 5 If a client application breaches entity integrity =HDK3B9AD6F0@dbeng50w.hlp 5 Primary keys enforce entity integrity =HDK3B9AD700@dbeng50w.hlp 5 Enforcing referential integrity =HDK3B9AD710@dbeng50w.hlp 5 Foreign keys enforce referential integrity =HDK3B9AD720@dbeng50w.hlp 5 Losing referential integrity =HDK3B9AD730@dbeng50w.hlp 5 If a client application breaches referential integrity =HDK3B9AD740@dbeng50w.hlp 5 Referential integrity actions =HDK3B9AD750@dbeng50w.hlp 5 Referential integrity checking =HDK3B9AD760@dbeng50w.hlp 3 Integrity rules in the system tables =HDK3B9AD770@dbeng50w.hlp 3 Using Transactions and Locks 4 Using Transactions and Locks =HDK3B9AD780@dbeng50w.hlp 4 An overview of transactions 5 An overview of transactions =HDK3B9AD790@dbeng50w.hlp 5 Transactions and data recovery =HDK3B9AD7A0@dbeng50w.hlp 5 Transactions and concurrency =HDK3B9AD7B0@dbeng50w.hlp 5 Three types of inconsistency =HDK3B9AD7C0@dbeng50w.hlp 5 Using locks to ensure consistency =HDK3B9AD7D0@dbeng50w.hlp 3 How locking works =HDK3B9AD7E0@dbeng50w.hlp 4 Isolation levels and consistency 5 Isolation levels and consistency =HDK3B9AD7F0@dbeng50w.hlp 5 Locks and isolation levels =HDK3B9AD800@dbeng50w.hlp 5 Changing the isolation level =HDK3B9AD810@dbeng50w.hlp 4 How SQL Anywhere handles locking conflicts 5 How SQL Anywhere handles locking conflicts =HDK3B9AD820@dbeng50w.hlp 5 Locking conflicts and transaction blocking =HDK3B9AD830@dbeng50w.hlp 5 Transaction blocking and deadlock =HDK3B9AD840@dbeng50w.hlp 4 Choosing an isolation level 5 Choosing an isolation level =HDK3B9AD850@dbeng50w.hlp 5 Typical level 0 transactions =HDK3B9AD860@dbeng50w.hlp 5 Transactions for which no updates are lost =HDK3B9AD870@dbeng50w.hlp 5 Serializable transactions =HDK3B9AD880@dbeng50w.hlp 3 Savepoints within transactions =HDK3B9AD890@dbeng50w.hlp 4 Particular concurrency issues 5 Particular concurrency issues =HDK3B9AD8A0@dbeng50w.hlp 5 Primary key generation =HDK3B9AD8B0@dbeng50w.hlp 5 Data definition statements and concurrency =HDK3B9AD8C0@dbeng50w.hlp 5 Coordinating transactions with multiple database engines =HDK3B9AD8D0@dbeng50w.hlp 4 Transactions and portable computers 5 Transactions and portable computers =HDK3B9AD8E0@dbeng50w.hlp 5 Applying updates from a portable computer =HDK3B9AD8F0@dbeng50w.hlp 5 Distributing applications that do not require server updates =HDK3B9AD900@dbeng50w.hlp 5 Working with large databases on portable computers =HDK3B9AD910@dbeng50w.hlp 3 Using Procedures, Triggers, and Batches 4 Using Procedures, Triggers, and Batches =HDK3B9AD920@dbeng50w.hlp 4 Procedure and trigger overview =HDK3B9AD930@dbeng50w.hlp 4 Benefits of procedures and triggers =HDK3B9AD940@dbeng50w.hlp 4 Introduction to procedures 5 Introduction to procedures =HDK3B9AD950@dbeng50w.hlp 5 Creating procedures =HDK3B9AD960@dbeng50w.hlp 5 Calling procedures =HDK3B9AD970@dbeng50w.hlp 5 Dropping procedures =HDK3B9AD980@dbeng50w.hlp 5 Permissions to execute procedures =HDK3B9AD990@dbeng50w.hlp 5 Returning procedure results in parameters =HDK3B9AD9A0@dbeng50w.hlp 5 Returning procedure results in result sets =HDK3B9AD9B0@dbeng50w.hlp 4 Introduction to user-defined functions 5 Introduction to user-defined functions =HDK3B9AD9C0@dbeng50w.hlp 5 Creating user-defined functions =HDK3B9AD9D0@dbeng50w.hlp 5 Calling user-defined functions =HDK3B9AD9E0@dbeng50w.hlp 5 Dropping user-defined functions =HDK3B9AD9F0@dbeng50w.hlp 5 Permissions to execute user-defined functions =HDK3B9ADA00@dbeng50w.hlp 4 Introduction to triggers 5 Introduction to triggers =HDK3B9ADA10@dbeng50w.hlp 5 Creating triggers =HDK3B9ADA20@dbeng50w.hlp 5 Executing triggers =HDK3B9ADA30@dbeng50w.hlp 5 Dropping triggers =HDK3B9ADA40@dbeng50w.hlp 5 Trigger execution permissions =HDK3B9ADA50@dbeng50w.hlp 3 Introduction to batches =HDK3B9ADA60@dbeng50w.hlp 4 Control statements 5 Control statements =HDK3B9ADA70@dbeng50w.hlp 5 Using compound statements =HDK3B9ADA80@dbeng50w.hlp 5 Declarations in compound statements =HDK3B9ADA90@dbeng50w.hlp 5 Atomic compound statements =HDK3B9ADAA0@dbeng50w.hlp 4 The structure of procedures and triggers 5 The structure of procedures and triggers =HDK3B9ADAB0@dbeng50w.hlp 5 SQL statements allowed in procedures and triggers =HDK3B9ADAC0@dbeng50w.hlp 5 Declaring procedure parameters =HDK3B9ADAD0@dbeng50w.hlp 5 Passing parameters to procedures =HDK3B9ADAE0@dbeng50w.hlp 5 Passing parameters to functions =HDK3B9ADAF0@dbeng50w.hlp 4 Returning results from procedures 5 Returning results from procedures =HDK3B9ADB00@dbeng50w.hlp 5 Returning a value using the RETURN statement =HDK3B9ADB10@dbeng50w.hlp 5 Returning results as procedure parameters =HDK3B9ADB20@dbeng50w.hlp 5 Returning result sets from procedures =HDK3B9ADB30@dbeng50w.hlp 5 Returning multiple result sets from procedures =HDK3B9ADB40@dbeng50w.hlp 4 Using cursors in procedures and triggers 5 Using cursors in procedures and triggers =HDK3B9ADB50@dbeng50w.hlp 5 Cursor management overview =HDK3B9ADB60@dbeng50w.hlp 5 Using cursors on SELECT statements in procedures =HDK3B9ADB70@dbeng50w.hlp 4 Errors and warnings in procedures and triggers 5 Errors and warnings in procedures and triggers =HDK3B9ADB80@dbeng50w.hlp 5 Default error handling in procedures and triggers =HDK3B9ADB90@dbeng50w.hlp 5 Default handling of warnings in procedures and triggers =HDK3B9ADBA0@dbeng50w.hlp 5 Using exception handlers in procedures and triggers =HDK3B9ADBB0@dbeng50w.hlp 5 Nested compound statements and exception handlers =HDK3B9ADBC0@dbeng50w.hlp 3 Using the EXECUTE IMMEDIATE statement in procedures =HDK3B9ADBD0@dbeng50w.hlp 3 Transactions and savepoints in procedures and triggers =HDK3B9ADBE0@dbeng50w.hlp 4 Some hints for writing procedures 5 Some hints for writing procedures =HDK3B9ADBF0@dbeng50w.hlp 5 Check if you need to change the command delimiter =HDK3B9ADC00@dbeng50w.hlp 5 Remember to delimit statements within your procedure =HDK3B9ADC10@dbeng50w.hlp 5 Use fully-qualified names for tables in procedures =HDK3B9ADC20@dbeng50w.hlp 5 Specifying dates and times in procedures =HDK3B9ADC30@dbeng50w.hlp 5 Verifying that procedure input arguments are passed correctly =HDK3B9ADC40@dbeng50w.hlp 4 Statements allowed in batches 5 Statements allowed in batches =HDK3B9ADC50@dbeng50w.hlp 5 Using SELECT statements in batches =HDK3B9ADC60@dbeng50w.hlp 4 Calling external libraries from stored procedures 5 Calling external libraries from stored procedures =HDK3B9ADC70@dbeng50w.hlp 5 Creating procedures and functions with external calls =HDK3B9ADC80@dbeng50w.hlp 5 External function declarations =HDK3B9ADC90@dbeng50w.hlp 5 How parameters are passed to the external function =HDK3B9ADCA0@dbeng50w.hlp 5 Special considerations when passing character types =HDK3B9ADCB0@dbeng50w.hlp 3 Monitoring and Improving Performance 4 Monitoring and Improving Performance =HDK3B9ADCC0@dbeng50w.hlp 4 Factors affecting database performance =HDK3B9ADCD0@dbeng50w.hlp 4 Using keys to improve query performance 5 Using keys to improve query performance =HDK3B9ADCE0@dbeng50w.hlp 5 Using ISQL to examine query performance =HDK3B9ADCF0@dbeng50w.hlp 5 Using primary keys to improve query performance =HDK3B9ADD00@dbeng50w.hlp 5 Using foreign keys to improve query performance =HDK3B9ADD10@dbeng50w.hlp 4 Using indexes to improve query performance 5 Using indexes to improve query performance =HDK3B9ADD20@dbeng50w.hlp 5 How indexes work =HDK3B9ADD30@dbeng50w.hlp 3 Search strategies for queries from more than one table =HDK3B9ADD40@dbeng50w.hlp 3 Sorting query results =HDK3B9ADD50@dbeng50w.hlp 3 Temporary tables used in query processing =HDK3B9ADD60@dbeng50w.hlp 4 How the optimizer works 5 How the optimizer works =HDK3B9ADD70@dbeng50w.hlp 5 Optimizer estimates =HDK3B9ADD80@dbeng50w.hlp 5 Self tuning of the query optimizer =HDK3B9ADD90@dbeng50w.hlp 5 Providing estimates to improve query performance =HDK3B9ADDA0@dbeng50w.hlp 4 Monitoring database performance 5 Monitoring database performance =HDK3B9ADDB0@dbeng50w.hlp 5 Obtaining database statistics from a client application =HDK3B9ADDC0@dbeng50w.hlp 5 Monitoring database statistics from SQL Central =HDK3B9ADDD0@dbeng50w.hlp 5 Monitoring database statistics from the NT Performance Monitor =HDK3B9ADDE0@dbeng50w.hlp 3 Database Collations 4 Database Collations =HDK3B9ADDF0@dbeng50w.hlp 4 Collation overview 5 Collation overview =HDK3B9ADE00@dbeng50w.hlp 5 Character sets in applications and databases =HDK3B9ADE10@dbeng50w.hlp 5 Character encodings =HDK3B9ADE20@dbeng50w.hlp 5 Displaying your current character settings =HDK3B9ADE30@dbeng50w.hlp 5 Collation sequences =HDK3B9ADE40@dbeng50w.hlp 4 Support for multibyte character sets 5 Support for multibyte character sets =HDK3B9ADE50@dbeng50w.hlp 5 Variable length character sets =HDK3B9ADE60@dbeng50w.hlp 5 First-byte collation orderings =HDK3B9ADE70@dbeng50w.hlp 3 Choosing a character set =HDK3B9ADE80@dbeng50w.hlp 3 Creating custom collations =HDK3B9ADE90@dbeng50w.hlp 4 The collation file format 5 The collation file format =HDK3B9ADEA0@dbeng50w.hlp 5 Comment lines =HDK3B9ADEB0@dbeng50w.hlp 5 The title line =HDK3B9ADEC0@dbeng50w.hlp 5 The collation sequence section =HDK3B9ADED0@dbeng50w.hlp 5 The Encodings section =HDK3B9ADEE0@dbeng50w.hlp 5 The Properties section =HDK3B9ADEF0@dbeng50w.hlp 3 Importing and Exporting Data 4 Importing and Exporting Data =HDK3B9ADF00@dbeng50w.hlp 4 Import and export overview 5 Import and export overview =HDK3B9ADF10@dbeng50w.hlp 5 Input and output data formats =HDK3B9ADF20@dbeng50w.hlp 4 Exporting data from a database 5 Exporting data from a database =HDK3B9ADF30@dbeng50w.hlp 5 Unloading data using the UNLOAD TABLE statement =HDK3B9ADF40@dbeng50w.hlp 5 Exporting data using the ISQL OUTPUT statement =HDK3B9ADF50@dbeng50w.hlp 5 Output redirection =HDK3B9ADF60@dbeng50w.hlp 5 NULL value output =HDK3B9ADF70@dbeng50w.hlp 5 Unloading a database using DBUNLOAD =HDK3B9ADF80@dbeng50w.hlp 4 Importing data into a database 5 Importing data into a database =HDK3B9ADF90@dbeng50w.hlp 5 Loading data using the LOAD TABLE statement =HDK3B9ADFA0@dbeng50w.hlp 5 Importing data using the ISQL INPUT statement =HDK3B9ADFB0@dbeng50w.hlp 5 Loading data interactively =HDK3B9ADFC0@dbeng50w.hlp 5 Handling conversion errors on data import =HDK3B9ADFD0@dbeng50w.hlp 5 Loading data that does not match the table structure =HDK3B9ADFE0@dbeng50w.hlp 3 Tuning bulk operations =HDK3B9ADFF0@dbeng50w.hlp 3 Managing User IDs and Permissions 4 Managing User IDs and Permissions =HDK3B9AE000@dbeng50w.hlp 4 An overview of database permissions 5 An overview of database permissions =HDK3B9AE010@dbeng50w.hlp 5 DBA authority overview =HDK3B9AE020@dbeng50w.hlp 5 Resource authority overview =HDK3B9AE030@dbeng50w.hlp 5 Ownership permissions overview =HDK3B9AE040@dbeng50w.hlp 5 Table and views permissions overview =HDK3B9AE050@dbeng50w.hlp 5 Procedures permissions overview =HDK3B9AE060@dbeng50w.hlp 5 Group permissions overview =HDK3B9AE070@dbeng50w.hlp 4 Managing individual user IDs and permissions 5 Managing individual user IDs and permissions =HDK3B9AE080@dbeng50w.hlp 5 Creating new users =HDK3B9AE090@dbeng50w.hlp 5 Changing a password =HDK3B9AE0A0@dbeng50w.hlp 5 Granting DBA and resource authority =HDK3B9AE0B0@dbeng50w.hlp 5 Granting permissions on tables and views =HDK3B9AE0C0@dbeng50w.hlp 5 Granting users the right to grant permissions =HDK3B9AE0D0@dbeng50w.hlp 5 Granting permissions on procedures =HDK3B9AE0E0@dbeng50w.hlp 5 Execution permissions of triggers =HDK3B9AE0F0@dbeng50w.hlp 5 Revoking user permissions =HDK3B9AE100@dbeng50w.hlp 4 Managing groups 5 Managing groups =HDK3B9AE110@dbeng50w.hlp 5 Creating groups =HDK3B9AE120@dbeng50w.hlp 5 Granting group membership to users =HDK3B9AE130@dbeng50w.hlp 5 Permissions of groups =HDK3B9AE140@dbeng50w.hlp 5 Referring to tables owned by groups =HDK3B9AE150@dbeng50w.hlp 5 Groups without passwords =HDK3B9AE160@dbeng50w.hlp 5 Special groups =HDK3B9AE170@dbeng50w.hlp 3 Database object names and prefixes =HDK3B9AE180@dbeng50w.hlp 4 Using views and procedures for extra security 5 Using views and procedures for extra security =HDK3B9AE190@dbeng50w.hlp 5 Using views for tailored security =HDK3B9AE1A0@dbeng50w.hlp 5 Using procedures for tailored security =HDK3B9AE1B0@dbeng50w.hlp 3 How SQL Anywhere assesses user permissions =HDK3B9AE1C0@dbeng50w.hlp 3 Users and permissions in the system tables =HDK3B9AE1D0@dbeng50w.hlp 3 Backup and Data Recovery 4 Backup and Data Recovery =HDK3B9AE1E0@dbeng50w.hlp 4 System and media failures =HDK3B9AE1F0@dbeng50w.hlp 4 The SQL Anywhere logs 5 The SQL Anywhere logs =HDK3B9AE200@dbeng50w.hlp 5 The checkpoint log =HDK3B9AE210@dbeng50w.hlp 5 The rollback log =HDK3B9AE220@dbeng50w.hlp 5 The transaction log =HDK3B9AE230@dbeng50w.hlp 5 Converting transaction logs to SQL =HDK3B9AE240@dbeng50w.hlp 4 Using a transaction log mirror 5 Using a transaction log mirror =HDK3B9AE250@dbeng50w.hlp 5 Creating and dropping a transaction log mirror =HDK3B9AE260@dbeng50w.hlp 5 Erasing transaction log mirrors =HDK3B9AE270@dbeng50w.hlp 5 Validating the transaction log on database startup =HDK3B9AE280@dbeng50w.hlp 5 Recovering from a corrupt transaction log or mirror =HDK3B9AE290@dbeng50w.hlp 4 Backing up your database 5 Backing up your database =HDK3B9AE2A0@dbeng50w.hlp 5 Performing a full backup =HDK3B9AE2B0@dbeng50w.hlp 5 Performing an incremental backup =HDK3B9AE2C0@dbeng50w.hlp 3 Recovery from system failure =HDK3B9AE2D0@dbeng50w.hlp 4 Recovery from media failure 5 Recovery from media failure =HDK3B9AE2E0@dbeng50w.hlp 5 Media failure on the database file =HDK3B9AE2F0@dbeng50w.hlp 5 Media failure on the transaction log =HDK3B9AE300@dbeng50w.hlp 5 Recovering uncommitted changes =HDK3B9AE310@dbeng50w.hlp 3 Introduction to SQL Remote Replication 4 Introduction to SQL Remote Replication =HDK3B9AE320@dbeng50w.hlp 4 Introduction to data replication =HDK3B9AE330@dbeng50w.hlp 4 SQL Remote concepts 5 SQL Remote concepts =HDK3B9AE340@dbeng50w.hlp 5 Consolidated and remote databases =HDK3B9AE350@dbeng50w.hlp 5 Message-based replication =HDK3B9AE360@dbeng50w.hlp 5 The Message Agent =HDK3B9AE370@dbeng50w.hlp 5 Publications and subscriptions =HDK3B9AE380@dbeng50w.hlp 5 Remote database users =HDK3B9AE390@dbeng50w.hlp 4 SQL Remote features 5 SQL Remote features =HDK3B9AE3A0@dbeng50w.hlp 5 Transaction log-based replication =HDK3B9AE3B0@dbeng50w.hlp 5 Central administration =HDK3B9AE3C0@dbeng50w.hlp 5 Support for many subscribers =HDK3B9AE3D0@dbeng50w.hlp 5 Economical resource requirements =HDK3B9AE3E0@dbeng50w.hlp 3 Message systems supported by SQL Remote =HDK3B9AE3F0@dbeng50w.hlp 4 Tutorial: setting up SQL Remote using SQL Central 5 Tutorial: setting up SQL Remote using SQL Central =HDK3B9AE400@dbeng50w.hlp 5 Preparing for the SQL Central replication tutorial =HDK3B9AE410@dbeng50w.hlp 4 Set up the consolidated database in SQL Central 5 Set up the consolidated database in SQL Central =HDK3B9AE420@dbeng50w.hlp 5 Add a SQL Remote message type =HDK3B9AE430@dbeng50w.hlp 5 Add the publisher and remote user to the database =HDK3B9AE440@dbeng50w.hlp 5 Add publications and subscriptions =HDK3B9AE450@dbeng50w.hlp 3 Set up the remote database in SQL Central =HDK3B9AE460@dbeng50w.hlp 4 Tutorial: setting up SQL Remote using ISQL and DBXTRACT 5 Tutorial: setting up SQL Remote using ISQL and DBXTRACT =HDK3B9AE470@dbeng50w.hlp 5 Preparing for the replication tutorial =HDK3B9AE480@dbeng50w.hlp 4 Set up the consolidated database 5 Set up the consolidated database =HDK3B9AE490@dbeng50w.hlp 5 Create a SQL Remote message type =HDK3B9AE4A0@dbeng50w.hlp 5 Grant PUBLISH and REMOTE at the consolidated database =HDK3B9AE4B0@dbeng50w.hlp 5 Create publications and subscriptions =HDK3B9AE4C0@dbeng50w.hlp 4 Set up the remote database 5 Set up the remote database =HDK3B9AE4D0@dbeng50w.hlp 5 Extract the remote database information =HDK3B9AE4E0@dbeng50w.hlp 5 Load the remote database information =HDK3B9AE4F0@dbeng50w.hlp 4 Start replicating data 5 Start replicating data =HDK3B9AE500@dbeng50w.hlp 5 Send data from the consolidated database =HDK3B9AE510@dbeng50w.hlp 5 Receive data at the remote database =HDK3B9AE520@dbeng50w.hlp 5 Replicate from the remote database to the consolidated database =HDK3B9AE530@dbeng50w.hlp 3 A sample publication =HDK3B9AE540@dbeng50w.hlp 4 Some sample SQL Remote setups 5 Some sample SQL Remote setups =HDK3B9AE550@dbeng50w.hlp 5 Server-to-laptop replication for mobile workforces =HDK3B9AE560@dbeng50w.hlp 5 Server-to-server replication among offices =HDK3B9AE570@dbeng50w.hlp 3 SQL Remote Administration 4 SQL Remote Administration =HDK3B9AE580@dbeng50w.hlp 4 SQL Remote administration overview =HDK3B9AE590@dbeng50w.hlp 4 Adding SQL Remote message types =HDK3B9AE5A0@dbeng50w.hlp 4 Managing SQL Remote permissions 5 Managing SQL Remote permissions =HDK3B9AE5B0@dbeng50w.hlp 5 Granting and revoking PUBLISH permissions =HDK3B9AE5C0@dbeng50w.hlp 5 Granting and revoking REMOTE and CONSOLIDATE permissions =HDK3B9AE5D0@dbeng50w.hlp 4 Setting up publications 5 Setting up publications =HDK3B9AE5E0@dbeng50w.hlp 5 Publishing a set of tables =HDK3B9AE5F0@dbeng50w.hlp 5 Publishing a subset of columns =HDK3B9AE600@dbeng50w.hlp 5 Publishing a subset of rows using a WHERE clause =HDK3B9AE610@dbeng50w.hlp 5 Publishing a subset of rows using a SUBSCRIBE BY expression =HDK3B9AE620@dbeng50w.hlp 5 Dropping publications =HDK3B9AE630@dbeng50w.hlp 5 Notes on publications =HDK3B9AE640@dbeng50w.hlp 4 Designing publications 5 Designing publications =HDK3B9AE650@dbeng50w.hlp 5 Replication error and conflict overview =HDK3B9AE660@dbeng50w.hlp 5 Designing to avoid primary key errors =HDK3B9AE670@dbeng50w.hlp 5 Handling UPDATE conflicts =HDK3B9AE680@dbeng50w.hlp 5 Designing to avoid referential integrity errors =HDK3B9AE690@dbeng50w.hlp 5 Designing triggers to avoid errors =HDK3B9AE6A0@dbeng50w.hlp 5 Using subqueries in publications =HDK3B9AE6B0@dbeng50w.hlp 5 SUBSCRIBE BY subqueries returning multiple values =HDK3B9AE6C0@dbeng50w.hlp 3 Setting up subscriptions =HDK3B9AE6D0@dbeng50w.hlp 4 Synchronizing databases 5 Synchronizing databases =HDK3B9AE6E0@dbeng50w.hlp 5 Using the extraction utility to synchronize databases =HDK3B9AE6F0@dbeng50w.hlp 5 Limits to using the extraction utility =HDK3B9AE700@dbeng50w.hlp 5 Synchronizing data over a message system =HDK3B9AE710@dbeng50w.hlp 5 Notes on synchronization =HDK3B9AE720@dbeng50w.hlp 4 How statements are replicated by SQL Remote 5 How statements are replicated by SQL Remote =HDK3B9AE730@dbeng50w.hlp 5 Replication of inserts and deletes =HDK3B9AE740@dbeng50w.hlp 5 Replication of updates =HDK3B9AE750@dbeng50w.hlp 5 Replication of procedures and triggers =HDK3B9AE760@dbeng50w.hlp 5 Replication of procedures =HDK3B9AE770@dbeng50w.hlp 5 Replication of triggers =HDK3B9AE780@dbeng50w.hlp 5 Replication of data definition statements =HDK3B9AE790@dbeng50w.hlp 3 Managing a running SQL Remote setup: overview =HDK3B9AE7A0@dbeng50w.hlp 4 Running the SQL Remote Message Agent 5 Running the SQL Remote Message Agent =HDK3B9AE7B0@dbeng50w.hlp 5 The Message Agent and replication security =HDK3B9AE7C0@dbeng50w.hlp 4 The SQL Remote message tracking system 5 The SQL Remote message tracking system =HDK3B9AE7D0@dbeng50w.hlp 5 Status information in the SYSREMOTEUSER system table =HDK3B9AE7E0@dbeng50w.hlp 5 Tracking messages by transaction log offsets =HDK3B9AE7F0@dbeng50w.hlp 5 Handling of lost or corrupt messages =HDK3B9AE800@dbeng50w.hlp 4 Transaction log and backup management for SQL Remote 5 Transaction log and backup management for SQL Remote =HDK3B9AE810@dbeng50w.hlp 5 Using the DELETE_OLD_LOGS option =HDK3B9AE820@dbeng50w.hlp 5 Backup procedures at remote databases =HDK3B9AE830@dbeng50w.hlp 5 The Unload utility and replication =HDK3B9AE840@dbeng50w.hlp 4 Error reporting and conflict resolution in SQL Remote 5 Error reporting and conflict resolution in SQL Remote =HDK3B9AE850@dbeng50w.hlp 5 Error reporting and conflict resolution =HDK3B9AE860@dbeng50w.hlp 5 Error reporting in the Message Agent output =HDK3B9AE870@dbeng50w.hlp 5 RESOLVE UPDATE triggers =HDK3B9AE880@dbeng50w.hlp 5 UPDATE conflict resolution examples =HDK3B9AE890@dbeng50w.hlp 4 Using passthrough mode for administration 5 Using passthrough mode for administration =HDK3B9AE8A0@dbeng50w.hlp 5 Uses and limitations of passthrough mode =HDK3B9AE8B0@dbeng50w.hlp 3 Running Programs as Windows NT Services 4 Running Programs as Windows NT Services =HDK3B9AE8C0@dbeng50w.hlp 4 Introduction to Windows NT services =HDK3B9AE8D0@dbeng50w.hlp 4 The SQL Anywhere Service Manager 5 The SQL Anywhere Service Manager =HDK3B9AE8E0@dbeng50w.hlp 5 Service Manager polling frequency =HDK3B9AE8F0@dbeng50w.hlp 3 Adding a new SQL Anywhere service =HDK3B9AE900@dbeng50w.hlp 4 Configuring a SQL Anywhere service 5 Configuring a SQL Anywhere service =HDK3B9AE910@dbeng50w.hlp 5 Entering command-line switches =HDK3B9AE920@dbeng50w.hlp 5 Setting the startup option =HDK3B9AE930@dbeng50w.hlp 5 Setting the logon options =HDK3B9AE940@dbeng50w.hlp 5 Changing the executable file =HDK3B9AE950@dbeng50w.hlp 5 Changing the name of a service =HDK3B9AE960@dbeng50w.hlp 5 Adding new databases to a server or engine service =HDK3B9AE970@dbeng50w.hlp 4 Starting and stopping services 5 Starting and stopping services =HDK3B9AE980@dbeng50w.hlp 5 Starting a SQL Anywhere service =HDK3B9AE990@dbeng50w.hlp 5 Stopping a SQL Anywhere service =HDK3B9AE9A0@dbeng50w.hlp 5 Pausing a SQL Anywhere service =HDK3B9AE9B0@dbeng50w.hlp 4 Removing a SQL Anywhere service 5 Removing a SQL Anywhere service =HDK3B9AE9C0@dbeng50w.hlp 5 Possible problems running more than one server service =HDK3B9AE9D0@dbeng50w.hlp 3 Monitoring a SQL Anywhere network server service =HDK3B9AE9E0@dbeng50w.hlp 3 The Windows NT Control Panel Service Manager =HDK3B9AE9F0@dbeng50w.hlp 2 Transact-SQL Compatibility 3 Transact-SQL Compatibility =HDK3B9AEA00@dbeng50w.hlp 3 Using Transact-SQL with SQL Anywhere 4 Using Transact-SQL with SQL Anywhere =HDK3B9AEA10@dbeng50w.hlp 4 An overview of SQL Anywhere support for Transact-SQL =HDK3B9AEA20@dbeng50w.hlp 4 SQL Server and SQL Anywhere architectures 5 SQL Server and SQL Anywhere architectures =HDK3B9AEA30@dbeng50w.hlp 5 Servers and databases in SQL Server and SQL Anywhere =HDK3B9AEA40@dbeng50w.hlp 5 System tables in SQL Anywhere and SQL Server =HDK3B9AEA50@dbeng50w.hlp 5 Administrative roles in SQL Server and SQL Anywhere =HDK3B9AEA60@dbeng50w.hlp 5 Users and groups in SQL Anywhere and SQL Server =HDK3B9AEA70@dbeng50w.hlp 3 General guidelines for writing portable SQL =HDK3B9AEA80@dbeng50w.hlp 4 Configuring SQL Anywhere for Transact-SQL compatibility 5 Configuring SQL Anywhere for Transact-SQL compatibility =HDK3B9AEA90@dbeng50w.hlp 5 Creating a Transact-SQL-compatible database =HDK3B9AEAA0@dbeng50w.hlp 5 Setting options for Transact-SQL compatibility =HDK3B9AEAB0@dbeng50w.hlp 5 Case-sensitivity in SQL Server and SQL Anywhere databases =HDK3B9AEAC0@dbeng50w.hlp 5 Ensuring compatible object names =HDK3B9AEAD0@dbeng50w.hlp 4 Using compatible data types 5 Using compatible data types =HDK3B9AEAE0@dbeng50w.hlp 5 Integer data types =HDK3B9AEAF0@dbeng50w.hlp 5 Decimal data types =HDK3B9AEB00@dbeng50w.hlp 5 Compatibility of character data types =HDK3B9AEB10@dbeng50w.hlp 5 Compatibility of binary data types =HDK3B9AEB20@dbeng50w.hlp 5 Money data types =HDK3B9AEB30@dbeng50w.hlp 5 Bit data type =HDK3B9AEB40@dbeng50w.hlp 5 Compatibility of date and time data types =HDK3B9AEB50@dbeng50w.hlp 5 The special Transact-SQL timestamp column and data type =HDK3B9AEB60@dbeng50w.hlp 5 The special identity column =HDK3B9AEB70@dbeng50w.hlp 5 Compatibility of user-defined data types =HDK3B9AEB80@dbeng50w.hlp 4 Local and global variables 5 Local and global variables =HDK3B9AEB90@dbeng50w.hlp 5 Local variable support =HDK3B9AEBA0@dbeng50w.hlp 5 Global variable support =HDK3B9AEBB0@dbeng50w.hlp 5 Obtaining the values of variables =HDK3B9AEBC0@dbeng50w.hlp 4 Building compatible expressions 5 Building compatible expressions =HDK3B9AEBD0@dbeng50w.hlp 5 Compatibility of constants =HDK3B9AEBE0@dbeng50w.hlp 5 Compatibility of operators =HDK3B9AEBF0@dbeng50w.hlp 4 Using compatible functions 5 Using compatible functions =HDK3B9AEC00@dbeng50w.hlp 5 Compatibility of aggregate functions =HDK3B9AEC10@dbeng50w.hlp 5 Compatibility of numeric functions =HDK3B9AEC20@dbeng50w.hlp 5 Compatibility of string functions =HDK3B9AEC30@dbeng50w.hlp 5 Compatibility of date and time functions =HDK3B9AEC40@dbeng50w.hlp 5 Compatibility of data type conversion functions =HDK3B9AEC50@dbeng50w.hlp 5 Compatibility of miscellaneous functions =HDK3B9AEC60@dbeng50w.hlp 5 Compatibility of text and image functions =HDK3B9AEC70@dbeng50w.hlp 5 Compatibility of system functions =HDK3B9AEC80@dbeng50w.hlp 4 Building compatible search conditions 5 Building compatible search conditions =HDK3B9AEC90@dbeng50w.hlp 5 Compatibility of comparison conditions =HDK3B9AECA0@dbeng50w.hlp 5 Compatibility of comparison operators =HDK3B9AECB0@dbeng50w.hlp 5 Compatibility of BETWEEN and LIKE conditions =HDK3B9AECC0@dbeng50w.hlp 5 Compatibility of IN conditions =HDK3B9AECD0@dbeng50w.hlp 5 Compatibility of ALL and ANY conditions =HDK3B9AECE0@dbeng50w.hlp 5 Compatibility of EXISTS conditions =HDK3B9AECF0@dbeng50w.hlp 5 Compatibility of IS NULL conditions =HDK3B9AED00@dbeng50w.hlp 5 Providing estimates for conditions =HDK3B9AED10@dbeng50w.hlp 5 Conditions using logical operators =HDK3B9AED20@dbeng50w.hlp 4 Other language elements 5 Other language elements =HDK3B9AED30@dbeng50w.hlp 5 Compatible comment indicators =HDK3B9AED40@dbeng50w.hlp 4 Transact-SQL statement reference 5 Transact-SQL statement reference =HDK3B9AED50@dbeng50w.hlp 5 Transact-SQL BEGIN TRANSACTION statement =HDK3B9AED60@dbeng50w.hlp 5 Transact-SQL COMMIT statement =HDK3B9AED70@dbeng50w.hlp 5 Transact-SQL DATABASE statements =HDK3B9AED80@dbeng50w.hlp 5 Transact-SQL CREATE DEFAULT and CREATE RULE statements =HDK3B9AED90@dbeng50w.hlp 5 Transact-SQL CREATE INDEX statement =HDK3B9AEDA0@dbeng50w.hlp 5 Transact-SQL CREATE SCHEMA statement =HDK3B9AEDB0@dbeng50w.hlp 5 Transact-SQL CREATE TABLE statement =HDK3B9AEDC0@dbeng50w.hlp 5 Transact-SQL DELETE statement =HDK3B9AEDD0@dbeng50w.hlp 5 Transact-SQL DISK statements =HDK3B9AEDE0@dbeng50w.hlp 5 Transact-SQL GRANT and REVOKE statements =HDK3B9AEDF0@dbeng50w.hlp 5 Transact-SQL INSERT statement =HDK3B9AEE00@dbeng50w.hlp 5 Transact-SQL joins =HDK3B9AEE10@dbeng50w.hlp 5 Transact-SQL READTEXT statement =HDK3B9AEE20@dbeng50w.hlp 5 Transact-SQL ROLLBACK statement =HDK3B9AEE30@dbeng50w.hlp 5 Transact-SQL SELECT statement =HDK3B9AEE40@dbeng50w.hlp 5 Transact-SQL SET statement =HDK3B9AEE50@dbeng50w.hlp 5 Transact-SQL UPDATE statement =HDK3B9AEE60@dbeng50w.hlp 5 Transact-SQL WRITETEXT statement =HDK3B9AEE70@dbeng50w.hlp 3 Compatible system catalog information =HDK3B9AEE80@dbeng50w.hlp 4 SQL Server system and catalog procedures 5 SQL Server system and catalog procedures =HDK3B9AEE90@dbeng50w.hlp 5 SQL Server system procedures =HDK3B9AEEA0@dbeng50w.hlp 5 SQL Server catalog procedures =HDK3B9AEEB0@dbeng50w.hlp 4 Implicit data type conversion 5 Implicit data type conversion =HDK3B9AEEC0@dbeng50w.hlp 5 Differences in string to datetime conversions =HDK3B9AEED0@dbeng50w.hlp 3 Transact-SQL Procedure Language 4 Transact-SQL Procedure Language =HDK3B9AEEE0@dbeng50w.hlp 4 Transact-SQL procedure language overview 5 Transact-SQL procedure language overview =HDK3B9AEEF0@dbeng50w.hlp 5 Mixing Transact-SQL and Watcom-SQL dialects =HDK3B9AEF00@dbeng50w.hlp 4 Automatic translation of SQL statements 5 Automatic translation of SQL statements =HDK3B9AEF10@dbeng50w.hlp 5 Using SQL Central to translate stored procedures =HDK3B9AEF20@dbeng50w.hlp 3 Transact-SQL stored procedure overview =HDK3B9AEF30@dbeng50w.hlp 3 Transact-SQL trigger overview =HDK3B9AEF40@dbeng50w.hlp 3 Transact-SQL batch overview =HDK3B9AEF50@dbeng50w.hlp 4 Supported Transact-SQL procedure language statements 5 Supported Transact-SQL procedure language statements =HDK3B9AEF60@dbeng50w.hlp 5 Transact-SQL BEGIN ... END statement =HDK3B9AEF70@dbeng50w.hlp 5 Transact-SQL CREATE PROCEDURE statement 6 Transact-SQL CREATE PROCEDURE statement =HDK3B9AEF80@dbeng50w.hlp 6 Comparison of Transact-SQL and Watcom-SQL CREATE PROCEDURE statements =HDK3B9AEF90@dbeng50w.hlp 4 Transact-SQL CREATE TRIGGER statement =HDK3B9AEFA0@dbeng50w.hlp 4 Transact-SQL EXECUTE statement =HDK3B9AEFB0@dbeng50w.hlp 4 Transact-SQL GOTO statement =HDK3B9AEFC0@dbeng50w.hlp 4 Transact-SQL IF statement =HDK3B9AEFD0@dbeng50w.hlp 4 Transact-SQL PRINT statement =HDK3B9AEFE0@dbeng50w.hlp 4 Transact-SQL RAISERROR statement =HDK3B9AEFF0@dbeng50w.hlp 4 The Transact-SQL RETURN statement =HDK3B9AF000@dbeng50w.hlp 4 Transact-SQL WHILE statement =HDK3B9AF010@dbeng50w.hlp 3 Returning result sets from Transact-SQL procedures =HDK3B9AF020@dbeng50w.hlp 4 Variable and cursor declarations 5 Variable and cursor declarations =HDK3B9AF030@dbeng50w.hlp 5 Transact-SQL DECLARE CURSOR statement =HDK3B9AF040@dbeng50w.hlp 5 Transact-SQL DECLARE statement 6 Transact-SQL DECLARE statement =HDK3B9AF050@dbeng50w.hlp 6 Assigning values to variables in Transact-SQL =HDK3B9AF060@dbeng50w.hlp 4 Error handling in Transact-SQL procedures 5 Error handling in Transact-SQL procedures =HDK3B9AF070@dbeng50w.hlp 5 Using the RAISERROR statement in procedures =HDK3B9AF080@dbeng50w.hlp 5 Transact-SQL-like error handling in the Watcom-SQL dialect =HDK3B9AF090@dbeng50w.hlp 3 Using the Open Server Gateway 4 Using the Open Server Gateway =HDK3B9AF0A0@dbeng50w.hlp 4 Open Server Gateway overview =HDK3B9AF0B0@dbeng50w.hlp 4 Open Server Gateway architecture 5 Open Server Gateway architecture =HDK3B9AF0C0@dbeng50w.hlp 5 What you need to use the Open Server Gateway =HDK3B9AF0D0@dbeng50w.hlp 4 Setting up the Open Server Gateway 5 Setting up the Open Server Gateway =HDK3B9AF0E0@dbeng50w.hlp 5 Starting the Open Server Gateway =HDK3B9AF0F0@dbeng50w.hlp 4 Events handled by Open Server Gateway 5 Events handled by Open Server Gateway =HDK3B9AF100@dbeng50w.hlp 5 Standard event handling in Open Server Gateway =HDK3B9AF110@dbeng50w.hlp 2 The SQL Anywhere Programming Interfaces 3 The SQL Anywhere Programming Interfaces =HDK3B9AF120@dbeng50w.hlp 3 Programming Interfaces =HDK3B9AF130@dbeng50w.hlp 3 The Embedded SQL Interface 4 The Embedded SQL Interface =HDK3B9AF140@dbeng50w.hlp 4 The C language SQL preprocessor 5 The C language SQL preprocessor =HDK3B9AF150@dbeng50w.hlp 5 Supported compilers =HDK3B9AF160@dbeng50w.hlp 5 Development process for Windows 3.x and 95, OS/2, or Windows NT =HDK3B9AF170@dbeng50w.hlp 5 Development process for DOS or QNX =HDK3B9AF180@dbeng50w.hlp 5 Running the SQL preprocessor =HDK3B9AF190@dbeng50w.hlp 5 Embedded SQL header files =HDK3B9AF1A0@dbeng50w.hlp 5 Embedded SQL libraries =HDK3B9AF1B0@dbeng50w.hlp 5 A simple example =HDK3B9AF1C0@dbeng50w.hlp 5 Structure of Embedded SQL programs =HDK3B9AF1D0@dbeng50w.hlp 5 Authorization =HDK3B9AF1E0@dbeng50w.hlp 3 Embedded SQL interface data types =HDK3B9AF1F0@dbeng50w.hlp 4 Host variables 5 Host variables =HDK3B9AF200@dbeng50w.hlp 5 Host variable declarations =HDK3B9AF210@dbeng50w.hlp 5 C host variable types =HDK3B9AF220@dbeng50w.hlp 5 Host variable usage =HDK3B9AF230@dbeng50w.hlp 5 Indicator variables =HDK3B9AF240@dbeng50w.hlp 3 The SQL communication area =HDK3B9AF250@dbeng50w.hlp 4 Fetching data 5 Fetching data =HDK3B9AF260@dbeng50w.hlp 5 Embedded SELECT =HDK3B9AF270@dbeng50w.hlp 5 Cursors in Embedded SQL =HDK3B9AF280@dbeng50w.hlp 4 Static vs dynamic SQL 5 Static vs dynamic SQL =HDK3B9AF290@dbeng50w.hlp 5 Static statements =HDK3B9AF2A0@dbeng50w.hlp 5 Dynamic statements =HDK3B9AF2B0@dbeng50w.hlp 5 Dynamic SELECT statement =HDK3B9AF2C0@dbeng50w.hlp 5 Fetching more than one row at a time =HDK3B9AF2D0@dbeng50w.hlp 4 The SQL descriptor area 5 The SQL descriptor area =HDK3B9AF2E0@dbeng50w.hlp 5 Length field values =HDK3B9AF2F0@dbeng50w.hlp 4 SQL procedures in Embedded SQL 5 SQL procedures in Embedded SQL =HDK3B9AF300@dbeng50w.hlp 5 Simple procedures =HDK3B9AF310@dbeng50w.hlp 5 Procedures with result sets =HDK3B9AF320@dbeng50w.hlp 5 Multi-Threaded or Reentrant Code =HDK3B9AF330@dbeng50w.hlp 5 Multiple SQLCAs =HDK3B9AF340@dbeng50w.hlp 5 Connection Management with Multiple SQLCAs =HDK3B9AF350@dbeng50w.hlp 4 Library functions 5 Library functions =HDK3B9AF360@dbeng50w.hlp 5 Interface initialization functions =HDK3B9AF370@dbeng50w.hlp 5 Connection and engine management functions =HDK3B9AF380@dbeng50w.hlp 5 SQLDA management functions =HDK3B9AF390@dbeng50w.hlp 5 Backup functions =HDK3B9AF3A0@dbeng50w.hlp 5 Other functions =HDK3B9AF3B0@dbeng50w.hlp 5 Aborting a request =HDK3B9AF3C0@dbeng50w.hlp 5 Windows 3.x request management =HDK3B9AF3D0@dbeng50w.hlp 5 Multiple SQLCA management =HDK3B9AF3E0@dbeng50w.hlp 5 Memory allocation in DOS and QNX =HDK3B9AF3F0@dbeng50w.hlp 5 DOS interrupt processing and request management =HDK3B9AF400@dbeng50w.hlp 3 Embedded SQL commands =HDK3B9AF410@dbeng50w.hlp 4 Database examples 5 Database examples =HDK3B9AF420@dbeng50w.hlp 5 Building the examples =HDK3B9AF430@dbeng50w.hlp 5 Running the example programs =HDK3B9AF440@dbeng50w.hlp 5 Static cursor example =HDK3B9AF450@dbeng50w.hlp 5 Dynamic cursor example =HDK3B9AF460@dbeng50w.hlp 5 NT Service examples =HDK3B9AF470@dbeng50w.hlp 3 SQLDEF.H header file =HDK3B9AF480@dbeng50w.hlp 3 ODBC Programming 4 ODBC Programming =HDK3B9AF490@dbeng50w.hlp 4 ODBC C language programming 5 ODBC C language programming =HDK3B9AF4A0@dbeng50w.hlp 5 Fundamentals =HDK3B9AF4B0@dbeng50w.hlp 5 Compiling and linking an ODBC application =HDK3B9AF4C0@dbeng50w.hlp 5 A first example =HDK3B9AF4D0@dbeng50w.hlp 5 Error checking =HDK3B9AF4E0@dbeng50w.hlp 5 Cursors in ODBC =HDK3B9AF4F0@dbeng50w.hlp 5 Procedures and triggers in ODBC =HDK3B9AF500@dbeng50w.hlp 5 ODBC conformance =HDK3B9AF510@dbeng50w.hlp 5 The sample program =HDK3B9AF520@dbeng50w.hlp 3 ODBC programming for the Macintosh =HDK3B9AF530@dbeng50w.hlp 3 The WSQL DDE Server 4 The WSQL DDE Server =HDK3B9AF540@dbeng50w.hlp 4 DDE concepts 5 DDE concepts =HDK3B9AF550@dbeng50w.hlp 5 What is DDE? =HDK3B9AF560@dbeng50w.hlp 5 DDE conversations =HDK3B9AF570@dbeng50w.hlp 5 Sending and receiving data and commands using DDE =HDK3B9AF580@dbeng50w.hlp 5 DDE links =HDK3B9AF590@dbeng50w.hlp 4 Using WSQL DDE Server 5 Using WSQL DDE Server =HDK3B9AF5A0@dbeng50w.hlp 5 The WSQL DDE Server window =HDK3B9AF5B0@dbeng50w.hlp 5 Initiating a DDE conversation with WSQL DDE Server =HDK3B9AF5C0@dbeng50w.hlp 5 Communicating with the WSQL DDE Server =HDK3B9AF5D0@dbeng50w.hlp 3 Excel and WSQL DDE Server =HDK3B9AF5E0@dbeng50w.hlp 3 Word and WSQL DDE Server =HDK3B9AF5F0@dbeng50w.hlp 4 Visual Basic and WSQL DDE Server 5 Visual Basic and WSQL DDE Server =HDK3B9AF600@dbeng50w.hlp 5 The test application =HDK3B9AF610@dbeng50w.hlp 5 Running the test application =HDK3B9AF620@dbeng50w.hlp 3 The WSQL HLI Interface 4 The WSQL HLI Interface =HDK3B9AF630@dbeng50w.hlp 4 DLL concepts =HDK3B9AF640@dbeng50w.hlp 4 Using WSQL HLI =HDK3B9AF650@dbeng50w.hlp 4 Host variables with WSQL HLI =HDK3B9AF660@dbeng50w.hlp 4 WSQL HLI functions 5 WSQL HLI functions =HDK3B9AF670@dbeng50w.hlp 5 wsqlexec =HDK3B9AF680@dbeng50w.hlp 5 wsqlgetfield =HDK3B9AF690@dbeng50w.hlp 5 wsqlgetcolumnname =HDK3B9AF6A0@dbeng50w.hlp 5 wsqlquerytomemdelim =HDK3B9AF6B0@dbeng50w.hlp 5 wsqlquerytomem =HDK3B9AF6C0@dbeng50w.hlp 5 wsqllasterror =HDK3B9AF6D0@dbeng50w.hlp 5 wsqlregisterfuncs =HDK3B9AF6E0@dbeng50w.hlp 3 wsqlexec command strings =HDK3B9AF6F0@dbeng50w.hlp 4 WSQL HLI and Visual Basic 5 WSQL HLI and Visual Basic =HDK3B9AF700@dbeng50w.hlp 5 Visual Basic example =HDK3B9AF710@dbeng50w.hlp 5 The sample application =HDK3B9AF720@dbeng50w.hlp 5 Running the sample application =HDK3B9AF730@dbeng50w.hlp 4 WSQL HLI and REXX 5 WSQL HLI and REXX =HDK3B9AF740@dbeng50w.hlp 5 Error codes and messages =HDK3B9AF750@dbeng50w.hlp 5 REXX examples =HDK3B9AF760@dbeng50w.hlp 1 Users Guide Volume II 2 Users Guide Volume II =HDK3B9AF770@dbeng50w.hlp 2 SQL Anywhere Reference 3 SQL Anywhere Reference =HDK3B9AF780@dbeng50w.hlp 3 SQL Anywhere Components 4 SQL Anywhere Components =HDK3B9AF790@dbeng50w.hlp 4 SQL Anywhere components overview =HDK3B9AF7A0@dbeng50w.hlp 4 Environment variables 5 Environment variables =HDK3B9AF7B0@dbeng50w.hlp 5 SQLANY environment variable =HDK3B9AF7C0@dbeng50w.hlp 5 SQLCONNECT environment variable =HDK3B9AF7D0@dbeng50w.hlp 5 SQLPATH environment variable =HDK3B9AF7E0@dbeng50w.hlp 5 SQLREMOTE environment variable =HDK3B9AF7F0@dbeng50w.hlp 5 SQLSTART environment variable =HDK3B9AF800@dbeng50w.hlp 5 TMP environment variable =HDK3B9AF810@dbeng50w.hlp 3 Software component return codes =HDK3B9AF820@dbeng50w.hlp 3 The database engine =HDK3B9AF830@dbeng50w.hlp 4 The Backup utility 5 The Backup utility =HDK3B9AF840@dbeng50w.hlp 5 Backing up a database from SQL Central =HDK3B9AF850@dbeng50w.hlp 5 Backing up a database from the ISQL Tools window =HDK3B9AF860@dbeng50w.hlp 5 Backing up a database using the DBTOOL statement =HDK3B9AF870@dbeng50w.hlp 5 The DBBACKUP command-line utility =HDK3B9AF880@dbeng50w.hlp 5 Backup utility options =HDK3B9AF890@dbeng50w.hlp 4 The Collation utility 5 The Collation utility =HDK3B9AF8A0@dbeng50w.hlp 5 Extracting a collation in the ISQL Database Tools window =HDK3B9AF8B0@dbeng50w.hlp 5 Extracting a collation using the DBTOOL statement =HDK3B9AF8C0@dbeng50w.hlp 5 The DBCOLLAT command-line utility =HDK3B9AF8D0@dbeng50w.hlp 5 Collation utility options =HDK3B9AF8E0@dbeng50w.hlp 4 The Compression utility 5 The Compression utility =HDK3B9AF8F0@dbeng50w.hlp 5 Compressing a database in SQL Central =HDK3B9AF900@dbeng50w.hlp 5 Compressing a database from the ISQL Tools window =HDK3B9AF910@dbeng50w.hlp 5 Compressing a database using the DBTOOL statement =HDK3B9AF920@dbeng50w.hlp 5 The DBSHRINK command-line utility =HDK3B9AF930@dbeng50w.hlp 5 Compression utility options =HDK3B9AF940@dbeng50w.hlp 4 The Erase utility 5 The Erase utility =HDK3B9AF950@dbeng50w.hlp 5 Erasing a database from SQL Central =HDK3B9AF960@dbeng50w.hlp 5 Erasing a database from the ISQL Tools window =HDK3B9AF970@dbeng50w.hlp 5 Erasing a database using the DBTOOL statement =HDK3B9AF980@dbeng50w.hlp 5 The DBERASE command-line utility =HDK3B9AF990@dbeng50w.hlp 5 Erase utility options =HDK3B9AF9A0@dbeng50w.hlp 4 The Information utility 5 The Information utility =HDK3B9AF9B0@dbeng50w.hlp 5 Obtaining database information in the ISQL Tools window =HDK3B9AF9C0@dbeng50w.hlp 5 Obtaining database information using the DBTOOL statement =HDK3B9AF9D0@dbeng50w.hlp 5 The DBINFO command-line utility =HDK3B9AF9E0@dbeng50w.hlp 5 Information utility options =HDK3B9AF9F0@dbeng50w.hlp 4 The Initialization utility 5 The Initialization utility =HDK3B9AFA00@dbeng50w.hlp 5 Creating a database in SQL Central =HDK3B9AFA10@dbeng50w.hlp 5 Creating a database from the ISQL Tools window =HDK3B9AFA20@dbeng50w.hlp 5 Creating a database using the DBTOOL statement =HDK3B9AFA30@dbeng50w.hlp 5 The DBINIT command-line utility =HDK3B9AFA40@dbeng50w.hlp 5 Initialization utility options =HDK3B9AFA50@dbeng50w.hlp 4 The ISQL utility 5 The ISQL utility =HDK3B9AFA60@dbeng50w.hlp 5 Commands available in ISQL =HDK3B9AFA70@dbeng50w.hlp 5 Starting ISQL from SQL Central =HDK3B9AFA80@dbeng50w.hlp 4 The Log Translation utility 5 The Log Translation utility =HDK3B9AFA90@dbeng50w.hlp 5 Translating a transaction log in SQL Central =HDK3B9AFAA0@dbeng50w.hlp 5 Translating a transaction log from the ISQL Tools window =HDK3B9AFAB0@dbeng50w.hlp 5 Translating a transaction log using the DBTOOL statement =HDK3B9AFAC0@dbeng50w.hlp 5 The DBTRAN command-line utility =HDK3B9AFAD0@dbeng50w.hlp 5 Log translation utility options =HDK3B9AFAE0@dbeng50w.hlp 3 The Open Server Gateway =HDK3B9AFAF0@dbeng50w.hlp 3 The Open Server Information utility =HDK3B9AFB00@dbeng50w.hlp 3 The Open Server Stop utility =HDK3B9AFB10@dbeng50w.hlp 3 The REBUILD batch or command file =HDK3B9AFB20@dbeng50w.hlp 4 The SQL Remote Database Extraction utility 5 The SQL Remote Database Extraction utility =HDK3B9AFB30@dbeng50w.hlp 5 Extracting a remote database in SQL Central =HDK3B9AFB40@dbeng50w.hlp 5 The DBXTRACT command-line utility =HDK3B9AFB50@dbeng50w.hlp 5 Extraction utility options =HDK3B9AFB60@dbeng50w.hlp 3 The SQL Remote Message Agent =HDK3B9AFB70@dbeng50w.hlp 4 The Stop utility 5 The Stop utility =HDK3B9AFB80@dbeng50w.hlp 5 The DBSTOP command-line utility =HDK3B9AFB90@dbeng50w.hlp 5 Stop utility options =HDK3B9AFBA0@dbeng50w.hlp 4 The Transaction Log utility 5 The Transaction Log utility =HDK3B9AFBB0@dbeng50w.hlp 5 Changing a log file name from SQL Central =HDK3B9AFBC0@dbeng50w.hlp 5 Changing a log file name from the ISQL Tools window =HDK3B9AFBD0@dbeng50w.hlp 5 Changing a log filename from the DBTOOL statement =HDK3B9AFBE0@dbeng50w.hlp 5 The DBLOG command-line utility =HDK3B9AFBF0@dbeng50w.hlp 5 Transaction log utility options =HDK3B9AFC00@dbeng50w.hlp 4 The Uncompression utility 5 The Uncompression utility =HDK3B9AFC10@dbeng50w.hlp 5 Uncompressing a database in SQL Central =HDK3B9AFC20@dbeng50w.hlp 5 Uncompressing a database from the ISQL Tools window =HDK3B9AFC30@dbeng50w.hlp 5 Uncompressing a database using the DBTOOL statement =HDK3B9AFC40@dbeng50w.hlp 5 The DBEXPAND command-line utility =HDK3B9AFC50@dbeng50w.hlp 5 Uncompression utility options =HDK3B9AFC60@dbeng50w.hlp 4 The Unload utility 5 The Unload utility =HDK3B9AFC70@dbeng50w.hlp 5 Unloading a database from SQL Central =HDK3B9AFC80@dbeng50w.hlp 5 Unloading a database from the ISQL Tools window =HDK3B9AFC90@dbeng50w.hlp 5 Unloading a database from the DBTOOL statement =HDK3B9AFCA0@dbeng50w.hlp 5 The DBUNLOAD command-line utility =HDK3B9AFCB0@dbeng50w.hlp 5 Unload utility options =HDK3B9AFCC0@dbeng50w.hlp 4 The Upgrade utility 5 The Upgrade utility =HDK3B9AFCD0@dbeng50w.hlp 5 Upgrading a database from SQL Central =HDK3B9AFCE0@dbeng50w.hlp 5 Upgrading databases too old for the Upgrade utility =HDK3B9AFCF0@dbeng50w.hlp 5 The DBUPGRAD command-line utility =HDK3B9AFD00@dbeng50w.hlp 5 Upgrade utility options =HDK3B9AFD10@dbeng50w.hlp 4 The Validation utility 5 The Validation utility =HDK3B9AFD20@dbeng50w.hlp 5 Validating a database from SQL Central =HDK3B9AFD30@dbeng50w.hlp 5 Validating a database from the ISQL Tools window =HDK3B9AFD40@dbeng50w.hlp 5 Using the Validation utility from the DBTOOL statement =HDK3B9AFD50@dbeng50w.hlp 5 Using the DBVALID command line utility =HDK3B9AFD60@dbeng50w.hlp 5 Validation utility options =HDK3B9AFD70@dbeng50w.hlp 4 The Write File utility 5 The Write File utility =HDK3B9AFD80@dbeng50w.hlp 5 Creating a write file from SQL Central =HDK3B9AFD90@dbeng50w.hlp 5 Creating a write file from the ISQL Tools window =HDK3B9AFDA0@dbeng50w.hlp 5 Creating a write file using the DBTOOL statement =HDK3B9AFDB0@dbeng50w.hlp 5 The DBWRITE command-line utility =HDK3B9AFDC0@dbeng50w.hlp 5 Write file utility options =HDK3B9AFDD0@dbeng50w.hlp 3 The SQL Preprocessor =HDK3B9AFDE0@dbeng50w.hlp 3 Watcom-SQL Language Reference 4 Watcom-SQL Language Reference =HDK3B9AFDF0@dbeng50w.hlp 4 Syntax conventions =HDK3B9AFE00@dbeng50w.hlp 4 Watcom-SQL language elements =HDK3B9AFE10@dbeng50w.hlp 4 Data types 5 Data types =HDK3B9AFE20@dbeng50w.hlp 5 Character data types =HDK3B9AFE30@dbeng50w.hlp 5 Numeric data types =HDK3B9AFE40@dbeng50w.hlp 5 Date and time data types =HDK3B9AFE50@dbeng50w.hlp 5 Binary data types =HDK3B9AFE60@dbeng50w.hlp 5 User-defined data types =HDK3B9AFE70@dbeng50w.hlp 5 Data type conversions =HDK3B9AFE80@dbeng50w.hlp 4 Functions 5 Functions =HDK3B9AFE90@dbeng50w.hlp 5 Aggregate functions =HDK3B9AFEA0@dbeng50w.hlp 5 Numeric functions =HDK3B9AFEB0@dbeng50w.hlp 5 String functions =HDK3B9AFEC0@dbeng50w.hlp 5 Date and time functions =HDK3B9AFED0@dbeng50w.hlp 5 Data type conversion functions =HDK3B9AFEE0@dbeng50w.hlp 5 System functions =HDK3B9AFEF0@dbeng50w.hlp 5 Miscellaneous functions =HDK3B9AFF00@dbeng50w.hlp 4 Expressions 5 Expressions =HDK3B9AFF10@dbeng50w.hlp 5 Constants in expressions =HDK3B9AFF20@dbeng50w.hlp 5 Column names in expressions =HDK3B9AFF30@dbeng50w.hlp 5 Watcom-SQL variables =HDK3B9AFF40@dbeng50w.hlp 5 Functions in expressions =HDK3B9AFF50@dbeng50w.hlp 5 Subqueries in expressions =HDK3B9AFF60@dbeng50w.hlp 5 Watcom-SQL Operators =HDK3B9AFF70@dbeng50w.hlp 4 Search conditions 5 Search conditions =HDK3B9AFF80@dbeng50w.hlp 5 Subqueries in search conditions =HDK3B9AFF90@dbeng50w.hlp 5 Comparison conditions =HDK3B9AFFA0@dbeng50w.hlp 5 BETWEEN conditions =HDK3B9AFFB0@dbeng50w.hlp 5 LIKE conditions =HDK3B9AFFC0@dbeng50w.hlp 5 IN conditions =HDK3B9AFFD0@dbeng50w.hlp 5 ALL or ANY conditions =HDK3B9AFFE0@dbeng50w.hlp 5 EXISTS conditions =HDK3B9AFFF0@dbeng50w.hlp 5 IS NULL conditions =HDK3B9B0000@dbeng50w.hlp 5 Conditions with logical operators =HDK3B9B0010@dbeng50w.hlp 5 NOT conditions =HDK3B9B0020@dbeng50w.hlp 5 Truth value conditions =HDK3B9B0030@dbeng50w.hlp 5 Three-valued logic =HDK3B9B0040@dbeng50w.hlp 3 Comments in Watcom-SQL =HDK3B9B0050@dbeng50w.hlp 4 SQL statement syntax 5 SQL statement syntax =HDK3B9B0060@dbeng50w.hlp 5 ALTER DBSPACE statement =HDK3B9B0070@dbeng50w.hlp 5 ALTER PROCEDURE statement =HDK3B9B0080@dbeng50w.hlp 5 ALTER PUBLICATION statement =HDK3B9B0090@dbeng50w.hlp 5 ALTER REMOTE MESSAGE TYPE statement =HDK3B9B00A0@dbeng50w.hlp 5 ALTER TABLE statement =HDK3B9B00B0@dbeng50w.hlp 5 CALL statement =HDK3B9B00C0@dbeng50w.hlp 5 CASE statement =HDK3B9B00D0@dbeng50w.hlp 5 CHECKPOINT statement =HDK3B9B00E0@dbeng50w.hlp 5 CLOSE statement =HDK3B9B00F0@dbeng50w.hlp 5 COMMENT statement =HDK3B9B0100@dbeng50w.hlp 5 COMMIT statement =HDK3B9B0110@dbeng50w.hlp 5 Compound statements =HDK3B9B0120@dbeng50w.hlp 5 CONFIGURE statement =HDK3B9B0130@dbeng50w.hlp 5 CONNECT statement =HDK3B9B0140@dbeng50w.hlp 5 CREATE DATATYPE statement =HDK3B9B0150@dbeng50w.hlp 5 CREATE DBSPACE statement =HDK3B9B0160@dbeng50w.hlp 5 CREATE FUNCTION statement =HDK3B9B0170@dbeng50w.hlp 5 CREATE INDEX statement =HDK3B9B0180@dbeng50w.hlp 5 CREATE PROCEDURE statement =HDK3B9B0190@dbeng50w.hlp 5 CREATE PUBLICATION statement =HDK3B9B01A0@dbeng50w.hlp 5 CREATE REMOTE MESSAGE TYPE statement =HDK3B9B01B0@dbeng50w.hlp 5 CREATE SCHEMA statement =HDK3B9B01C0@dbeng50w.hlp 5 CREATE SUBSCRIPTION statement =HDK3B9B01D0@dbeng50w.hlp 5 CREATE TABLE statement 6 CREATE TABLE statement =HDK3B9B01E0@dbeng50w.hlp 6 Integrity constraints =HDK3B9B01F0@dbeng50w.hlp 4 CREATE TRIGGER statement =HDK3B9B0200@dbeng50w.hlp 4 CREATE VARIABLE statement =HDK3B9B0210@dbeng50w.hlp 4 CREATE VIEW statement =HDK3B9B0220@dbeng50w.hlp 4 DBTOOL statement =HDK3B9B0230@dbeng50w.hlp 4 Declaration section =HDK3B9B0240@dbeng50w.hlp 4 DECLARE CURSOR statement =HDK3B9B0250@dbeng50w.hlp 4 DECLARE TEMPORARY TABLE statement =HDK3B9B0260@dbeng50w.hlp 4 DELETE statement =HDK3B9B0270@dbeng50w.hlp 4 DELETE positioned statement =HDK3B9B0280@dbeng50w.hlp 4 DESCRIBE statement =HDK3B9B0290@dbeng50w.hlp 4 DISCONNECT statement =HDK3B9B02A0@dbeng50w.hlp 4 DROP statement =HDK3B9B02B0@dbeng50w.hlp 4 DROP CONNECTION statement =HDK3B9B02C0@dbeng50w.hlp 4 DROP OPTIMIZER STATISTICS statement =HDK3B9B02D0@dbeng50w.hlp 4 DROP PUBLICATION statement =HDK3B9B02E0@dbeng50w.hlp 4 DROP REMOTE MESSAGE TYPE statement =HDK3B9B02F0@dbeng50w.hlp 4 DROP STATEMENT statement =HDK3B9B0300@dbeng50w.hlp 4 DROP VARIABLE statement =HDK3B9B0310@dbeng50w.hlp 4 DROP SUBSCRIPTION statement =HDK3B9B0320@dbeng50w.hlp 4 EXECUTE statement =HDK3B9B0330@dbeng50w.hlp 4 EXECUTE IMMEDIATE statement =HDK3B9B0340@dbeng50w.hlp 4 EXIT statement =HDK3B9B0350@dbeng50w.hlp 4 EXPLAIN statement =HDK3B9B0360@dbeng50w.hlp 4 FETCH statement =HDK3B9B0370@dbeng50w.hlp 4 FOR statement =HDK3B9B0380@dbeng50w.hlp 5 FROM clause 6 FROM clause =HDK3B9B0390@dbeng50w.hlp 6 Joining tables =HDK3B9B03A0@dbeng50w.hlp 6 Cross joins =HDK3B9B03B0@dbeng50w.hlp 6 Generated join conditions =HDK3B9B03C0@dbeng50w.hlp 6 Natural joins =HDK3B9B03D0@dbeng50w.hlp 6 Key joins =HDK3B9B03E0@dbeng50w.hlp 6 INNER JOIN and OUTER JOIN =HDK3B9B03F0@dbeng50w.hlp 6 Join conditions =HDK3B9B0400@dbeng50w.hlp 6 Join abbreviations =HDK3B9B0410@dbeng50w.hlp 4 GET DATA statement =HDK3B9B0420@dbeng50w.hlp 4 GET OPTION statement =HDK3B9B0430@dbeng50w.hlp 4 GRANT statement =HDK3B9B0440@dbeng50w.hlp 4 GRANT CONSOLIDATE statement =HDK3B9B0450@dbeng50w.hlp 4 GRANT PUBLISH statement =HDK3B9B0460@dbeng50w.hlp 4 GRANT REMOTE statement =HDK3B9B0470@dbeng50w.hlp 4 HELP statement =HDK3B9B0480@dbeng50w.hlp 4 IF statement =HDK3B9B0490@dbeng50w.hlp 4 INCLUDE statement =HDK3B9B04A0@dbeng50w.hlp 4 INPUT statement =HDK3B9B04B0@dbeng50w.hlp 4 INSERT statement =HDK3B9B04C0@dbeng50w.hlp 4 LEAVE statement =HDK3B9B04D0@dbeng50w.hlp 4 LOAD TABLE statement =HDK3B9B04E0@dbeng50w.hlp 4 LOOP statement =HDK3B9B04F0@dbeng50w.hlp 4 MESSAGE statement =HDK3B9B0500@dbeng50w.hlp 4 NULL value =HDK3B9B0510@dbeng50w.hlp 4 OPEN statement =HDK3B9B0520@dbeng50w.hlp 4 OUTPUT statement =HDK3B9B0530@dbeng50w.hlp 4 PARAMETERS statement =HDK3B9B0540@dbeng50w.hlp 4 PASSTHROUGH statement =HDK3B9B0550@dbeng50w.hlp 4 PREPARE statement =HDK3B9B0560@dbeng50w.hlp 4 PREPARE TO COMMIT statement =HDK3B9B0570@dbeng50w.hlp 4 PUT statement =HDK3B9B0580@dbeng50w.hlp 4 READ statement =HDK3B9B0590@dbeng50w.hlp 4 RELEASE SAVEPOINT statement =HDK3B9B05A0@dbeng50w.hlp 4 RESIGNAL statement =HDK3B9B05B0@dbeng50w.hlp 4 RESUME statement =HDK3B9B05C0@dbeng50w.hlp 4 RETURN statement =HDK3B9B05D0@dbeng50w.hlp 4 REVOKE statement =HDK3B9B05E0@dbeng50w.hlp 4 REVOKE CONSOLIDATE statement =HDK3B9B05F0@dbeng50w.hlp 4 REVOKE PUBLISH statement =HDK3B9B0600@dbeng50w.hlp 4 REVOKE REMOTE statement =HDK3B9B0610@dbeng50w.hlp 4 ROLLBACK statement =HDK3B9B0620@dbeng50w.hlp 4 ROLLBACK TO SAVEPOINT statement =HDK3B9B0630@dbeng50w.hlp 4 SAVEPOINT statement =HDK3B9B0640@dbeng50w.hlp 4 SELECT statement =HDK3B9B0650@dbeng50w.hlp 4 SET CONNECTION statement =HDK3B9B0660@dbeng50w.hlp 5 SET OPTION statement 6 SET OPTION statement =HDK3B9B0670@dbeng50w.hlp 6 Database options =HDK3B9B0680@dbeng50w.hlp 6 Replication options =HDK3B9B0690@dbeng50w.hlp 6 ISQL options =HDK3B9B06A0@dbeng50w.hlp 4 SET SQLCA statement =HDK3B9B06B0@dbeng50w.hlp 4 SET statement =HDK3B9B06C0@dbeng50w.hlp 4 SIGNAL statement =HDK3B9B06D0@dbeng50w.hlp 4 START DATABASE statement =HDK3B9B06E0@dbeng50w.hlp 4 START ENGINE statement =HDK3B9B06F0@dbeng50w.hlp 4 START SUBSCRIPTION statement =HDK3B9B0700@dbeng50w.hlp 4 STOP DATABASE statement =HDK3B9B0710@dbeng50w.hlp 4 STOP ENGINE statement =HDK3B9B0720@dbeng50w.hlp 4 STOP SUBSCRIPTION statement =HDK3B9B0730@dbeng50w.hlp 4 SYNCHRONIZE SUBSCRIPTION statement =HDK3B9B0740@dbeng50w.hlp 4 SYSTEM statement =HDK3B9B0750@dbeng50w.hlp 4 TRUNCATE TABLE statement =HDK3B9B0760@dbeng50w.hlp 4 UNION operation =HDK3B9B0770@dbeng50w.hlp 4 UNLOAD TABLE statement =HDK3B9B0780@dbeng50w.hlp 4 UPDATE statement =HDK3B9B0790@dbeng50w.hlp 4 UPDATE (positioned) statement =HDK3B9B07A0@dbeng50w.hlp 4 VALIDATE TABLE statement =HDK3B9B07B0@dbeng50w.hlp 4 WHENEVER statement =HDK3B9B07C0@dbeng50w.hlp 3 SQL Anywhere Database Error Messages 4 SQL Anywhere Database Error Messages =HDK3B9B07D0@dbeng50w.hlp 4 Error message index by SQLCODE =HDK3B9B07E0@dbeng50w.hlp 4 Error messages index by SQLSTATE =HDK3B9B07F0@dbeng50w.hlp 4 Alphabetic list of error messages 5 Alphabetic list of error messages =HDK3B9B0800@dbeng50w.hlp 5 (no message) =HDK3B9B0810@dbeng50w.hlp 5 A parameter to an external function is an unsupported datatype =HDK3B9B0820@dbeng50w.hlp 5 A thread used internally could not be started =HDK3B9B0830@dbeng50w.hlp 5 Aggregate functions not allowed on this statement =HDK3B9B0840@dbeng50w.hlp 5 All threads are blocked =HDK3B9B0850@dbeng50w.hlp 5 ALTER clause conflict =HDK3B9B0860@dbeng50w.hlp 5 An argument passed to a SQL Anywhere HLI function was invalid =HDK3B9B0870@dbeng50w.hlp 5 Attempted two active database requests =HDK3B9B0880@dbeng50w.hlp 5 Authentication violation =HDK3B9B0890@dbeng50w.hlp 5 Calling functions outside the database engine is not supported =HDK3B9B08A0@dbeng50w.hlp 5 Can only describe a SELECT statement =HDK3B9B08B0@dbeng50w.hlp 5 Cannot alter a column in an index =HDK3B9B08C0@dbeng50w.hlp 5 Cannot be started -- %1 =HDK3B9B08D0@dbeng50w.hlp 5 Cannot convert %1 to a %2 =HDK3B9B08E0@dbeng50w.hlp 5 Cannot delete a column referenced in a trigger definition =HDK3B9B08F0@dbeng50w.hlp 5 Cannot drop a user that owns messages or datatypes =HDK3B9B0900@dbeng50w.hlp 5 Cannot drop a user that owns procedures in runtime engine =HDK3B9B0910@dbeng50w.hlp 5 Cannot drop a user that owns tables in runtime engine =HDK3B9B0920@dbeng50w.hlp 5 Cannot find index named '%1' =HDK3B9B0930@dbeng50w.hlp 5 Cannot modify column '%1' in table '%2' =HDK3B9B0940@dbeng50w.hlp 5 Cannot open log file %1 =HDK3B9B0950@dbeng50w.hlp 5 Cannot outer join a view with a UNION or GROUP BY =HDK3B9B0960@dbeng50w.hlp 5 Cannot uniquely identify rows in cursor =HDK3B9B0970@dbeng50w.hlp 5 Cannot update an expression =HDK3B9B0980@dbeng50w.hlp 5 CHECKPOINT command requires a rollback log =HDK3B9B0990@dbeng50w.hlp 5 Client/server communications protocol mismatch =HDK3B9B09A0@dbeng50w.hlp 5 Column %1 in foreign key has a different definition than primary key =HDK3B9B09B0@dbeng50w.hlp 5 Column '%1' found in more than one table -- need a correlation name =HDK3B9B09C0@dbeng50w.hlp 5 Column '%1' in table '%2' cannot be NULL =HDK3B9B09D0@dbeng50w.hlp 5 Column '%1' not found =HDK3B9B09E0@dbeng50w.hlp 5 COMMIT/ROLLBACK not allowed within atomic operation =HDK3B9B09F0@dbeng50w.hlp 5 COMMIT/ROLLBACK not allowed within trigger actions =HDK3B9B0A00@dbeng50w.hlp 5 Communication buffer underflow =HDK3B9B0A10@dbeng50w.hlp 5 Communication error =HDK3B9B0A20@dbeng50w.hlp 5 Connection not found =HDK3B9B0A30@dbeng50w.hlp 5 Connection was terminated =HDK3B9B0A40@dbeng50w.hlp 5 Connections to database have been disabled =HDK3B9B0A50@dbeng50w.hlp 5 Correlation name '%1' not found =HDK3B9B0A60@dbeng50w.hlp 5 Could not allocate resources to call external function =HDK3B9B0A70@dbeng50w.hlp 5 Could not find the named function in the dynamic library =HDK3B9B0A80@dbeng50w.hlp 5 Could not load the dynamic library =HDK3B9B0A90@dbeng50w.hlp 5 Cursor already open =HDK3B9B0AA0@dbeng50w.hlp 5 Cursor has not been declared =HDK3B9B0AB0@dbeng50w.hlp 5 Cursor not open =HDK3B9B0AC0@dbeng50w.hlp 5 Cursor operation conflict =HDK3B9B0AD0@dbeng50w.hlp 5 Data definition statements not allowed in procedures or triggers =HDK3B9B0AE0@dbeng50w.hlp 5 Database backup not started =HDK3B9B0AF0@dbeng50w.hlp 5 Database engine already running =HDK3B9B0B00@dbeng50w.hlp 5 Database engine not running =HDK3B9B0B10@dbeng50w.hlp 5 Database engine not running in multi-user mode =HDK3B9B0B20@dbeng50w.hlp 5 Database name not unique =HDK3B9B0B30@dbeng50w.hlp 5 Database name required to start engine =HDK3B9B0B40@dbeng50w.hlp 5 Database was initialized with an older version of the software =HDK3B9B0B50@dbeng50w.hlp 5 Database's page size too big =HDK3B9B0B60@dbeng50w.hlp 5 Dblib/database engine version mismatch =HDK3B9B0B70@dbeng50w.hlp 5 Dbspace '%1' not found =HDK3B9B0B80@dbeng50w.hlp 5 Deadlock detected =HDK3B9B0B90@dbeng50w.hlp 5 Disallowed language extension detected in syntax near '%1' =HDK3B9B0BA0@dbeng50w.hlp 5 Disk full -- transaction rolled back =HDK3B9B0BB0@dbeng50w.hlp 5 Division by zero =HDK3B9B0BC0@dbeng50w.hlp 5 Do not have permission to %1 =HDK3B9B0BD0@dbeng50w.hlp 5 Duplicate insert column =HDK3B9B0BE0@dbeng50w.hlp 5 Duplicate referencing column =HDK3B9B0BF0@dbeng50w.hlp 5 Dynamic memory exhausted! =HDK3B9B0C00@dbeng50w.hlp 5 Error inserting into cursor =HDK3B9B0C10@dbeng50w.hlp 5 Error number %1 for RAISERROR is less than 17000 =HDK3B9B0C20@dbeng50w.hlp 5 Error opening cursor =HDK3B9B0C30@dbeng50w.hlp 5 Error writing to log file =HDK3B9B0C40@dbeng50w.hlp 5 Feature '%1' not implemented =HDK3B9B0C50@dbeng50w.hlp 5 Foreign key '%1' for table '%2' duplicates an existing foreign key =HDK3B9B0C60@dbeng50w.hlp 5 Foreign key name '%1' not found =HDK3B9B0C70@dbeng50w.hlp 5 Format string argument number %1 is invalid =HDK3B9B0C80@dbeng50w.hlp 5 Function or column reference to '%1' in the select list must also appear in a GROUP BY =HDK3B9B0C90@dbeng50w.hlp 5 GRANT of column permission on view not allowed =HDK3B9B0CA0@dbeng50w.hlp 5 I/O error %1 -- transaction rolled back =HDK3B9B0CB0@dbeng50w.hlp 5 Identifier '%1' too long =HDK3B9B0CC0@dbeng50w.hlp 5 Incomplete transactions prevent transaction log renaming =HDK3B9B0CD0@dbeng50w.hlp 5 Index '%1' for table '%2' would not be unique =HDK3B9B0CE0@dbeng50w.hlp 5 Index name '%1' not unique =HDK3B9B0CF0@dbeng50w.hlp 5 INSERT/DELETE on cursor can modify only one table =HDK3B9B0D00@dbeng50w.hlp 5 Internal database error %1 -- transaction rolled back =HDK3B9B0D10@dbeng50w.hlp 5 Invalid absolute or relative offset in FETCH =HDK3B9B0D20@dbeng50w.hlp 5 Invalid column number =HDK3B9B0D30@dbeng50w.hlp 5 Invalid data conversion =HDK3B9B0D40@dbeng50w.hlp 5 Invalid database engine command line =HDK3B9B0D50@dbeng50w.hlp 5 Invalid datatype for column in WRITETEXT or READTEXT =HDK3B9B0D60@dbeng50w.hlp 5 Invalid escape character '%1' =HDK3B9B0D70@dbeng50w.hlp 5 Invalid escape sequence '%1' =HDK3B9B0D80@dbeng50w.hlp 5 Invalid expression near '%1' =HDK3B9B0D90@dbeng50w.hlp 5 Invalid host variable =HDK3B9B0DA0@dbeng50w.hlp 5 Invalid local database switch =HDK3B9B0DB0@dbeng50w.hlp 5 Invalid operation for this cursor =HDK3B9B0DC0@dbeng50w.hlp 5 Invalid option '%1' -- no PUBLIC setting exists =HDK3B9B0DD0@dbeng50w.hlp 5 Invalid parameter =HDK3B9B0DE0@dbeng50w.hlp 5 Invalid prepared statement type =HDK3B9B0DF0@dbeng50w.hlp 5 Invalid REFERENCES clause in trigger definition =HDK3B9B0E00@dbeng50w.hlp 5 Invalid setting for option '%1' =HDK3B9B0E10@dbeng50w.hlp 5 Invalid SQL Anywhere HLI callback function =HDK3B9B0E20@dbeng50w.hlp 5 Invalid SQL Anywhere HLI command syntax =HDK3B9B0E30@dbeng50w.hlp 5 Invalid SQL Anywhere HLI cursor name =HDK3B9B0E40@dbeng50w.hlp 5 Invalid SQL Anywhere HLI host variable name =HDK3B9B0E50@dbeng50w.hlp 5 Invalid SQL Anywhere HLI host variable value =HDK3B9B0E60@dbeng50w.hlp 5 Invalid SQL Anywhere HLI statement name =HDK3B9B0E70@dbeng50w.hlp 5 Invalid statement =HDK3B9B0E80@dbeng50w.hlp 5 Invalid TEXTPTR value used with WRITETEXT or READTEXT =HDK3B9B0E90@dbeng50w.hlp 5 Invalid type on DESCRIBE statement =HDK3B9B0EA0@dbeng50w.hlp 5 Invalid userid and password on preprocessed module =HDK3B9B0EB0@dbeng50w.hlp 5 Invalid userid or password =HDK3B9B0EC0@dbeng50w.hlp 5 Invalid value for column '%1' in table '%2' =HDK3B9B0ED0@dbeng50w.hlp 5 Item '%1' already exists =HDK3B9B0EE0@dbeng50w.hlp 5 Label '%1' not found =HDK3B9B0EF0@dbeng50w.hlp 5 Language extension =HDK3B9B0F00@dbeng50w.hlp 5 Language extension detected in syntax =HDK3B9B0F10@dbeng50w.hlp 5 Mismatch between external function platform specifier and current operating system =HDK3B9B0F20@dbeng50w.hlp 5 More than one table is identified as '%1' =HDK3B9B0F30@dbeng50w.hlp 5 Need a dynamic library name =HDK3B9B0F40@dbeng50w.hlp 5 No current row of cursor =HDK3B9B0F50@dbeng50w.hlp 5 No indicator variable provided for NULL result =HDK3B9B0F60@dbeng50w.hlp 5 No primary key value for foreign key '%1' in table '%2' =HDK3B9B0F70@dbeng50w.hlp 5 Not allowed while %1 is using the database =HDK3B9B0F80@dbeng50w.hlp 5 Not connected to SQL database =HDK3B9B0F90@dbeng50w.hlp 5 Not enough fields allocated in SQLDA =HDK3B9B0FA0@dbeng50w.hlp 5 Not enough memory to start =HDK3B9B0FB0@dbeng50w.hlp 5 Not enough values for host variables =HDK3B9B0FC0@dbeng50w.hlp 5 Null value eliminated in aggregate function =HDK3B9B0FD0@dbeng50w.hlp 5 Number in ORDER BY is too large =HDK3B9B0FE0@dbeng50w.hlp 5 Number of columns does not match SELECT =HDK3B9B0FF0@dbeng50w.hlp 5 Operation would cause a group cycle =HDK3B9B1000@dbeng50w.hlp 5 Parameter '%1' not found in procedure '%2' =HDK3B9B1010@dbeng50w.hlp 5 Parameter name missing in call to procedure '%1' =HDK3B9B1020@dbeng50w.hlp 5 Passthrough statement inconsistent with current passthrough =HDK3B9B1030@dbeng50w.hlp 5 Primary key column '%1' already defined =HDK3B9B1040@dbeng50w.hlp 5 Primary key for row in table '%1' is referenced in another table =HDK3B9B1050@dbeng50w.hlp 5 Primary key for table '%1' is not unique =HDK3B9B1060@dbeng50w.hlp 5 Procedure '%1' not found =HDK3B9B1070@dbeng50w.hlp 5 Procedure has completed =HDK3B9B1080@dbeng50w.hlp 5 Procedure in use =HDK3B9B1090@dbeng50w.hlp 5 Procedure or trigger calls have nested too deeply =HDK3B9B10A0@dbeng50w.hlp 5 Publication '%1' not found =HDK3B9B10B0@dbeng50w.hlp 5 RAISERROR executed: %1 =HDK3B9B10C0@dbeng50w.hlp 5 Remote message type '%1' not found =HDK3B9B10D0@dbeng50w.hlp 5 Remote statement failed =HDK3B9B10E0@dbeng50w.hlp 5 Request denied -- no active databases =HDK3B9B10F0@dbeng50w.hlp 5 Request to start/stop database denied =HDK3B9B1100@dbeng50w.hlp 5 Result set not allowed from within an atomic compound statement =HDK3B9B1110@dbeng50w.hlp 5 Right truncation of string data =HDK3B9B1120@dbeng50w.hlp 5 ROLLBACK TO SAVEPOINT not allowed =HDK3B9B1130@dbeng50w.hlp 5 Row has been updated since last time read =HDK3B9B1140@dbeng50w.hlp 5 Row has changed since last read -- operation cancelled =HDK3B9B1150@dbeng50w.hlp 5 Row not found =HDK3B9B1160@dbeng50w.hlp 5 Run time SQL error -- %1 =HDK3B9B1170@dbeng50w.hlp 5 Savepoint '%1' not found =HDK3B9B1180@dbeng50w.hlp 5 Savepoints require a rollback log =HDK3B9B1190@dbeng50w.hlp 5 SELECT lists in UNION do not match in length =HDK3B9B11A0@dbeng50w.hlp 5 SELECT returns more than one row =HDK3B9B11B0@dbeng50w.hlp 5 Server/database engine version mismatch =HDK3B9B11C0@dbeng50w.hlp 5 Specified database is invalid =HDK3B9B11D0@dbeng50w.hlp 5 Specified database not found =HDK3B9B11E0@dbeng50w.hlp 5 SQL Anywhere HLI internal error =HDK3B9B11F0@dbeng50w.hlp 5 SQL statement error =HDK3B9B1200@dbeng50w.hlp 5 Sqlpp/dblib version mismatch =HDK3B9B1210@dbeng50w.hlp 5 Statement interrupted by user =HDK3B9B1220@dbeng50w.hlp 5 Subquery allowed only one select list item =HDK3B9B1230@dbeng50w.hlp 5 Subquery cannot return more than one result =HDK3B9B1240@dbeng50w.hlp 5 Subscription to '%1' for '%2' already exists =HDK3B9B1250@dbeng50w.hlp 5 Subscription to '%1' for '%2' not found =HDK3B9B1260@dbeng50w.hlp 5 Syntax error near '%1' =HDK3B9B1270@dbeng50w.hlp 5 Table '%1' has no primary key =HDK3B9B1280@dbeng50w.hlp 5 Table '%1' has publications =HDK3B9B1290@dbeng50w.hlp 5 Table '%1' is in an outer join cycle =HDK3B9B12A0@dbeng50w.hlp 5 Table '%1' not found =HDK3B9B12B0@dbeng50w.hlp 5 Table '%1' requires a unique correlation name =HDK3B9B12C0@dbeng50w.hlp 5 Table already has a primary key =HDK3B9B12D0@dbeng50w.hlp 5 Table cannot have two primary keys =HDK3B9B12E0@dbeng50w.hlp 5 Table in use =HDK3B9B12F0@dbeng50w.hlp 5 Table must be empty =HDK3B9B1300@dbeng50w.hlp 5 Terminated by user -- transaction rolled back =HDK3B9B1310@dbeng50w.hlp 5 The selected database is currently inactive =HDK3B9B1320@dbeng50w.hlp 5 The supplied buffer was too small to hold all requested query results =HDK3B9B1330@dbeng50w.hlp 5 There are still active database connections =HDK3B9B1340@dbeng50w.hlp 5 There is already a variable named '%1' =HDK3B9B1350@dbeng50w.hlp 5 There is more than one way to join '%1' to '%2' =HDK3B9B1360@dbeng50w.hlp 5 There is no way to join '%1' to '%2' =HDK3B9B1370@dbeng50w.hlp 5 Too many columns in table =HDK3B9B1380@dbeng50w.hlp 5 Too many connections to database =HDK3B9B1390@dbeng50w.hlp 5 Too many parameters to this external procedure call =HDK3B9B13A0@dbeng50w.hlp 5 Transact SQL feature not supported =HDK3B9B13B0@dbeng50w.hlp 5 Trigger '%1' not found =HDK3B9B13C0@dbeng50w.hlp 5 Trigger definition conflicts with existing triggers =HDK3B9B13D0@dbeng50w.hlp 5 Triggers and procedures not supported in desktop engine =HDK3B9B13E0@dbeng50w.hlp 5 Unable to delete database file =HDK3B9B13F0@dbeng50w.hlp 5 Unable to find in index '%1' for table '%2' =HDK3B9B1400@dbeng50w.hlp 5 Unable to start database engine =HDK3B9B1410@dbeng50w.hlp 5 Unable to start specified database =HDK3B9B1420@dbeng50w.hlp 5 Unknown backup operation =HDK3B9B1430@dbeng50w.hlp 5 Unknown function '%1' =HDK3B9B1440@dbeng50w.hlp 5 Unterminated C string =HDK3B9B1450@dbeng50w.hlp 5 Update operation attempted on a read-only cursor =HDK3B9B1460@dbeng50w.hlp 5 Update operation attempted on non-updatable query =HDK3B9B1470@dbeng50w.hlp 5 User '%1' already has grant permission =HDK3B9B1480@dbeng50w.hlp 5 User '%1' has the row in '%2' locked =HDK3B9B1490@dbeng50w.hlp 5 User '%1' is already the publisher for this database =HDK3B9B14A0@dbeng50w.hlp 5 User '%1' is not a remote user for this database =HDK3B9B14B0@dbeng50w.hlp 5 User '%1' is not a user group =HDK3B9B14C0@dbeng50w.hlp 5 User message %1 already exists =HDK3B9B14D0@dbeng50w.hlp 5 User message %1 not found =HDK3B9B14E0@dbeng50w.hlp 5 User-defined exception signalled =HDK3B9B14F0@dbeng50w.hlp 5 User-defined type %1 not found =HDK3B9B1500@dbeng50w.hlp 5 Userid '%1' does not exist =HDK3B9B1510@dbeng50w.hlp 5 Using temporary table =HDK3B9B1520@dbeng50w.hlp 5 Value %1 out of range for destination =HDK3B9B1530@dbeng50w.hlp 5 Value for column '%1' in table '%2' has changed =HDK3B9B1540@dbeng50w.hlp 5 Value truncated =HDK3B9B1550@dbeng50w.hlp 5 Variable '%1' not found =HDK3B9B1560@dbeng50w.hlp 5 Warning =HDK3B9B1570@dbeng50w.hlp 5 WITH CHECK OPTION violated for view '%1' =HDK3B9B1580@dbeng50w.hlp 5 Wrong number of parameters to function '%1' =HDK3B9B1590@dbeng50w.hlp 5 Wrong number of values for INSERT =HDK3B9B15A0@dbeng50w.hlp 5 Wrong number of variables in FETCH =HDK3B9B15B0@dbeng50w.hlp 3 Internal errors (assertion failed) =HDK3B9B15C0@dbeng50w.hlp 3 SQL Preprocessor Error Messages 4 SQL Preprocessor Error Messages =HDK3B9B15D0@dbeng50w.hlp 4 SQLPP errors 5 SQLPP errors =HDK3B9B15E0@dbeng50w.hlp 5 subscript value %ld too large =HDK3B9B15F0@dbeng50w.hlp 5 combined pointer and arrays not supported for hosttypes =HDK3B9B1600@dbeng50w.hlp 5 only one dimensional arrays supported for char type =HDK3B9B1610@dbeng50w.hlp 5 VARCHAR type must have a length =HDK3B9B1620@dbeng50w.hlp 5 arrays of VARCHAR not supported =HDK3B9B1630@dbeng50w.hlp 5 VARCHAR host variables cannot be pointers =HDK3B9B1640@dbeng50w.hlp 5 initializer not allowed on VARCHAR host variable =HDK3B9B1650@dbeng50w.hlp 5 FIXCHAR type must have a length =HDK3B9B1660@dbeng50w.hlp 5 arrays of FIXCHAR not supported =HDK3B9B1670@dbeng50w.hlp 5 arrays of int not supported =HDK3B9B1680@dbeng50w.hlp 5 precision must be specified for decimal type =HDK3B9B1690@dbeng50w.hlp 5 arrays of decimal not allowed =HDK3B9B16A0@dbeng50w.hlp 5 Unknown hostvar type =HDK3B9B16B0@dbeng50w.hlp 5 invalid integer =HDK3B9B16C0@dbeng50w.hlp 5 '%s' host variable must be a C string type =HDK3B9B16D0@dbeng50w.hlp 5 '%s' symbol already defined =HDK3B9B16E0@dbeng50w.hlp 5 invalid type for sql statement variable =HDK3B9B16F0@dbeng50w.hlp 5 Cannot find include file '%s' =HDK3B9B1700@dbeng50w.hlp 5 host variable '%s' is unknown =HDK3B9B1710@dbeng50w.hlp 5 indicator variable '%s' is unknown =HDK3B9B1720@dbeng50w.hlp 5 invalid type for indicator variable '%s' =HDK3B9B1730@dbeng50w.hlp 5 invalid host variable type on '%s' =HDK3B9B1740@dbeng50w.hlp 5 host variable '%s' has two different definitions =HDK3B9B1750@dbeng50w.hlp 5 statement '%s' not previously prepared =HDK3B9B1760@dbeng50w.hlp 5 cursor '%s' not previously declared =HDK3B9B1770@dbeng50w.hlp 5 unknown statement '%s' =HDK3B9B1780@dbeng50w.hlp 5 host variables not allowed for this cursor =HDK3B9B1790@dbeng50w.hlp 5 host variables specified twice - on declare and open =HDK3B9B17A0@dbeng50w.hlp 5 must specify a host list or using clause on %s =HDK3B9B17B0@dbeng50w.hlp 5 no INTO clause on SELECT statement =HDK3B9B17C0@dbeng50w.hlp 5 incorrect Embedded SQL syntax =HDK3B9B17D0@dbeng50w.hlp 5 missing ending quote of string =HDK3B9B17E0@dbeng50w.hlp 5 token too long =HDK3B9B17F0@dbeng50w.hlp 5 '%s' host variable must be an integer type =HDK3B9B1800@dbeng50w.hlp 4 SQLPP warnings 5 SQLPP warnings =HDK3B9B1810@dbeng50w.hlp 5 Into clause not allowed on declare cursor - ignored =HDK3B9B1820@dbeng50w.hlp 5 unrecognized SQL syntax =HDK3B9B1830@dbeng50w.hlp 5 unknown sql function '%s' =HDK3B9B1840@dbeng50w.hlp 5 wrong number of parms to sql function '%s' =HDK3B9B1850@dbeng50w.hlp 5 static statement names will not work properly if used by 2 threads =HDK3B9B1860@dbeng50w.hlp 3 Differences from Other SQL Dialects 4 Differences from Other SQL Dialects =HDK3B9B1870@dbeng50w.hlp 4 SQL Anywhere features =HDK3B9B1880@dbeng50w.hlp 2 SQL Anywhere Limitations =HDK3B9B1890@dbeng50w.hlp 3 SQL Anywhere Keywords 4 SQL Anywhere Keywords =HDK3B9B18A0@dbeng50w.hlp 4 Alphabetical list of keywords =HDK3B9B18B0@dbeng50w.hlp 3 SQL Anywhere System Procedures and Functions 4 SQL Anywhere System Procedures and Functions =HDK3B9B18C0@dbeng50w.hlp 4 System procedure overview =HDK3B9B18D0@dbeng50w.hlp 4 Catalog stored procedures =HDK3B9B18E0@dbeng50w.hlp 4 System extended stored procedures 5 System extended stored procedures =HDK3B9B18F0@dbeng50w.hlp 5 MAPI system extended stored procedures 6 MAPI system extended stored procedures =HDK3B9B1900@dbeng50w.hlp 6 xp_startmail system procedure =HDK3B9B1910@dbeng50w.hlp 6 xp_sendmail system procedure =HDK3B9B1920@dbeng50w.hlp 6 xp_stopmail system procedure =HDK3B9B1930@dbeng50w.hlp 5 Other system extended stored procedures 6 Other system extended stored procedures =HDK3B9B1940@dbeng50w.hlp 6 xp_cmdshell system procedure =HDK3B9B1950@dbeng50w.hlp 6 xp_sprintf system procedure =HDK3B9B1960@dbeng50w.hlp 6 xp_scanf system procedure =HDK3B9B1970@dbeng50w.hlp 3 SQL Anywhere System Tables 4 SQL Anywhere System Tables =HDK3B9B1980@dbeng50w.hlp 4 System tables diagram =HDK3B9B1990@dbeng50w.hlp 4 Alphabetical list of system tables 5 Alphabetical list of system tables =HDK3B9B19A0@dbeng50w.hlp 5 DUMMY system table =HDK3B9B19B0@dbeng50w.hlp 5 SYSARTICLE system table =HDK3B9B19C0@dbeng50w.hlp 5 SYSARTICLECOL system table =HDK3B9B19D0@dbeng50w.hlp 5 SYSCOLLATE system table =HDK3B9B19E0@dbeng50w.hlp 5 SYSCOLPERM system table =HDK3B9B19F0@dbeng50w.hlp 5 SYSCOLUMN system table =HDK3B9B1A00@dbeng50w.hlp 5 SYSDOMAIN system table =HDK3B9B1A10@dbeng50w.hlp 5 SYSFILE system table =HDK3B9B1A20@dbeng50w.hlp 5 SYSFKCOL system table =HDK3B9B1A30@dbeng50w.hlp 5 SYSFOREIGNKEY system table =HDK3B9B1A40@dbeng50w.hlp 5 SYSGROUP system table =HDK3B9B1A50@dbeng50w.hlp 5 SYSINDEX system table =HDK3B9B1A60@dbeng50w.hlp 5 SYSINFO system table =HDK3B9B1A70@dbeng50w.hlp 5 SYSIXCOL system table =HDK3B9B1A80@dbeng50w.hlp 5 SYSOPTION system table =HDK3B9B1A90@dbeng50w.hlp 5 SYSPROCEDURE system table =HDK3B9B1AA0@dbeng50w.hlp 5 SYSPROCPARM system table =HDK3B9B1AB0@dbeng50w.hlp 5 SYSPROCPERM system table =HDK3B9B1AC0@dbeng50w.hlp 5 SYSPUBLICATION system table =HDK3B9B1AD0@dbeng50w.hlp 5 SYSREMOTEUSER system table =HDK3B9B1AE0@dbeng50w.hlp 5 SYSSUBSCRIPTION system table =HDK3B9B1AF0@dbeng50w.hlp 5 SYSTABLE system table =HDK3B9B1B00@dbeng50w.hlp 5 SYSTABLEPERM system table =HDK3B9B1B10@dbeng50w.hlp 5 SYSTRIGGER system table =HDK3B9B1B20@dbeng50w.hlp 5 SYSUSERMESSAGES system table =HDK3B9B1B30@dbeng50w.hlp 5 SYSUSERPERM system table =HDK3B9B1B40@dbeng50w.hlp 5 SYSUSERTYPE system table =HDK3B9B1B50@dbeng50w.hlp 3 SQL Anywhere System Views 4 SQL Anywhere System Views =HDK3B9B1B60@dbeng50w.hlp 4 Alphabetical list of views 5 Alphabetical list of views =HDK3B9B1B70@dbeng50w.hlp 5 SYS.SYSCATALOG =HDK3B9B1B80@dbeng50w.hlp 5 SYS.SYSCOLAUTH =HDK3B9B1B90@dbeng50w.hlp 5 SYS.SYSCOLUMNS =HDK3B9B1BA0@dbeng50w.hlp 5 SYS.SYSFOREIGNKEYS =HDK3B9B1BB0@dbeng50w.hlp 5 SYS.SYSGROUPS =HDK3B9B1BC0@dbeng50w.hlp 5 SYS.SYSINDEXES =HDK3B9B1BD0@dbeng50w.hlp 5 SYS.SYSOPTIONS =HDK3B9B1BE0@dbeng50w.hlp 5 SYS.SYSPROCPARMS =HDK3B9B1BF0@dbeng50w.hlp 5 SYS.SYSREMOTEUSERS =HDK3B9B1C00@dbeng50w.hlp 5 SYS.SYSTABAUTH =HDK3B9B1C10@dbeng50w.hlp 5 SYS.SYSTRIGGERS =HDK3B9B1C20@dbeng50w.hlp 5 SYS.SYSUSERAUTH =HDK3B9B1C30@dbeng50w.hlp 5 SYS.SYSUSERLIST =HDK3B9B1C40@dbeng50w.hlp 5 SYS.SYSUSEROPTIONS =HDK3B9B1C50@dbeng50w.hlp 5 SYS.SYSUSERPERMS =HDK3B9B1C60@dbeng50w.hlp 5 SYS.SYSVIEWS =HDK3B9B1C70@dbeng50w.hlp :include servnt.cnt