: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 =_DocType_2@dbeng50w.hlp 1 About This Manual=_DocType_3@dbeng50w.hlp 2 PART 1. Introduction to SQL Anywhere 2 PART 1. Introduction to SQL Anywhere=_DocType_4@dbeng50w.hlp 3 CHAPTER 1. Introduction 3 CHAPTER 1. Introduction=ISQLINTR@dbeng50w.hlp 4 About SQL Anywhere 4 About SQL Anywhere=ABOUT_SQL_ANYWHERE@dbeng50w.hlp 4 Supplied components=ABOUT_SQL_ANYWHERE_1@dbeng50w.hlp 4 A DBMS for many platforms and environments=ABOUT_SQL_ANYWHERE_2@dbeng50w.hlp 3 Upgrading databases to SQL Anywhere=BIUP@dbeng50w.hlp 4 About this manual 4 About this manual=INATM@dbeng50w.hlp 4 Platforms and products covered=INATM_1@dbeng50w.hlp 4 Documentation overview=INATM_2@dbeng50w.hlp 5 Document conventions 5 Document conventions=INATM_3@dbeng50w.hlp 5 Typographic conventions=INATM_4@dbeng50w.hlp 5 Graphic icons=HTGI@dbeng50w.hlp 4 Product installation=INPRIN@dbeng50w.hlp 4 Contact information=BICT@dbeng50w.hlp 3 CHAPTER 2. New Features in SQL Anywhere 5 3 CHAPTER 2. New Features in SQL Anywhere 5=NEWF50@dbeng50w.hlp 3 What's in a name?=N5NC@dbeng50w.hlp 3 New features overview=N5OV@dbeng50w.hlp 3 New features in the Watcom-SQL language=N5SQ@dbeng50w.hlp 3 New sample database=N5SD@dbeng50w.hlp 3 CHAPTER 3. Overview of SQL Anywhere 3 CHAPTER 3. Overview of SQL Anywhere=ARCH@dbeng50w.hlp 3 The SQL Anywhere engine and the SQL Anywhere server=ARCES@dbeng50w.hlp 4 Running SQL Anywhere on a single computer 4 Running SQL Anywhere on a single computer=ARCBAS@dbeng50w.hlp 4 The client application=ARCLIENT@dbeng50w.hlp 4 The SQL Anywhere database engine=ARENG@dbeng50w.hlp 4 The database=ARBASE@dbeng50w.hlp 4 Running SQL Anywhere on a network 4 Running SQL Anywhere on a network=ARCMU@dbeng50w.hlp 4 SQL Anywhere multiplatform support=ARCSOS@dbeng50w.hlp 4 Some database terms=ARCTERM@dbeng50w.hlp 4 Running mixed operating systems on a single computer 4 Running mixed operating systems on a single computer=ARCOS@dbeng50w.hlp 4 DOS or Windows client applications on OS/2=WINOS2@dbeng50w.hlp 4 DOS or Windows 3.x clients on Windows 95 or NT=WIN16@dbeng50w.hlp 4 SQL Anywhere programming interfaces 4 SQL Anywhere programming interfaces=ARCINT@dbeng50w.hlp 4 Low-level programming interfaces=ARLOW@dbeng50w.hlp 4 High-level programming interfaces=ARHIGH@dbeng50w.hlp 4 The SQL Anywhere programs 4 The SQL Anywhere programs=ARCTOOL@dbeng50w.hlp 4 The SQL Anywhere database engine and server=ARDBENG@dbeng50w.hlp 4 The SQL Anywhere Desktop Runtime database engine=ARDBRUN@dbeng50w.hlp 4 The Sybase Central database management program=ARDBX@dbeng50w.hlp 4 SQL Anywhere administration utilities=ARDBUTIL@dbeng50w.hlp 2 PART 2. Tutorials 2 PART 2. Tutorials=ARDBUTIL_1@dbeng50w.hlp 3 CHAPTER 4. Managing Databases with Sybase Central 3 CHAPTER 4. Managing Databases with Sybase Central=SCENT@dbeng50w.hlp 3 Sybase Central and database management=SCOVER@dbeng50w.hlp 4 Navigating the main Sybase Central window 4 Navigating the main Sybase Central window=SCMAIN@dbeng50w.hlp 4 Start Sybase Central=SCMNST@dbeng50w.hlp 4 Connecting to a database from Sybase Central=SCCD@dbeng50w.hlp 4 Viewing a database schema=SCIC@dbeng50w.hlp 4 Adding a table to a database 4 Adding a table to a database=SCAT@dbeng50w.hlp 4 Create a table and adding columns in Sybase Central=SCAET@dbeng50w.hlp 4 Editing existing tables using the table editor=SCAET_1@dbeng50w.hlp 4 Dragging a column to a new table using Sybase Central=SCDCT@dbeng50w.hlp 4 Deleting tables using Sybase Central=SCDT@dbeng50w.hlp 4 Viewing and editing procedures 4 Viewing and editing procedures=SCAP@dbeng50w.hlp 4 Viewing stored procedure code with Sybase Central=SCVP@dbeng50w.hlp 4 Managing users and groups 4 Managing users and groups=SCMU@dbeng50w.hlp 4 Adding a group to the database=SCAUG@dbeng50w.hlp 4 Adding a user to the database=SCAU@dbeng50w.hlp 4 Adding a user to a group=SCAUUG@dbeng50w.hlp 3 Backing up a database using Sybase Central=SCBU@dbeng50w.hlp 4 Using the Sybase Central online help 4 Using the Sybase Central online help=SCOH@dbeng50w.hlp 4 Using the online help Contents=SCOHTC@dbeng50w.hlp 4 Using the online help Index=SCOHIN@dbeng50w.hlp 4 Searching the text of the online help=SCOHFT@dbeng50w.hlp 3 CHAPTER 5. Using ISQL 3 CHAPTER 5. Using ISQL=ISQLWIN@dbeng50w.hlp 3 The SQL Anywhere program group=IWPG@dbeng50w.hlp 3 Starting SQL Anywhere=IWSTART@dbeng50w.hlp 3 Connecting to the sample database from ISQL=WLOGON@dbeng50w.hlp 3 Accessing Help from ISQL=WHELPSEC@dbeng50w.hlp 3 The ISQL command window=IWCOMWIN@dbeng50w.hlp 3 Leaving ISQL=IWLEAVE@dbeng50w.hlp 4 Displaying data in ISQL 4 Displaying data in ISQL=IWDISP@dbeng50w.hlp 4 Scrolling the data window=IWSCROLL@dbeng50w.hlp 3 Command recall in ISQL=IWCOMREC@dbeng50w.hlp 3 Function keys=FUNCKEY@dbeng50w.hlp 3 Canceling an ISQL command=WABORT@dbeng50w.hlp 3 What's next?=IWWN@dbeng50w.hlp 3 CHAPTER 6. Using Character-Mode ISQL 3 CHAPTER 6. Using Character-Mode ISQL=ISQLDOS@dbeng50w.hlp 3 Tutorial files=TUTFDOS@dbeng50w.hlp 3 Starting the SQL Anywhere software=IDST@dbeng50w.hlp 3 Connecting to the sample database from ISQL=LOGON@dbeng50w.hlp 3 ISQL menu selection=IDMS@dbeng50w.hlp 3 Obtaining help from ISQL=HELPSEC@dbeng50w.hlp 3 The ISQL command window=IDCW@dbeng50w.hlp 3 Leaving ISQL=IDLI@dbeng50w.hlp 3 Displaying data in ISQL=IDDD@dbeng50w.hlp 3 Command window keys in ISQL=IDCK@dbeng50w.hlp 3 Scrolling the data window=IDSD@dbeng50w.hlp 3 Command recall in ISQL=IDCR@dbeng50w.hlp 3 Function keys=FUNCTION_KEYS@dbeng50w.hlp 3 Aborting an ISQL command=ABORT@dbeng50w.hlp 3 What next?=IDWN@dbeng50w.hlp 3 CHAPTER 7. Selecting Data from Database Tables 3 CHAPTER 7. Selecting Data from Database Tables=SELTUT@dbeng50w.hlp 3 Looking at the information in a table=SELLOOK@dbeng50w.hlp 3 Ordering query results=SELORDER@dbeng50w.hlp 3 Selecting columns from a table=SELCOL@dbeng50w.hlp 3 Selecting rows from a table=SELROW@dbeng50w.hlp 3 Comparing dates in queries=SELCOMP@dbeng50w.hlp 3 Compound search conditions in the WHERE clause=SELCMPD@dbeng50w.hlp 3 Pattern matching in search conditions=SELPAT@dbeng50w.hlp 3 Matching rows by sound=SELSOUND@dbeng50w.hlp 3 Short cuts for typing search conditions=SELSHORT@dbeng50w.hlp 3 CHAPTER 8. Joining Tables 3 CHAPTER 8. Joining Tables=JOINTAB@dbeng50w.hlp 3 Displaying a list of tables=JODISP@dbeng50w.hlp 3 Joining tables with the cross product=JOCROSS@dbeng50w.hlp 3 Restricting a join=JORESTR@dbeng50w.hlp 4 How tables are related 4 How tables are related=JORELAT@dbeng50w.hlp 4 Rows are identified by a primary key=JOPRIM@dbeng50w.hlp 4 Tables are related by a foreign key=JOFOR@dbeng50w.hlp 4 Join operators 4 Join operators=JOOP@dbeng50w.hlp 4 Joining tables using key joins=JOKEYJ@dbeng50w.hlp 4 Joining tables using natural joins=JONATJ@dbeng50w.hlp 3 CHAPTER 9. Obtaining Aggregate Data 3 CHAPTER 9. Obtaining Aggregate Data=AGDATA@dbeng50w.hlp 3 A first look at aggregate functions=AGINTRO@dbeng50w.hlp 3 Using aggregate functions to obtain grouped data=AGGROUP@dbeng50w.hlp 3 Restricting groups=AGRESTR@dbeng50w.hlp 3 CHAPTER 10. Updating the Database 3 CHAPTER 10. Updating the Database=UPDATDB@dbeng50w.hlp 3 Adding rows to a table=UPADD@dbeng50w.hlp 3 Modifying rows in a table=UPMOD@dbeng50w.hlp 3 Canceling changes=UPCANCEL@dbeng50w.hlp 3 Making changes permanent=UPCOMMIT@dbeng50w.hlp 3 Deleting rows=UPDEL@dbeng50w.hlp 4 Validity checking 4 Validity checking=INTEGR@dbeng50w.hlp 4 Inserting duplicate data=UPERDUP@dbeng50w.hlp 4 Inserting incorrect values=UPERINC@dbeng50w.hlp 4 Errors on DELETE or UPDATE=UPERDEL@dbeng50w.hlp 3 CHAPTER 11. Introduction to Views 3 CHAPTER 11. Introduction to Views=VIEWS@dbeng50w.hlp 3 Defining a view=VWDV@dbeng50w.hlp 3 Using views for security=VWSC@dbeng50w.hlp 3 CHAPTER 12. Introduction to Subqueries 3 CHAPTER 12. Introduction to Subqueries=SUBQRY@dbeng50w.hlp 3 Preparing to use subqueries=SUBINTRO@dbeng50w.hlp 3 A simple subquery=SUBSIMP@dbeng50w.hlp 3 Comparisons using subqueries=SUBCOMP@dbeng50w.hlp 3 Using subqueries instead of joins=SUBINJO@dbeng50w.hlp 3 CHAPTER 13. Command Files 3 CHAPTER 13. Command Files=COMMFIL@dbeng50w.hlp 3 Entering multiple statements in the ISQL Command window=COMEDIT@dbeng50w.hlp 3 Saving statements as command files=COMCF@dbeng50w.hlp 3 Command files with parameters=COMFILP@dbeng50w.hlp 3 CHAPTER 14. System Tables 3 CHAPTER 14. System Tables=ST@dbeng50w.hlp 3 The SYSCATALOG table=SPCAT@dbeng50w.hlp 3 The SYSCOLUMNS table=SPCOL@dbeng50w.hlp 3 Other system tables=SPOTHER@dbeng50w.hlp 2 PART 3. Using SQL Anywhere 2 PART 3. Using SQL Anywhere=SPOTHER_1@dbeng50w.hlp 3 CHAPTER 15. Connecting to a Database 3 CHAPTER 15. Connecting to a Database=CONDB@dbeng50w.hlp 4 Connection overview 4 Connection overview=CONCONN@dbeng50w.hlp 4 Database connection parameters=CONPARM@dbeng50w.hlp 4 Connection keyword meanings=CONMEAN@dbeng50w.hlp 4 How client applications connect to a database=CONHOW@dbeng50w.hlp 3 Connecting from the SQL Anywhere utilities=CONTOOL@dbeng50w.hlp 4 Connecting from an ODBC-enabled application 4 Connecting from an ODBC-enabled application=CONODBC@dbeng50w.hlp 4 SQL Anywhere support for ODBC=CONWODB@dbeng50w.hlp 4 Using ODBC under Windows and Windows NT=CONODWIN@dbeng50w.hlp 4 Files needed for ODBC connections=CONODDR@dbeng50w.hlp 4 Working with ODBC data sources=CONODDS@dbeng50w.hlp 4 Using the ODBC Administrator=CONODAD@dbeng50w.hlp 4 Adding an ODBC data source=CONADDS@dbeng50w.hlp 4 Some sample ODBC data sources=SAMPLE_ODBC_LOCAL@dbeng50w.hlp 4 Modifying an existing ODBC data source=CONMODS@dbeng50w.hlp 4 Removing an ODBC data source=CONRMDS@dbeng50w.hlp 4 Using ODBC under OS/2=CONODOS@dbeng50w.hlp 4 Using ODBC under DOS and QNX=CONODDQ@dbeng50w.hlp 3 CHAPTER 16. Designing Your Database 3 CHAPTER 16. Designing Your Database=DBDSGN@dbeng50w.hlp 4 Relational database concepts 4 Relational database concepts=DBCONC@dbeng50w.hlp 4 Database tables=DBTAB@dbeng50w.hlp 4 Keys in relational databases=DBPFK@dbeng50w.hlp 4 Each table has a primary key=DBPKEY@dbeng50w.hlp 4 Tables are related by foreign keys=DBFKEY@dbeng50w.hlp 4 Other database objects=DBOTH@dbeng50w.hlp 3 Planning the database=DBPLAN@dbeng50w.hlp 4 The design process 4 The design process=DBPROC@dbeng50w.hlp 4 Step 1: identify entities and relationships=DBST1@dbeng50w.hlp 4 Entity and relationship example=DBST1_1@dbeng50w.hlp 4 Step 2: identify the required data=DBST2@dbeng50w.hlp 4 Step 3: normalize the data=DBST3@dbeng50w.hlp 4 Step 4: resolve the relationships=DBST4@dbeng50w.hlp 4 Step 5: verify the design=DBST5@dbeng50w.hlp 4 Designing the database table properties 4 Designing the database table properties=DBTABS@dbeng50w.hlp 4 Choosing column names=DBASCOL@dbeng50w.hlp 4 Choosing data types for columns=DBASDT@dbeng50w.hlp 4 Choosing constraints=DBASCON@dbeng50w.hlp 4 Choosing primary and foreign keys=DBASPFK@dbeng50w.hlp 3 CHAPTER 17. Working with Database Objects 3 CHAPTER 17. Working with Database Objects=BUILDDB@dbeng50w.hlp 3 Using Sybase Central to work with database objects=BLDDBX@dbeng50w.hlp 3 Using ISQL to work with database objects=BLDISQL@dbeng50w.hlp 4 Working with databases 4 Working with databases=BLDTOOL@dbeng50w.hlp 4 Initializing a database=BLDINIT@dbeng50w.hlp 4 Adding database files=BLDDBMOD@dbeng50w.hlp 4 Preallocating space for database files=BLDDBPR@dbeng50w.hlp 4 Erasing a database=BLDERAS@dbeng50w.hlp 4 Working with tables 4 Working with tables=BLDCREA@dbeng50w.hlp 4 Creating tables=BLDTABS@dbeng50w.hlp 4 Altering tables=BLDALT@dbeng50w.hlp 4 Deleting tables=BLDDT@dbeng50w.hlp 4 Creating primary and foreign keys=BLDPFK@dbeng50w.hlp 4 Table information in the system tables=BLDIT@dbeng50w.hlp 4 Working with views 4 Working with views=BLDVIEW@dbeng50w.hlp 4 Creating views=BLDCV@dbeng50w.hlp 4 Using views=BLDUV@dbeng50w.hlp 4 Using the WITH CHECK OPTION clause=BLDUVWC@dbeng50w.hlp 4 Modifying views=BLDMV@dbeng50w.hlp 4 Permissions on views=BLDVP@dbeng50w.hlp 4 Deleting views=BLDRV@dbeng50w.hlp 4 Views in the system tables=BLDIV@dbeng50w.hlp 4 Working with indexes 4 Working with indexes=BLDIND@dbeng50w.hlp 4 Indexes in the system tables=BLDII@dbeng50w.hlp 3 CHAPTER 18. Ensuring Data Integrity 3 CHAPTER 18. Ensuring Data Integrity=INTEGRIT@dbeng50w.hlp 4 Data integrity overview 4 Data integrity overview=INTOVR@dbeng50w.hlp 4 How data can become invalid=INTVALID@dbeng50w.hlp 4 Integrity constraints belong in the database=INTRESP@dbeng50w.hlp 4 How database contents get changed=INTCHANG@dbeng50w.hlp 4 Data integrity tools in SQL Anywhere=INTPROT@dbeng50w.hlp 4 SQL statements for implementing integrity constraints=INTCOM@dbeng50w.hlp 4 Using column defaults 4 Using column defaults=INTDEFAULT@dbeng50w.hlp 4 Creating column defaults=INTCOLDEF@dbeng50w.hlp 4 Modifying and deleting column defaults=INTCOLMOD@dbeng50w.hlp 4 Working with column defaults in Sybase Central=INTDCSC@dbeng50w.hlp 4 Current date and time defaults=INTDCDT@dbeng50w.hlp 4 The user ID default=INTDUID@dbeng50w.hlp 4 The autoincrement default=INTDAI@dbeng50w.hlp 4 The NULL default=INTDNULL@dbeng50w.hlp 4 String and number defaults=INTDSN@dbeng50w.hlp 4 Constant expression defaults=INTDCE@dbeng50w.hlp 4 Using table and column constraints 4 Using table and column constraints=INTTAB@dbeng50w.hlp 4 Using CHECK conditions on columns=INTCOLCH@dbeng50w.hlp 4 Column CHECK conditions from user-defined data types=INTDTCH@dbeng50w.hlp 4 Working with column constraints in Sybase Central=INTDTSC@dbeng50w.hlp 4 Using CHECK conditions on tables=INTTABCH@dbeng50w.hlp 4 Modifying and deleting CHECK conditions=INTMOD@dbeng50w.hlp 4 Enforcing entity and referential integrity 4 Enforcing entity and referential integrity=INTREL@dbeng50w.hlp 4 Enforcing entity integrity=INTENF@dbeng50w.hlp 4 If a client application breaches entity integrity=INTCLI@dbeng50w.hlp 4 Primary keys enforce entity integrity=INTPRIM@dbeng50w.hlp 4 Enforcing referential integrity=INTENFR@dbeng50w.hlp 4 Foreign keys enforce referential integrity=INTCREFOR@dbeng50w.hlp 4 Losing referential integrity=INTLOSE@dbeng50w.hlp 4 If a client application breaches referential integrity=INTCLIREF@dbeng50w.hlp 4 Referential integrity actions=INTREFACT@dbeng50w.hlp 4 Referential integrity checking=REFCHCK@dbeng50w.hlp 3 Integrity rules in the system tables=INTREVW@dbeng50w.hlp 3 CHAPTER 19. Using Transactions and Locks 3 CHAPTER 19. Using Transactions and Locks=UTL@dbeng50w.hlp 4 An overview of transactions 4 An overview of transactions=TRANOVR@dbeng50w.hlp 4 Transactions and data recovery=TRREC@dbeng50w.hlp 4 Transactions and concurrency=TRCONC@dbeng50w.hlp 4 Three types of inconsistency=UTLTYPE@dbeng50w.hlp 4 Using locks to ensure consistency=UTLLOCO@dbeng50w.hlp 3 How locking works=TRANLOCK@dbeng50w.hlp 4 Isolation levels and consistency 4 Isolation levels and consistency=UDTISOL@dbeng50w.hlp 4 Locks and isolation levels=UDTLOIS@dbeng50w.hlp 4 Changing the isolation level=UDTCHAN@dbeng50w.hlp 4 How SQL Anywhere handles locking conflicts 4 How SQL Anywhere handles locking conflicts=TRLCON@dbeng50w.hlp 4 Locking conflicts and transaction blocking=TRBLOCK@dbeng50w.hlp 4 Transaction blocking and deadlock=TRBLDED@dbeng50w.hlp 4 Choosing an isolation level 4 Choosing an isolation level=UDTCHIS@dbeng50w.hlp 4 Typical level 0 transactions=UDT0@dbeng50w.hlp 4 Transactions for which no updates are lost=UDTNU@dbeng50w.hlp 4 Serializable transactions=UDTSER@dbeng50w.hlp 3 Savepoints within transactions=TRSAVE@dbeng50w.hlp 4 Particular concurrency issues 4 Particular concurrency issues=TRPARTIC@dbeng50w.hlp 4 Primary key generation=MPKEY@dbeng50w.hlp 4 Data definition statements and concurrency=DDLCON@dbeng50w.hlp 4 Coordinating transactions with multiple database engines=TWOPHASE@dbeng50w.hlp 4 Transactions and portable computers 4 Transactions and portable computers=LAPTOP@dbeng50w.hlp 4 Applying updates from a portable computer=LAPUPD@dbeng50w.hlp 4 Distributing applications that do not require server updates=LAPDIST@dbeng50w.hlp 4 Working with large databases on portable computers=LAPLARG@dbeng50w.hlp 3 CHAPTER 20. Using Procedures, Triggers, and Batches 3 CHAPTER 20. Using Procedures, Triggers, and Batches=PT@dbeng50w.hlp 3 Procedure and trigger overview=PTOV@dbeng50w.hlp 3 Benefits of procedures and triggers=PTBN@dbeng50w.hlp 4 Introduction to procedures 4 Introduction to procedures=PTIP@dbeng50w.hlp 4 Creating procedures=PTIPCP@dbeng50w.hlp 4 Calling procedures=PTIPCA@dbeng50w.hlp 4 Dropping procedures=PTIPDP@dbeng50w.hlp 4 Permissions to execute procedures=PTIPEP@dbeng50w.hlp 4 Returning procedure results in parameters=PTIPRP@dbeng50w.hlp 4 Returning procedure results in result sets=PTIPRS@dbeng50w.hlp 4 Introduction to user-defined functions 4 Introduction to user-defined functions=PTIF@dbeng50w.hlp 4 Creating user-defined functions=PTIFCF@dbeng50w.hlp 4 Calling user-defined functions=PTIFCA@dbeng50w.hlp 4 Dropping user-defined functions=PTIFDF@dbeng50w.hlp 4 Permissions to execute user-defined functions=PTIFEF@dbeng50w.hlp 4 Introduction to triggers 4 Introduction to triggers=PTIT@dbeng50w.hlp 4 Creating triggers=PTITCT@dbeng50w.hlp 4 Executing triggers=PTITET@dbeng50w.hlp 4 Dropping triggers=PTITDT@dbeng50w.hlp 4 Trigger execution permissions=PTITEP@dbeng50w.hlp 3 Introduction to batches=PTIB@dbeng50w.hlp 4 Control statements 4 Control statements=CONTROL@dbeng50w.hlp 4 Using compound statements=PTSTCS@dbeng50w.hlp 4 Declarations in compound statements=PTSTDC@dbeng50w.hlp 4 Atomic compound statements=PTSTAS@dbeng50w.hlp 4 The structure of procedures and triggers 4 The structure of procedures and triggers=PTST@dbeng50w.hlp 4 SQL statements allowed in procedures and triggers=PTSTSS@dbeng50w.hlp 4 Declaring procedure parameters=PTSTPP@dbeng50w.hlp 4 Passing parameters to procedures=PTPPCS@dbeng50w.hlp 4 Passing parameters to functions=PTPPFN@dbeng50w.hlp 4 Returning results from procedures 4 Returning results from procedures=PTRR@dbeng50w.hlp 4 Returning a value using the RETURN statement=PTRRRS@dbeng50w.hlp 4 Returning results as procedure parameters=PTRRSR@dbeng50w.hlp 4 Returning result sets from procedures=PTRRMR@dbeng50w.hlp 4 Returning multiple result sets from procedures=PTRRMRS@dbeng50w.hlp 4 Returning variable result sets from procedures=PTRRMRS_1@dbeng50w.hlp 4 Using cursors in procedures and triggers 4 Using cursors in procedures and triggers=PTUC@dbeng50w.hlp 4 Cursor management overview=PTUCOV@dbeng50w.hlp 4 Using cursors on SELECT statements in procedures=PTUCSS@dbeng50w.hlp 4 Errors and warnings in procedures and triggers 4 Errors and warnings in procedures and triggers=PTEW@dbeng50w.hlp 4 Default error handling in procedures and triggers=PTEWNH@dbeng50w.hlp 4 Default handling of warnings in procedures and triggers=PTEWWH@dbeng50w.hlp 4 Using exception handlers in procedures and triggers=PTEWEH@dbeng50w.hlp 4 Nested compound statements and exception handlers=PTEWNC@dbeng50w.hlp 3 Using the EXECUTE IMMEDIATE statement in procedures=PTEI@dbeng50w.hlp 3 Transactions and savepoints in procedures and triggers=TRANP@dbeng50w.hlp 4 Some hints for writing procedures 4 Some hints for writing procedures=PRTIPS@dbeng50w.hlp 4 Check if you need to change the command delimiter=PRTCOMDEL@dbeng50w.hlp 4 Remember to delimit statements within your procedure=PRTSC@dbeng50w.hlp 4 Use fully-qualified names for tables in procedures=PRTREF@dbeng50w.hlp 4 Specifying dates and times in procedures=PTHIDT@dbeng50w.hlp 4 Verifying that procedure input arguments are passed correctly=PTHIVP@dbeng50w.hlp 4 Statements allowed in batches 4 Statements allowed in batches=BCAS@dbeng50w.hlp 4 Using SELECT statements in batches=BCASSL@dbeng50w.hlp 4 Calling external libraries from stored procedures 4 Calling external libraries from stored procedures=PTXL@dbeng50w.hlp 4 Creating procedures and functions with external calls=PTXLCP@dbeng50w.hlp 4 External function declarations=PTXLEF@dbeng50w.hlp 4 How parameters are passed to the external function=PTXLPP@dbeng50w.hlp 4 Special considerations when passing character types=PTXLCD@dbeng50w.hlp 3 CHAPTER 21. Monitoring and Improving Performance 3 CHAPTER 21. Monitoring and Improving Performance=PERFORM@dbeng50w.hlp 3 Factors affecting database performance=PFFACT@dbeng50w.hlp 4 Using keys to improve query performance 4 Using keys to improve query performance=KEYS@dbeng50w.hlp 4 Using ISQL to examine query performance=INEXAM@dbeng50w.hlp 4 Using primary keys to improve query performance=INPRIM@dbeng50w.hlp 4 Using foreign keys to improve query performance=INFOR@dbeng50w.hlp 4 Using indexes to improve query performance 4 Using indexes to improve query performance=INDEX@dbeng50w.hlp 4 How indexes work=PERIND@dbeng50w.hlp 3 Search strategies for queries from more than one table=OPTJOIN@dbeng50w.hlp 3 Sorting query results=INSORT@dbeng50w.hlp 3 Temporary tables used in query processing=TEMPTABLES@dbeng50w.hlp 4 How the optimizer works 4 How the optimizer works=PEROPT@dbeng50w.hlp 4 Optimizer estimates=PEROPES@dbeng50w.hlp 4 Self tuning of the query optimizer=PERSELF@dbeng50w.hlp 4 Providing estimates to improve query performance=ESTIMAT@dbeng50w.hlp 4 Monitoring database performance 4 Monitoring database performance=PFMN@dbeng50w.hlp 4 Obtaining database statistics from a client application=PFFN@dbeng50w.hlp 4 Monitoring database statistics from Sybase Central=PFSC@dbeng50w.hlp 4 Monitoring database statistics from the NT Performance Monitor=PFNT@dbeng50w.hlp 3 CHAPTER 22. Database Collations 3 CHAPTER 22. Database Collations=COLLAT@dbeng50w.hlp 4 Collation overview 4 Collation overview=NLOV@dbeng50w.hlp 4 Character sets in applications and databases=NLOVAD@dbeng50w.hlp 4 Character encodings=NLOVCE@dbeng50w.hlp 4 Displaying your current character settings=NLOVOS@dbeng50w.hlp 4 Collation sequences=NLOVCL@dbeng50w.hlp 4 Support for multibyte character sets 4 Support for multibyte character sets=NLMB@dbeng50w.hlp 4 Variable length character sets=NLMBVC@dbeng50w.hlp 4 First-byte collation orderings=NLMBCS@dbeng50w.hlp 3 Choosing a character set=NLCH@dbeng50w.hlp 3 Creating custom collations=NLCC@dbeng50w.hlp 4 The collation file format 4 The collation file format=CLFF@dbeng50w.hlp 4 Comment lines=CLFFCL@dbeng50w.hlp 4 The title line=CLFFTL@dbeng50w.hlp 4 The collation sequence section=CLFFCS@dbeng50w.hlp 4 The Encodings section=CLFFES@dbeng50w.hlp 4 The Properties section=CLFFPS@dbeng50w.hlp 3 CHAPTER 23. Importing and Exporting Data 3 CHAPTER 23. Importing and Exporting Data=LOAD@dbeng50w.hlp 4 Import and export overview 4 Import and export overview=LOOV@dbeng50w.hlp 4 Input and output data formats=LOFORM@dbeng50w.hlp 4 Exporting data from a database 4 Exporting data from a database=LOEX@dbeng50w.hlp 4 Unloading data using the UNLOAD TABLE statement=LOUT@dbeng50w.hlp 4 Exporting data using the ISQL OUTPUT statement=LOEXOUT@dbeng50w.hlp 4 Output redirection=REDIREC@dbeng50w.hlp 4 NULL value output=LOEXNUL@dbeng50w.hlp 4 Unloading a database using DBUNLOAD=LOEXDBU@dbeng50w.hlp 4 Importing data into a database 4 Importing data into a database=LOIM@dbeng50w.hlp 4 Loading data using the LOAD TABLE statement=LOLT@dbeng50w.hlp 4 Importing data using the ISQL INPUT statement=LOIMPFI@dbeng50w.hlp 4 Loading data interactively=LOIMPIN@dbeng50w.hlp 4 Handling conversion errors on data import=LOIMPCO@dbeng50w.hlp 4 Loading data that does not match the table structure=LOIMPSE@dbeng50w.hlp 3 Tuning bulk operations=BULK@dbeng50w.hlp 3 CHAPTER 24. Managing User IDs and Permissions 3 CHAPTER 24. Managing User IDs and Permissions=PERMS@dbeng50w.hlp 4 An overview of database permissions 4 An overview of database permissions=UOVRDBP@dbeng50w.hlp 4 DBA authority overview=PERDBAO@dbeng50w.hlp 4 Resource authority overview=PERRESO@dbeng50w.hlp 4 Ownership permissions overview=PEROWNO@dbeng50w.hlp 4 Table and views permissions overview=PERTABO@dbeng50w.hlp 4 Procedures permissions overview=PERPROCO@dbeng50w.hlp 4 Group permissions overview=PERGRPO@dbeng50w.hlp 4 Managing individual user IDs and permissions 4 Managing individual user IDs and permissions=UMANPER@dbeng50w.hlp 4 Creating new users=UMANNEW@dbeng50w.hlp 4 Changing a password=UMANPWD@dbeng50w.hlp 4 Granting DBA and resource authority=UMANGPU@dbeng50w.hlp 4 Granting permissions on tables and views=PERGRTV@dbeng50w.hlp 4 Granting users the right to grant permissions=PERGRWG@dbeng50w.hlp 4 Granting permissions on procedures=PEREXP@dbeng50w.hlp 4 Execution permissions of triggers=PERTRIG@dbeng50w.hlp 4 Revoking user permissions=UMANREV@dbeng50w.hlp 4 Managing groups 4 Managing groups=UMANGP@dbeng50w.hlp 4 Creating groups=UGNEW@dbeng50w.hlp 4 Granting group membership to users=UGGRANT@dbeng50w.hlp 4 Permissions of groups=UGPERM@dbeng50w.hlp 4 Referring to tables owned by groups=GRPTAB@dbeng50w.hlp 4 Groups without passwords=UGNOP@dbeng50w.hlp 4 Special groups=USPECIAL@dbeng50w.hlp 3 Database object names and prefixes=UDNS@dbeng50w.hlp 4 Using views and procedures for extra security 4 Using views and procedures for extra security=UVP@dbeng50w.hlp 4 Using views for tailored security=UVTS@dbeng50w.hlp 4 Using procedures for tailored security=UVPROC@dbeng50w.hlp 3 How SQL Anywhere assesses user permissions=UHOW@dbeng50w.hlp 3 Users and permissions in the system tables=UINFO@dbeng50w.hlp 3 CHAPTER 25. Backup and Data Recovery 3 CHAPTER 25. Backup and Data Recovery=BACKUP@dbeng50w.hlp 3 System and media failures=BACKOVRVW@dbeng50w.hlp 4 The SQL Anywhere logs 4 The SQL Anywhere logs=LOGS@dbeng50w.hlp 5 The checkpoint log 5 The checkpoint log=CHECKP@dbeng50w.hlp 5 Checkpoint priority=CHECKP_1@dbeng50w.hlp 5 How the database decides when to checkpoint=CHECKP_2@dbeng50w.hlp 4 The rollback log=BKROLL@dbeng50w.hlp 4 The transaction log=HREDO@dbeng50w.hlp 4 Converting transaction logs to SQL=BKTLCON@dbeng50w.hlp 4 Using a transaction log mirror 4 Using a transaction log mirror=BKMI@dbeng50w.hlp 4 Creating and dropping a transaction log mirror=BKMISS@dbeng50w.hlp 4 Erasing transaction log mirrors=BKMIER@dbeng50w.hlp 4 Validating the transaction log on database startup=BKMIVL@dbeng50w.hlp 4 Recovering from a corrupt transaction log or mirror=BKMICL@dbeng50w.hlp 4 Backing up your database 4 Backing up your database=BACKUPS@dbeng50w.hlp 4 Performing a full backup=BKFULL@dbeng50w.hlp 4 Performing an incremental backup=BKINC@dbeng50w.hlp 4 Recovery from system failure 4 Recovery from system failure=SYSFAIL@dbeng50w.hlp 4 Quick recovery with a live backup=QUICK_RECOVERY_WITH_A_LIVE_BACKUP@dbeng50w.hlp 4 Recovery from media failure 4 Recovery from media failure=MEDIAFAIL@dbeng50w.hlp 4 Media failure on the database file=DBMEDIA@dbeng50w.hlp 4 Media failure on the transaction log=BKMEDRED@dbeng50w.hlp 4 Recovering uncommitted changes=BKRUNC@dbeng50w.hlp 3 CHAPTER 26. Introduction to SQL Remote Replication 3 CHAPTER 26. Introduction to SQL Remote Replication=WR@dbeng50w.hlp 3 Introduction to data replication=WRINTR@dbeng50w.hlp 4 SQL Remote concepts 4 SQL Remote concepts=WRCONC@dbeng50w.hlp 4 Consolidated and remote databases=WRCONC_1@dbeng50w.hlp 4 Message-based replication=WRCONC_2@dbeng50w.hlp 4 The Message Agent=WRCONC_3@dbeng50w.hlp 4 Publications and subscriptions=WRCONC_4@dbeng50w.hlp 4 Remote database users=WRCONC_5@dbeng50w.hlp 4 SQL Remote features 4 SQL Remote features=WRFEAT@dbeng50w.hlp 4 Transaction log-based replication=WRFEAT_1@dbeng50w.hlp 4 Central administration=WRCENAD@dbeng50w.hlp 4 Support for many subscribers=WRMANY@dbeng50w.hlp 4 Economical resource requirements=WRFOOT@dbeng50w.hlp 3 Message systems supported by SQL Remote=WRMSG@dbeng50w.hlp 4 Tutorial: setting up SQL Remote using Sybase Central 4 Tutorial: setting up SQL Remote using Sybase Central=WRSET@dbeng50w.hlp 4 Preparing for the Sybase Central replication tutorial=WRPR@dbeng50w.hlp 4 Set up the consolidated database in Sybase Central 4 Set up the consolidated database in Sybase Central=WRCD@dbeng50w.hlp 4 Add a SQL Remote message type=WRCDCF@dbeng50w.hlp 4 Add the publisher and remote user to the database=WRCDGR@dbeng50w.hlp 4 Add publications and subscriptions=WRCDPS@dbeng50w.hlp 3 Set up the remote database in Sybase Central=WRSR@dbeng50w.hlp 4 Tutorial: setting up SQL Remote using ISQL and DBXTRACT 4 Tutorial: setting up SQL Remote using ISQL and DBXTRACT=WRSET2@dbeng50w.hlp 4 Preparing for the replication tutorial=WRPR2@dbeng50w.hlp 4 Set up the consolidated database 4 Set up the consolidated database=WRCD2@dbeng50w.hlp 4 Create a SQL Remote message type=WRCDCF2@dbeng50w.hlp 4 Grant PUBLISH and REMOTE at the consolidated database=WRCDGR2@dbeng50w.hlp 4 Create publications and subscriptions=WRCDPS2@dbeng50w.hlp 4 Set up the remote database 4 Set up the remote database=WRSR2@dbeng50w.hlp 4 Extract the remote database information=WRRDCD2@dbeng50w.hlp 4 Load the remote database information=WRRDLF2@dbeng50w.hlp 4 Start replicating data 4 Start replicating data=WRRD2@dbeng50w.hlp 4 Send data from the consolidated database=WRRDSD@dbeng50w.hlp 4 Receive data at the remote database=WRRDRD2@dbeng50w.hlp 4 Replicate from the remote database to the consolidated database=WRRDRC2@dbeng50w.hlp 3 A sample publication=WRSP@dbeng50w.hlp 4 Some sample SQL Remote setups 4 Some sample SQL Remote setups=WRAPP@dbeng50w.hlp 4 Server-to-laptop replication for mobile workforces=WRMOBILE@dbeng50w.hlp 4 Server-to-server replication among offices=WROFFICE@dbeng50w.hlp 3 CHAPTER 27. SQL Remote Administration 3 CHAPTER 27. SQL Remote Administration=W2@dbeng50w.hlp 3 SQL Remote administration overview=WRAD@dbeng50w.hlp 4 SQL Remote message types 4 SQL Remote message types=WRMM@dbeng50w.hlp 4 Supported message types=SUPPORTED_MESSAGE_TYPES@dbeng50w.hlp 4 Specifying a message type=SUPPORTED_MESSAGE_TYPES_1@dbeng50w.hlp 5 Message link control parameters 5 Message link control parameters=MESSAGE_LINK_PARAMETERS@dbeng50w.hlp 5 FILE message control parameters=MESSAGE_LINK_PARAMETERS_1@dbeng50w.hlp 5 MAPI message control parameters=MESSAGE_LINK_PARAMETERS_2@dbeng50w.hlp 5 SMTP message control parameters=MESSAGE_LINK_PARAMETERS_3@dbeng50w.hlp 5 VIM message control parameters=MESSAGE_LINK_PARAMETERS_4@dbeng50w.hlp 4 Managing SQL Remote permissions 4 Managing SQL Remote permissions=WRMP@dbeng50w.hlp 4 Granting and revoking PUBLISH permissions=WRMP_1@dbeng50w.hlp 4 Granting and revoking REMOTE and CONSOLIDATE permissions=WRMPSE@dbeng50w.hlp 4 Setting up publications 4 Setting up publications=WRPB@dbeng50w.hlp 4 Publishing a set of tables=WRPBST@dbeng50w.hlp 4 Publishing a subset of columns=WRPBSC@dbeng50w.hlp 4 Publishing a subset of rows using a WHERE clause=WRPBWH@dbeng50w.hlp 4 Publishing a subset of rows using a SUBSCRIBE BY expression=WRPBXP@dbeng50w.hlp 4 Dropping publications=WRPBAP@dbeng50w.hlp 4 Notes on publications=WRPBNP@dbeng50w.hlp 4 Designing publications 4 Designing publications=WRDP@dbeng50w.hlp 4 Replication error and conflict overview=WRDPCO@dbeng50w.hlp 4 Designing to avoid primary key errors=WRDBIN@dbeng50w.hlp 4 Handling UPDATE conflicts=WRDBUP@dbeng50w.hlp 4 Designing to avoid referential integrity errors=WRDPIN@dbeng50w.hlp 4 Designing triggers to avoid errors=WRDPPT@dbeng50w.hlp 4 Using subqueries in publications =WRUPSQ@dbeng50w.hlp 4 SUBSCRIBE BY subqueries returning multiple values=WRSUBMUL@dbeng50w.hlp 3 Setting up subscriptions=WRSB@dbeng50w.hlp 4 Synchronizing databases 4 Synchronizing databases=WRSD@dbeng50w.hlp 4 Using the extraction utility to synchronize databases=WRSDXT@dbeng50w.hlp 4 Limits to using the extraction utility=WRSDXL@dbeng50w.hlp 4 Synchronizing data over a message system=WRSDIS@dbeng50w.hlp 4 Notes on synchronization=WRSDNS@dbeng50w.hlp 4 How statements are replicated by SQL Remote 4 How statements are replicated by SQL Remote=WRSS@dbeng50w.hlp 4 Replication of inserts and deletes=WRID@dbeng50w.hlp 4 Replication of updates=WRUD@dbeng50w.hlp 4 Replication of procedures and triggers=WRPT@dbeng50w.hlp 4 Replication of procedures=WRPROC@dbeng50w.hlp 4 Replication of triggers=WRTRIG@dbeng50w.hlp 4 Replication of data definition statements=WRDDL@dbeng50w.hlp 4 Replication of blobs =REPLICATION_OF_LONG_VALUES@dbeng50w.hlp 3 Managing a running SQL Remote setup: overview=WRAS@dbeng50w.hlp 4 Running the SQL Remote Message Agent 4 Running the SQL Remote Message Agent=WRMA@dbeng50w.hlp 4 The Message Agent and replication security=WRMASE@dbeng50w.hlp 4 Running the Message Agent when recovery is difficult=WRMASE_1@dbeng50w.hlp 4 The SQL Remote message tracking system 4 The SQL Remote message tracking system=WRMT@dbeng50w.hlp 4 Status information in the SYSREMOTEUSER system table=WRMTST@dbeng50w.hlp 4 Tracking messages by transaction log offsets=WRMTTM@dbeng50w.hlp 4 Handling of lost or corrupt messages=WRMTRM@dbeng50w.hlp 4 Transaction log and backup management for SQL Remote 4 Transaction log and backup management for SQL Remote=WRTL@dbeng50w.hlp 4 Using the DELETE_OLD_LOGS option=WRTLDL@dbeng50w.hlp 4 Backup procedures at remote databases=WRTLRD@dbeng50w.hlp 4 Upgrading consolidated databases=WRTLRD_1@dbeng50w.hlp 4 The Unload utility and replication=WRTLUU@dbeng50w.hlp 4 Error reporting and conflict resolution in SQL Remote 4 Error reporting and conflict resolution in SQL Remote=WRCH@dbeng50w.hlp 4 Error reporting and conflict resolution=WRCHCH@dbeng50w.hlp 4 Error reporting in the Message Agent output=WRCHRP@dbeng50w.hlp 4 RESOLVE UPDATE triggers=WRCHRT@dbeng50w.hlp 4 UPDATE conflict resolution examples=WRCHEX@dbeng50w.hlp 4 Using passthrough mode for administration 4 Using passthrough mode for administration=WRPA@dbeng50w.hlp 4 Uses and limitations of passthrough mode,l0o=WRPAUS@dbeng50w.hlp 4 Stored procedures and control statements in passthrough mode=WRPAUS_1@dbeng50w.hlp 3 CHAPTER 28. Running Programs as Services 3 CHAPTER 28. Running Programs as Services=NTS@dbeng50w.hlp 3 Introduction to services=NTSUS@dbeng50w.hlp 4 Managing services 4 Managing services=NTSSM@dbeng50w.hlp 4 Service polling frequency=POLL@dbeng50w.hlp 4 Adding and removing SQL Anywhere services 4 Adding and removing SQL Anywhere services=NEWSV@dbeng50w.hlp 4 Adding a SQL Anywhere service=NEWSV_1@dbeng50w.hlp 4 Removing a SQL Anywhere service=REMSV@dbeng50w.hlp 4 Configuring SQL Anywhere services 4 Configuring SQL Anywhere services=EDITSV@dbeng50w.hlp 4 Setting the startup option=EDITST@dbeng50w.hlp 4 Entering command-line switches=NTSCFCL@dbeng50w.hlp 4 Setting the account options=EDITLOG@dbeng50w.hlp 4 Changing the executable file=NTSCE@dbeng50w.hlp 4 Adding new databases to a server or engine service=NEWDB@dbeng50w.hlp 4 Starting and stopping services 4 Starting and stopping services=NTSSS@dbeng50w.hlp 4 Starting a SQL Anywhere service=STARTSV@dbeng50w.hlp 4 Stopping a SQL Anywhere service=STOPSV@dbeng50w.hlp 4 Pausing a SQL Anywhere service=PAUSESV@dbeng50w.hlp 4 Running more than one service 4 Running more than one service=PROBSV@dbeng50w.hlp 4 Service dependencies=PROBSV_1@dbeng50w.hlp 4 Service groups overview=PROBSV_2@dbeng50w.hlp 4 Managing service dependencies=PROBSV_3@dbeng50w.hlp 4 Possible problems running more than one server as a service=PROBSV_4@dbeng50w.hlp 3 Monitoring a SQL Anywhere network server service=NTSMO@dbeng50w.hlp 3 The Windows NT Control Panel Service Manager=NTSCPSM@dbeng50w.hlp 2 PART 4. Transact-SQL Compatibility 2 PART 4. Transact-SQL Compatibility=NTSCPSM_1@dbeng50w.hlp 3 CHAPTER 29. Using Transact-SQL with SQL Anywhere 3 CHAPTER 29. Using Transact-SQL with SQL Anywhere=THINT@dbeng50w.hlp 3 An overview of SQL Anywhere support for Transact-SQL=TSOS@dbeng50w.hlp 4 SQL Server and SQL Anywhere architectures 4 SQL Server and SQL Anywhere architectures=THAD@dbeng50w.hlp 4 Servers and databases in SQL Server and SQL Anywhere=TSADCN@dbeng50w.hlp 4 System tables in SQL Anywhere and SQL Server=TSADST@dbeng50w.hlp 4 Administrative roles in SQL Server and SQL Anywhere=TSADAR@dbeng50w.hlp 4 Users and groups in SQL Anywhere and SQL Server=TSADUG@dbeng50w.hlp 3 General guidelines for writing portable SQL=THGP@dbeng50w.hlp 4 Configuring SQL Anywhere for Transact-SQL compatibility 4 Configuring SQL Anywhere for Transact-SQL compatibility=THDB@dbeng50w.hlp 4 Creating a Transact-SQL-compatible database=THDBIN@dbeng50w.hlp 4 Setting options for Transact-SQL compatibility=THDBOP@dbeng50w.hlp 4 Case-sensitivity in SQL Server and SQL Anywhere databases=THDBCS@dbeng50w.hlp 4 Ensuring compatible object names=THDBNS@dbeng50w.hlp 4 Using compatible data types 4 Using compatible data types=THCD@dbeng50w.hlp 4 Integer data types=THCDIN@dbeng50w.hlp 4 Decimal data types=THCDDE@dbeng50w.hlp 4 Compatibility of character data types=THCDCH@dbeng50w.hlp 4 Compatibility of binary data types=THCDBI@dbeng50w.hlp 4 Money data types=THCDMO@dbeng50w.hlp 4 Bit data type=THCDBT@dbeng50w.hlp 4 Compatibility of date and time data types=THCDDT@dbeng50w.hlp 4 The special Transact-SQL timestamp column and data type=THCDTS@dbeng50w.hlp 4 The special identity column=S5DDID@dbeng50w.hlp 4 Compatibility of user-defined data types=S5DDID_1@dbeng50w.hlp 4 Local and global variables 4 Local and global variables=THVA@dbeng50w.hlp 4 Local variable support=THVALV@dbeng50w.hlp 4 Global variable support=THVAGV@dbeng50w.hlp 4 Obtaining the values of variables=THVAOV@dbeng50w.hlp 4 Building compatible expressions 4 Building compatible expressions=THCE@dbeng50w.hlp 4 Compatibility of constants=THCECN@dbeng50w.hlp 4 Compatibility of operators=THCEOP@dbeng50w.hlp 4 Using compatible functions 4 Using compatible functions=THCF@dbeng50w.hlp 4 Compatibility of aggregate functions=THCFAF@dbeng50w.hlp 4 Compatibility of numeric functions=THCFNF@dbeng50w.hlp 4 Compatibility of string functions=THCFST@dbeng50w.hlp 4 Compatibility of date and time functions=THCFDF@dbeng50w.hlp 4 Compatibility of data type conversion functions=THCFCF@dbeng50w.hlp 4 Compatibility of miscellaneous functions=THCFMF@dbeng50w.hlp 4 Compatibility of text and image functions=THCFTF@dbeng50w.hlp 4 Compatibility of system functions=THCFSF@dbeng50w.hlp 4 Building compatible search conditions 4 Building compatible search conditions=THSC@dbeng50w.hlp 4 Compatibility of comparison conditions=THSCCM@dbeng50w.hlp 4 Compatibility of comparison operators=THSCCM_1@dbeng50w.hlp 4 Compatibility of BETWEEN and LIKE conditions=THSCBL@dbeng50w.hlp 4 Compatibility of IN conditions=THSCIN@dbeng50w.hlp 4 Compatibility of ALL and ANY conditions=THSCAA@dbeng50w.hlp 4 Compatibility of EXISTS conditions=THSCEX@dbeng50w.hlp 4 Compatibility of IS NULL conditions=THSCNLC@dbeng50w.hlp 4 Providing estimates for conditions=THSCES@dbeng50w.hlp 4 Conditions using logical operators=THSCCC@dbeng50w.hlp 4 Other language elements 4 Other language elements=THCO@dbeng50w.hlp 4 Compatible comment indicators=THCOCI@dbeng50w.hlp 4 Transact-SQL statement reference 4 Transact-SQL statement reference=TSYN@dbeng50w.hlp 4 Transact-SQL BEGIN TRANSACTION statement=TSYNBT@dbeng50w.hlp 4 Transact-SQL COMMIT statement=TSYNCT@dbeng50w.hlp 4 Transact-SQL CREATE DEFAULT and CREATE RULE statements=TSYNCDE@dbeng50w.hlp 4 Transact-SQL CREATE INDEX statement=TSYNCI@dbeng50w.hlp 4 Transact-SQL CREATE MESSAGE statement=TSYNCM@dbeng50w.hlp 4 Transact-SQL CREATE SCHEMA statement=TSYNCS@dbeng50w.hlp 4 Transact-SQL CREATE TABLE statement=TSYNCRT@dbeng50w.hlp 4 Transact-SQL DATABASE statements=TSYNCDB@dbeng50w.hlp 4 Transact-SQL DELETE statement=TSYNDL@dbeng50w.hlp 4 Transact-SQL DISK statements=TSYNDM@dbeng50w.hlp 4 Transact-SQL GRANT and REVOKE statements=TSYNGR@dbeng50w.hlp 4 Transact-SQL INSERT statement=TSYNIN@dbeng50w.hlp 4 Transact-SQL joins=TSYNJ@dbeng50w.hlp 4 Transact-SQL READTEXT statement=TSYNRT@dbeng50w.hlp 4 Transact-SQL ROLLBACK statement=TSYNRB@dbeng50w.hlp 4 Transact-SQL SELECT statement=THCQ@dbeng50w.hlp 4 Transact-SQL SET statement=TSYNSET@dbeng50w.hlp 4 Transact-SQL UPDATE statement=TSYNUP@dbeng50w.hlp 4 Transact-SQL WRITETEXT statement=TSYNWT@dbeng50w.hlp 3 Compatible system catalog information=THCA@dbeng50w.hlp 4 SQL Server system and catalog procedures 4 SQL Server system and catalog procedures=THSP@dbeng50w.hlp 4 SQL Server system procedures=THSPSP@dbeng50w.hlp 4 SQL Server catalog procedures=THSPCP@dbeng50w.hlp 4 Implicit data type conversion 4 Implicit data type conversion=THID@dbeng50w.hlp 4 Differences in string to datetime conversions=THIDSD@dbeng50w.hlp 3 CHAPTER 30. Transact-SQL Procedure Language 3 CHAPTER 30. Transact-SQL Procedure Language=TSPBT@dbeng50w.hlp 4 Transact-SQL procedure language overview 4 Transact-SQL procedure language overview=TSPO@dbeng50w.hlp 4 Mixing Transact-SQL and Watcom-SQL dialects=TSPOMD@dbeng50w.hlp 4 Automatic translation of SQL statements 4 Automatic translation of SQL statements=TSTR@dbeng50w.hlp 4 Using Sybase Central to translate stored procedures=TSTRSC@dbeng50w.hlp 3 Transact-SQL stored procedure overview=TSSO@dbeng50w.hlp 3 Transact-SQL trigger overview=TSOT@dbeng50w.hlp 3 Transact-SQL batch overview=TSBT@dbeng50w.hlp 4 Supported Transact-SQL procedure language statements 4 Supported Transact-SQL procedure language statements=TSCS@dbeng50w.hlp 4 Transact-SQL BEGIN ... END statement=TSCSBG@dbeng50w.hlp 5 Transact-SQL CREATE PROCEDURE statement 5 Transact-SQL CREATE PROCEDURE statement=TSSYN@dbeng50w.hlp 5 Comparison of Transact-SQL and Watcom-SQL CREATE PROCEDURE statements=TSSYN_1@dbeng50w.hlp 4 Transact-SQL CREATE TRIGGER statement=TSCTS@dbeng50w.hlp 4 Transact-SQL EXECUTE statement=TSEX@dbeng50w.hlp 4 Transact-SQL GOTO statement=TSCSGOTO@dbeng50w.hlp 4 Transact-SQL IF statement=TSCSIF@dbeng50w.hlp 4 Transact-SQL PRINT statement=TSPR@dbeng50w.hlp 4 Transact-SQL RAISERROR statement=TSRE@dbeng50w.hlp 4 The Transact-SQL RETURN statement=TSCSRT@dbeng50w.hlp 4 Transact-SQL WHILE statement=TSCSWH@dbeng50w.hlp 3 Returning result sets from Transact-SQL procedures=TSRS@dbeng50w.hlp 4 Variable and cursor declarations 4 Variable and cursor declarations=TSSC@dbeng50w.hlp 4 Transact-SQL DECLARE CURSOR statement=TSSCDC@dbeng50w.hlp 5 Transact-SQL DECLARE statement 5 Transact-SQL DECLARE statement=TSSCDV@dbeng50w.hlp 5 Assigning values to variables in Transact-SQL=TSSCAV@dbeng50w.hlp 4 Error handling in Transact-SQL procedures 4 Error handling in Transact-SQL procedures=TSEH@dbeng50w.hlp 4 Using the RAISERROR statement in procedures=TSEH_1@dbeng50w.hlp 4 Transact-SQL-like error handling in the Watcom-SQL dialect=TSEH_2@dbeng50w.hlp 3 CHAPTER 31. Using the Open Server Gateway 3 CHAPTER 31. Using the Open Server Gateway=OS@dbeng50w.hlp 3 Open Server Gateway overview=OSOV@dbeng50w.hlp 4 Open Server Gateway architecture 4 Open Server Gateway architecture=OSAR@dbeng50w.hlp 4 What you need to use the Open Server Gateway=OSWY@dbeng50w.hlp 4 Data type mappings 4 Data type mappings=OSDT@dbeng50w.hlp 5 Problem-free Open Client data types 5 Problem-free Open Client data types=OSPF@dbeng50w.hlp 5 Release 5.501 compatibility switch=OSPF_1@dbeng50w.hlp 5 Data type mappings between systems 5 Data type mappings between systems=OSDM@dbeng50w.hlp 5 Mapping data from Open Client to SQL Anywhere=OSDM_1@dbeng50w.hlp 5 Mapping data from SQL Anywhere to Open Client=OSSA@dbeng50w.hlp 4 Data types with value range limitations=OSPV@dbeng50w.hlp 4 Open Client data types with description limitations=OSDP@dbeng50w.hlp 4 Incompatible Open Client data types=OSDP_1@dbeng50w.hlp 4 Setting up the Open Server Gateway 4 Setting up the Open Server Gateway=OSCN@dbeng50w.hlp 4 Starting the Open Server Gateway=SRPSOS@dbeng50w.hlp 4 Open Server Gateway actions on connecting=OSG_CONNECT@dbeng50w.hlp 4 Events handled by Open Server Gateway 4 Events handled by Open Server Gateway=OSEV@dbeng50w.hlp 4 Standard event handling in Open Server Gateway=OSEVST@dbeng50w.hlp 4 Known limitations of the Open Server Gateway=OSEVST_1@dbeng50w.hlp 4 Using SQL Anywhere with OmniCONNECT 4 Using SQL Anywhere with OmniCONNECT=OS_OMNI@dbeng50w.hlp 4 Setting up SQL Anywhere as an OmniCONNECT remote server=OS_OMNI_1@dbeng50w.hlp 4 Limitations of using SQL Anywhere with OmniCONNECT=OS_OMNI_2@dbeng50w.hlp 2 PART 5. The SQL Anywhere Programming Interfaces 2 PART 5. The SQL Anywhere Programming Interfaces=OS_OMNI_3@dbeng50w.hlp 2 CHAPTER 32. Programming Interfaces=INTERF@dbeng50w.hlp 3 CHAPTER 33. The Embedded SQL Interface 3 CHAPTER 33. The Embedded SQL Interface=EMBEDSQL@dbeng50w.hlp 4 The C language SQL preprocessor 4 The C language SQL preprocessor=SQLPP@dbeng50w.hlp 4 Supported compilers=PPCOMP@dbeng50w.hlp 4 Development process for Windows 3.x and 95, OS/2, or Windows NT=PPDEVW@dbeng50w.hlp 4 Development process for DOS or QNX=PPDEVDQ@dbeng50w.hlp 4 Running the SQL preprocessor=PPRUN@dbeng50w.hlp 4 Embedded SQL header files=HEADER@dbeng50w.hlp 4 Embedded SQL libraries=LIBRS@dbeng50w.hlp 4 A simple example=PPSEG@dbeng50w.hlp 4 Structure of Embedded SQL programs=PPSTRU@dbeng50w.hlp 4 Authorization=ESQLAUT@dbeng50w.hlp 3 Embedded SQL interface data types=ESQLVAR@dbeng50w.hlp 4 Host variables 4 Host variables=HOSTVAR@dbeng50w.hlp 4 Host variable declarations=HOVDECL@dbeng50w.hlp 4 C host variable types=HOVCVT@dbeng50w.hlp 4 Host variable usage=HOVUSAG@dbeng50w.hlp 4 Indicator variables=INDVAR@dbeng50w.hlp 3 The SQL communication area (SQLCA)=SQLCA@dbeng50w.hlp 4 Fetching data 4 Fetching data=FETCHD@dbeng50w.hlp 4 Embedded SELECT=FETCHD_1@dbeng50w.hlp 4 Cursors in Embedded SQL=CURSORS@dbeng50w.hlp 4 Static vs dynamic SQL 4 Static vs dynamic SQL=DYNAMIC@dbeng50w.hlp 4 Static statements=STASTAT@dbeng50w.hlp 4 Dynamic statements=DYNSTAT@dbeng50w.hlp 4 Dynamic SELECT statement=DYNSEL@dbeng50w.hlp 4 Fetching more than one row at a time=WDFTCH@dbeng50w.hlp 4 The SQL descriptor area (SQLDA) 4 The SQL descriptor area (SQLDA)=SQLDA@dbeng50w.hlp 4 Length field values=LENFLD@dbeng50w.hlp 4 SQL procedures in Embedded SQL 4 SQL procedures in Embedded SQL=ESQLSP@dbeng50w.hlp 4 Simple procedures=ESQLSP_1@dbeng50w.hlp 4 Procedures with result sets=ESQLSP_2@dbeng50w.hlp 4 Multi-Threaded or Reentrant Code=MSQLCA@dbeng50w.hlp 4 Using multiple SQLCAs=MSQLCA_1@dbeng50w.hlp 4 Connection Management with Multiple SQLCAs=MSQLCA_2@dbeng50w.hlp 4 Library functions 4 Library functions=LIBFUNC@dbeng50w.hlp 5 Interface initialization functions 5 Interface initialization functions=LIBINT@dbeng50w.hlp 5 {\cs185 \additive\b\cf0 \sbasedon10 db_init function}=LIBINT_1@dbeng50w.hlp 5 db_fini function=LIBINT_2@dbeng50w.hlp 5 Connection and engine management functions 5 Connection and engine management functions=CONNMAN@dbeng50w.hlp 5 db_string_connect function=CONNMAN_1@dbeng50w.hlp 5 db_string_disconnect function=CONNMAN_2@dbeng50w.hlp 5 db_start_engine function=CONNMAN_3@dbeng50w.hlp 5 db_start_database function=CONNMAN_4@dbeng50w.hlp 5 db_stop_database function=CONNMAN_5@dbeng50w.hlp 5 db_stop_engine function=CONNMAN_6@dbeng50w.hlp 5 db_find_engine function=CONNMAN_7@dbeng50w.hlp 5 db_build_parms function=CONNMAN_8@dbeng50w.hlp 5 db_destroy_parms function=CONNMAN_9@dbeng50w.hlp 5 db_free_parms function=CONNMAN_10@dbeng50w.hlp 5 db_parms_connect function=CONNMAN_11@dbeng50w.hlp 5 db_parms_disconnect function=CONNMAN_12@dbeng50w.hlp 5 db_start function=CONNMAN_13@dbeng50w.hlp 5 db_stop function=CONNMAN_14@dbeng50w.hlp 5 SQLDA management functions 5 SQLDA management functions=SQLDAF@dbeng50w.hlp 5 alloc_sqlda_noind function=SQLDAF_1@dbeng50w.hlp 5 alloc_sqlda function=SQLDAF_2@dbeng50w.hlp 5 fill_sqlda function=SQLDAF_3@dbeng50w.hlp 5 sqlda_string_length function=SQLDAF_4@dbeng50w.hlp 5 sqlda_storage function=SQLDAF_5@dbeng50w.hlp 5 fill_s_sqlda function=SQLDAF_6@dbeng50w.hlp 5 free_filled_sqlda function=SQLDAF_7@dbeng50w.hlp 5 free_sqlda_noind function=SQLDAF_8@dbeng50w.hlp 5 free_sqlda function=SQLDAF_9@dbeng50w.hlp 5 Backup functions 5 Backup functions=LIBBACK@dbeng50w.hlp 5 db_backup function=LIBBACK_1@dbeng50w.hlp 5 db_delete_file function=LIBBACK_2@dbeng50w.hlp 5 Other functions 5 Other functions=LIBMISC@dbeng50w.hlp 5 sql_needs_quotes function=LIBMISC_1@dbeng50w.hlp 5 sqlerror_message function=LIBMISC_2@dbeng50w.hlp 5 Aborting a request 5 Aborting a request=DBABORT@dbeng50w.hlp 5 db_abort_request function=DBABORT_1@dbeng50w.hlp 5 db_cancel_request function=DBABORT_2@dbeng50w.hlp 5 db_is_working function=DBABORT_3@dbeng50w.hlp 5 db_working function=DBABORT_4@dbeng50w.hlp 5 Windows 3.x request management 5 Windows 3.x request management=WINREQS@dbeng50w.hlp 5 db_register_a_callback function=WINREQS_1@dbeng50w.hlp 5 db_process_a_message function=WINREQS_2@dbeng50w.hlp 5 Multiple SQLCA management 5 Multiple SQLCA management=MSQLCAS@dbeng50w.hlp 5 db_set_sqlca function=MSQLCAS_1@dbeng50w.hlp 5 db_get_sqlca function=MSQLCAS_2@dbeng50w.hlp 5 Memory allocation in DOS and QNX 5 Memory allocation in DOS and QNX=MEMALDQ@dbeng50w.hlp 5 DBAlloc function=MEMALDQ_1@dbeng50w.hlp 5 DBRealloc function=MEMALDQ_2@dbeng50w.hlp 5 DBFree function=MEMALDQ_3@dbeng50w.hlp 5 DOS interrupt processing and request management 5 DOS interrupt processing and request management=INTS@dbeng50w.hlp 5 db_sending_request function=INTS_1@dbeng50w.hlp 5 db_finished_request function=INTS_2@dbeng50w.hlp 5 db_catch_break function=INTS_3@dbeng50w.hlp 5 db_release_break function=INTS_4@dbeng50w.hlp 5 db_break_handler function=INTS_5@dbeng50w.hlp 5 db_catch_critical function=INTS_6@dbeng50w.hlp 5 db_release_critical function=INTS_7@dbeng50w.hlp 5 function=INTS_8@dbeng50w.hlp 3 Interface library DLL dynamic loading=DYNAMIC_LOADING@dbeng50w.hlp 3 Embedded SQL commands=ESQLCOM@dbeng50w.hlp 4 Database examples 4 Database examples=DBEXMP@dbeng50w.hlp 4 Building the examples=EGBLD@dbeng50w.hlp 4 Running the example programs=EGRUN@dbeng50w.hlp 4 Static cursor example=CURSEX@dbeng50w.hlp 4 Dynamic cursor example=DCURSEX@dbeng50w.hlp 4 NT Service examples=EGNTS@dbeng50w.hlp 3 SQLDEF.H header file=SQLDEF@dbeng50w.hlp 3 CHAPTER 34. ODBC Programming 3 CHAPTER 34. ODBC Programming=ODBCDEV@dbeng50w.hlp 4 ODBC C language programming 4 ODBC C language programming=ODBCPGM@dbeng50w.hlp 4 Fundamentals=ODFUND@dbeng50w.hlp 4 Compiling and linking an ODBC application=ODBCCL@dbeng50w.hlp 4 A first example=ODBCEG@dbeng50w.hlp 4 Error checking=ODBCER@dbeng50w.hlp 4 Cursors in ODBC=ODBCCUR@dbeng50w.hlp 4 Procedures and triggers in ODBC=ODBCPT@dbeng50w.hlp 4 ODBC conformance=ODCONF@dbeng50w.hlp 4 The sample program=ODSAMP@dbeng50w.hlp 3 ODBC programming for the Macintosh=ODBCMAC@dbeng50w.hlp 3 CHAPTER 35. The WSQL DDE Server 3 CHAPTER 35. The WSQL DDE Server=WSQLDDE@dbeng50w.hlp 4 DDE concepts 4 DDE concepts=DDE_CONCEPTS@dbeng50w.hlp 4 What is DDE?=DDE_CONCEPTS_1@dbeng50w.hlp 4 DDE conversations=DDE_CONCEPTS_2@dbeng50w.hlp 4 Sending and receiving data and commands using DDE=DDE_CONCEPTS_3@dbeng50w.hlp 4 DDE links=DDE_CONCEPTS_4@dbeng50w.hlp 4 Using WSQL DDE Server 4 Using WSQL DDE Server=USING_WSQL_DDE_SERVER@dbeng50w.hlp 4 The WSQL DDE Server window=USING_WSQL_DDE_SERVER_1@dbeng50w.hlp 4 Initiating a DDE conversation with WSQL DDE Server=USING_WSQL_DDE_SERVER_2@dbeng50w.hlp 4 Communicating with the WSQL DDE Server=USING_WSQL_DDE_SERVER_3@dbeng50w.hlp 3 Excel and WSQL DDE Server=EXCEL_AND_WSQL_DDE_SERVER@dbeng50w.hlp 3 Word and WSQL DDE Server=WORD_AND_WSQL_DDE_SERVER@dbeng50w.hlp 4 Visual Basic and WSQL DDE Server 4 Visual Basic and WSQL DDE Server=VISUAL_BASIC_AND_WSQL_DDE_SERVER@dbeng50w.hlp 4 The test application=VISUAL_BASIC_AND_WSQL_DDE_SERVER_1@dbeng50w.hlp 4 Running the test application=VISUAL_BASIC_AND_WSQL_DDE_SERVER_2@dbeng50w.hlp 3 CHAPTER 36. The WSQL HLI Interface 3 CHAPTER 36. The WSQL HLI Interface=WSQLACC@dbeng50w.hlp 3 DLL concepts=DLL_CONCEPTS@dbeng50w.hlp 3 Using WSQL HLI=USING_HLI@dbeng50w.hlp 3 Host variables with WSQL HLI=HOST_VARIABLES_WITH_HLI@dbeng50w.hlp 4 WSQL HLI functions 4 WSQL HLI functions=HLI_FUNCTIONS@dbeng50w.hlp 4 wsqlexec=HLI_FUNCTIONS_1@dbeng50w.hlp 4 wsqlgetfield=HLI_FUNCTIONS_2@dbeng50w.hlp 4 wsqlgetcolumnname=HLI_FUNCTIONS_3@dbeng50w.hlp 4 wsqlquerytomemdelim=HLI_FUNCTIONS_4@dbeng50w.hlp 4 wsqlquerytomem=HLI_FUNCTIONS_5@dbeng50w.hlp 4 wsqllasterror=HLI_FUNCTIONS_6@dbeng50w.hlp 4 wsqlregisterfuncs=REGFUNC@dbeng50w.hlp 3 wsqlexec command strings=DLLCMD@dbeng50w.hlp 3 CLIP HLI Statement=DLLCMD_1@dbeng50w.hlp 3 CLOSE HLI Statement=DLLCMD_2@dbeng50w.hlp 3 COMMIT HLI Statement=DLLCMD_3@dbeng50w.hlp 3 DECLARE HLI Statement=DLLCMD_4@dbeng50w.hlp 3 DROP HLI Statement=DLLCMD_5@dbeng50w.hlp 3 EXECUTE HLI Statement=DLLCMD_6@dbeng50w.hlp 3 FETCH HLI Statement=DLLCMD_7@dbeng50w.hlp 3 OPEN HLI Statement=DLLCMD_8@dbeng50w.hlp 3 PREPARE HLI Statement=DLLCMD_9@dbeng50w.hlp 3 ROLLBACK HLI Statement=DLLCMD_10@dbeng50w.hlp 3 SET CONNECTION HLI Statement=DLLCMD_11@dbeng50w.hlp 3 START USING DATABASE HLI Statement=DLLCMD_12@dbeng50w.hlp 3 STOP USING DATABASE HLI Statement=DLLCMD_13@dbeng50w.hlp 4 WSQL HLI and Visual Basic 4 WSQL HLI and Visual Basic=HLI_AND_VB@dbeng50w.hlp 4 Visual Basic example=HLI_AND_VB_1@dbeng50w.hlp 4 The sample application=HLI_AND_VB_2@dbeng50w.hlp 4 Running the sample application=HLI_AND_VB_3@dbeng50w.hlp 4 WSQL HLI and REXX 4 WSQL HLI and REXX=REXX@dbeng50w.hlp 4 Error codes and messages=REXX_1@dbeng50w.hlp 4 REXX examples=REXX_2@dbeng50w.hlp 2 PART 6. SQL Anywhere Reference 2 PART 6. SQL Anywhere Reference=REXX_3@dbeng50w.hlp 3 CHAPTER 37. SQL Anywhere Components 3 CHAPTER 37. SQL Anywhere Components=COMMSUM@dbeng50w.hlp 3 SQL Anywhere components overview=SQL_ANYWHERE_COMPONENTS_OVERVIEW@dbeng50w.hlp 4 Registry entries and environment variables 4 Registry entries and environment variables=ENVVAR@dbeng50w.hlp 4 SQLANY environment variable=ENVVAR_1@dbeng50w.hlp 4 SQLCONNECT environment variable=ENVVAR_2@dbeng50w.hlp 4 SQLPATH environment variable=ENVVAR_3@dbeng50w.hlp 4 SQLREMOTE environment variable=ENVVAR_4@dbeng50w.hlp 4 SQLSTART environment variable=ENVVAR_5@dbeng50w.hlp 4 TMP environment variable=ENVVAR_6@dbeng50w.hlp 3 Software component return codes=RETCODE@dbeng50w.hlp 3 The database engine=DBENGINES@dbeng50w.hlp 4 The Backup utility 4 The Backup utility=DBBK@dbeng50w.hlp 4 Backing up a database from Sybase Central=BKSC@dbeng50w.hlp 4 Backing up a database from the ISQL Database Tools window=BKIS@dbeng50w.hlp 4 Backing up a database using the DBTOOL statement=BKTL@dbeng50w.hlp 4 The DBBACKUP command-line utility=DBBACKUP@dbeng50w.hlp 4 Backup utility options=BKOP@dbeng50w.hlp 4 The Collation utility 4 The Collation utility=DBCL@dbeng50w.hlp 4 Extracting a collation in the ISQL Database Tools window=DBCLIS@dbeng50w.hlp 4 Extracting a collation using the DBTOOL statement=DBCLTL@dbeng50w.hlp 4 The DBCOLLAT command-line utility=DBCOLLAT@dbeng50w.hlp 4 Collation utility options=DBCLOP@dbeng50w.hlp 4 The Compression utility 4 The Compression utility=DBSH@dbeng50w.hlp 4 Compressing a database in Sybase Central=DBSHSC@dbeng50w.hlp 4 Compressing a database from the ISQL Database Tools window=DBSHIS@dbeng50w.hlp 4 Compressing a database using the DBTOOL statement=DBSHTL@dbeng50w.hlp 4 The DBSHRINK command-line utility=DBSHRINK@dbeng50w.hlp 4 Compression utility options=DBSHOP@dbeng50w.hlp 4 The Erase utility 4 The Erase utility=DBER@dbeng50w.hlp 4 Erasing a database from Sybase Central=DBERSC@dbeng50w.hlp 4 Erasing a database from the ISQL Database Tools window=DBERIS@dbeng50w.hlp 4 Erasing a database using the DBTOOL statement=DBERTL@dbeng50w.hlp 4 The DBERASE command-line utility=DBERASE@dbeng50w.hlp 4 Erase utility options=DBEROP@dbeng50w.hlp 4 The Information utility 4 The Information utility=DBIN@dbeng50w.hlp 4 Obtaining database information in the ISQL Database Tools window=DBINIS@dbeng50w.hlp 4 Obtaining database information using the DBTOOL statement=DBINTL@dbeng50w.hlp 4 The DBINFO command-line utility=DBINFO@dbeng50w.hlp 4 Information utility options=DBINOP@dbeng50w.hlp 4 The Initialization utility 4 The Initialization utility=DBINI@dbeng50w.hlp 4 Creating a database in Sybase Central=DBINIC@dbeng50w.hlp 4 Creating a database from the ISQL Database Tools window=DBINIIS@dbeng50w.hlp 4 Creating a database using the DBTOOL statement from within ISQL=DBINITL@dbeng50w.hlp 4 The DBINIT command-line utility=DBINIT@dbeng50w.hlp 4 Initialization utility options=DBINIOP@dbeng50w.hlp 4 The ISQL utility 4 The ISQL utility=ISQLUT@dbeng50w.hlp 4 Commands available in ISQL=ISQLUT_1@dbeng50w.hlp 4 Starting ISQL from Sybase Central=ISQLUT_2@dbeng50w.hlp 4 The Log Translation utility 4 The Log Translation utility=DBTR@dbeng50w.hlp 4 Translating a transaction log in Sybase Central=DBTRSC@dbeng50w.hlp 4 Translating a transaction log from the ISQL Database Tools window=DBTRIS@dbeng50w.hlp 4 Translating a transaction log using the DBTOOL statement=DBTRTL@dbeng50w.hlp 4 The DBTRAN command-line utility=DBTRAN@dbeng50w.hlp 4 Log translation utility options=DBTROP@dbeng50w.hlp 3 The Open Server Gateway=DBOSV@dbeng50w.hlp 3 The Open Server Information utility=DBOSINF@dbeng50w.hlp 3 The Open Server Stop utility=DBOSSTP@dbeng50w.hlp 3 The REBUILD batch or command file=REBUILD@dbeng50w.hlp 4 The SQL Remote Database Extraction utility 4 The SQL Remote Database Extraction utility=DBXT@dbeng50w.hlp 4 Extracting a remote database in Sybase Central=DBXTSC@dbeng50w.hlp 4 The DBXTRACT command-line utility=DBXTRACT@dbeng50w.hlp 4 Extraction utility options=DBXTOP@dbeng50w.hlp 3 The SQL Remote Message Agent=DBREM@dbeng50w.hlp 4 The Stop utility 4 The Stop utility=DBST@dbeng50w.hlp 4 The DBSTOP command-line utility=DBSTOP@dbeng50w.hlp 4 Stop utility options=DBSTOPOP@dbeng50w.hlp 4 The Transaction Log utility 4 The Transaction Log utility=DBLG@dbeng50w.hlp 4 Changing a log file name from Sybase Central=DBLGSC@dbeng50w.hlp 4 Changing a log file name from the ISQL Database Tools window=DBLGIS@dbeng50w.hlp 4 Changing a log filename from the DBTOOL statement=DBLGTL@dbeng50w.hlp 4 The DBLOG command-line utility=DBLOG@dbeng50w.hlp 4 Transaction log utility options=DBLGOP@dbeng50w.hlp 4 The Uncompression utility 4 The Uncompression utility=DBEX@dbeng50w.hlp 4 Uncompressing a database in Sybase Central=DBEXSC@dbeng50w.hlp 4 Uncompressing a database from the ISQL Database Tools window=DBEXIS@dbeng50w.hlp 4 Uncompressing a database using the DBTOOL statement=DBEXTL@dbeng50w.hlp 4 The DBEXPAND command-line utility=DBEXPAND@dbeng50w.hlp 4 Uncompression utility options=DBEXOP@dbeng50w.hlp 4 The Unload utility 4 The Unload utility=DBUN@dbeng50w.hlp 4 Unloading a database from Sybase Central=DBUNSC@dbeng50w.hlp 4 Unloading a database from the ISQL Database Tools window=DBUNIS@dbeng50w.hlp 4 Unloading a database from the DBTOOL statement=DBUNTL@dbeng50w.hlp 4 The DBUNLOAD command-line utility=DBUNLOAD@dbeng50w.hlp 4 Unload utility options=DBUNOP@dbeng50w.hlp 4 The Upgrade utility 4 The Upgrade utility=DBUPA@dbeng50w.hlp 4 Upgrading a database from Sybase Central=DBUPSC@dbeng50w.hlp 4 Upgrading databases too old for the Upgrade utility=DBUPTO@dbeng50w.hlp 4 The DBUPGRAD command-line utility=DBUPGRAD@dbeng50w.hlp 4 Upgrade utility options=DBUPOP@dbeng50w.hlp 4 The Validation utility 4 The Validation utility=DBVA@dbeng50w.hlp 4 Validating a database from Sybase Central=DBVASC@dbeng50w.hlp 4 Validating a database from the ISQL Database Tools window=DBVAIS@dbeng50w.hlp 4 Using the Validation utility from the DBTOOL statement=DBVATL@dbeng50w.hlp 4 Using the DBVALID command line utility=DBVALID@dbeng50w.hlp 4 Validation utility options=DBVAOP@dbeng50w.hlp 4 The Write File utility 4 The Write File utility=DBWR@dbeng50w.hlp 4 Creating a write file from Sybase Central=DBWRSC@dbeng50w.hlp 4 Creating a write file from the ISQL Database Tools window=DBWRIS@dbeng50w.hlp 4 Creating a write file using the DBTOOL statement=DBWRTL@dbeng50w.hlp 4 The DBWRITE command-line utility=DBWRITE@dbeng50w.hlp 4 Write file utility options=DBWROP@dbeng50w.hlp 3 The SQL Preprocessor=SQLPP1@dbeng50w.hlp 3 CHAPTER 38. Watcom-SQL Language Reference 3 CHAPTER 38. Watcom-SQL Language Reference=SYNTAX@dbeng50w.hlp 3 Syntax conventions=SYNCONV@dbeng50w.hlp 3 Watcom-SQL language elements=PIECES@dbeng50w.hlp 4 Expressions 4 Expressions=EXPR@dbeng50w.hlp 4 Constants in expressions=EXCO@dbeng50w.hlp 4 Column names in expressions=EXCN@dbeng50w.hlp 4 Watcom-SQL variables=EXVN@dbeng50w.hlp 4 Functions in expressions=EXFU@dbeng50w.hlp 4 Subqueries in expressions=EXSQ@dbeng50w.hlp 4 Watcom-SQL Operators=EXOP@dbeng50w.hlp 4 Search conditions 4 Search conditions=SEARCH@dbeng50w.hlp 4 Subqueries in search conditions=COSQ@dbeng50w.hlp 4 Comparison conditions=COCO@dbeng50w.hlp 4 BETWEEN conditions=COBC@dbeng50w.hlp 4 LIKE conditions=COLC@dbeng50w.hlp 4 IN conditions=COIN@dbeng50w.hlp 4 ALL or ANY conditions=COAA@dbeng50w.hlp 4 EXISTS conditions=COEX@dbeng50w.hlp 4 IS NULL conditions=CONU@dbeng50w.hlp 4 Conditions with logical operators=COLO@dbeng50w.hlp 4 NOT conditions=CONT@dbeng50w.hlp 4 Truth value conditions=COTV@dbeng50w.hlp 4 Three-valued logic=COTVL@dbeng50w.hlp 3 Comments in Watcom-SQL=SYCO@dbeng50w.hlp 3 CHAPTER 39. SQL Anywhere Data Types 3 CHAPTER 39. SQL Anywhere Data Types=DATATYP@dbeng50w.hlp 3 Character data types=DTCH@dbeng50w.hlp 3 Numeric data types=DTNU@dbeng50w.hlp 4 Date and time data types 4 Date and time data types=DTDT@dbeng50w.hlp 4 Sending dates and times to the database=DTSD@dbeng50w.hlp 4 Unambiguous dates and times=DTFT@dbeng50w.hlp 4 Retrieving dates and times from the database=DTFT_1@dbeng50w.hlp 4 Date and time comparisons=DTFT_2@dbeng50w.hlp 3 Binary data types=DTBI@dbeng50w.hlp 3 User-defined data types=DTUD@dbeng50w.hlp 3 Data type conversions=DTCO@dbeng50w.hlp 4 Year 2000 compliance 4 Year 2000 compliance=DTY2K@dbeng50w.hlp 4 How dates are stored=DTY2K_1@dbeng50w.hlp 4 Sending and retrieving date values=DTY2K_2@dbeng50w.hlp 4 Leap years=DTY2K_3@dbeng50w.hlp 4 Ambiguous string to date conversions=DTAS@dbeng50w.hlp 4 Date to string conversions=DTDS@dbeng50w.hlp 3 CHAPTER 40. Watcom-SQL Functions 3 CHAPTER 40. Watcom-SQL Functions=FUNC@dbeng50w.hlp 3 Aggregate functions=AGGRF@dbeng50w.hlp 3 Numeric functions=FUNU@dbeng50w.hlp 3 String functions=FUST@dbeng50w.hlp 3 Date and time functions=FUDT@dbeng50w.hlp 3 Data type conversion functions=FUCO@dbeng50w.hlp 4 System functions 4 System functions=FUSF@dbeng50w.hlp 4 Connection properties=FUSF_1@dbeng50w.hlp 4 Properties available for the engine=FUSF_2@dbeng50w.hlp 4 Properties available for each database=FUSF_3@dbeng50w.hlp 3 Miscellaneous functions=FUMI@dbeng50w.hlp 3 CHAPTER 41. Watcom-SQL Statements 3 CHAPTER 41. Watcom-SQL Statements=SYSS@dbeng50w.hlp 3 ALLOCATE DESCRIPTOR statement=ALLOCATE_DESCRIPTOR@dbeng50w.hlp 3 ALTER DBSPACE statement=ADBSP@dbeng50w.hlp 3 ALTER PROCEDURE statement=ALTPR@dbeng50w.hlp 3 ALTER PUBLICATION statement=ALPUB@dbeng50w.hlp 3 ALTER REMOTE MESSAGE TYPE statement=ALMSG@dbeng50w.hlp 3 ALTER TABLE statement=ALTER@dbeng50w.hlp 3 ALTER TRIGGER statement=ALTER_TRIGGER_STATEMENT@dbeng50w.hlp 3 ALTER VIEW statement=ALTER_VIEW_STATEMENT@dbeng50w.hlp 3 CALL statement=CALL@dbeng50w.hlp 3 CASE statement=CASE@dbeng50w.hlp 3 CHECKPOINT statement=CHKPNT@dbeng50w.hlp 3 CLOSE statement=CLOSE@dbeng50w.hlp 3 COMMENT statement=COMMENT@dbeng50w.hlp 3 COMMIT statement=COMMIT@dbeng50w.hlp 3 Compound statements=COMPND@dbeng50w.hlp 3 CONFIGURE statement=OPTIONS@dbeng50w.hlp 3 CONNECT statement=CONN@dbeng50w.hlp 3 CREATE DATATYPE statement=CREATDT@dbeng50w.hlp 3 CREATE DBSPACE statement=CREATED@dbeng50w.hlp 3 CREATE FUNCTION statement=CREATEF@dbeng50w.hlp 3 CREATE INDEX statement=CREATEI@dbeng50w.hlp 3 CREATE PROCEDURE statement=CREATEP@dbeng50w.hlp 3 CREATE PUBLICATION statement=CRPUB@dbeng50w.hlp 3 CREATE REMOTE MESSAGE TYPE statement=CRMSG@dbeng50w.hlp 3 CREATE SCHEMA statement=CREATESC@dbeng50w.hlp 3 CREATE SUBSCRIPTION statement=CRSUB@dbeng50w.hlp 4 CREATE TABLE statement 4 CREATE TABLE statement=CREATET@dbeng50w.hlp 4 Integrity constraints=CREATET_1@dbeng50w.hlp 3 CREATE TRIGGER statement=CREATRG@dbeng50w.hlp 3 CREATE VARIABLE statement=MAKEVAR@dbeng50w.hlp 3 CREATE VIEW statement=CREATEV@dbeng50w.hlp 3 DBTOOL statement=DBTOOL@dbeng50w.hlp 3 Declaration section=DECLSEC@dbeng50w.hlp 3 DECLARE CURSOR statement=DECLARE@dbeng50w.hlp 3 DECLARE TEMPORARY TABLE statement=DECLTT@dbeng50w.hlp 3 DEALLOCATE DESCRIPTOR statement=DEALLOCATE_DESCRIPTOR@dbeng50w.hlp 3 DELETE statement=DELETE@dbeng50w.hlp 3 DELETE (positioned) statement=DELETEP@dbeng50w.hlp 3 DESCRIBE statement=DESCRIB@dbeng50w.hlp 3 DISCONNECT statement=DISCONN@dbeng50w.hlp 3 DROP statement=DROP@dbeng50w.hlp 3 DROP CONNECTION statement=DROPC@dbeng50w.hlp 3 DROP OPTIMIZER STATISTICS statement=DROPSTAT@dbeng50w.hlp 3 DROP PUBLICATION statement=DRPUB@dbeng50w.hlp 3 DROP REMOTE MESSAGE TYPE statement=DRMSG@dbeng50w.hlp 3 DROP STATEMENT statement=DROPSTMT@dbeng50w.hlp 3 DROP VARIABLE statement=DROPVAR@dbeng50w.hlp 3 DROP SUBSCRIPTION statement=DRSUB@dbeng50w.hlp 3 EXECUTE statement=EXECUTE@dbeng50w.hlp 3 EXECUTE IMMEDIATE statement=EXECI@dbeng50w.hlp 3 EXIT statement=EXIT@dbeng50w.hlp 3 EXPLAIN statement=EXPLAIN@dbeng50w.hlp 3 FETCH statement=FETCH@dbeng50w.hlp 3 FOR statement=FOR_STATEMENT@dbeng50w.hlp 4 FROM clause 4 FROM clause=TABLIST@dbeng50w.hlp 4 Joining tables=TABLIST_1@dbeng50w.hlp 4 Cross joins=TABLIST_2@dbeng50w.hlp 4 Generated join conditions=TABLIST_3@dbeng50w.hlp 4 Natural joins=TABLIST_4@dbeng50w.hlp 4 Key joins=TABLIST_5@dbeng50w.hlp 4 INNER JOIN and OUTER JOIN=TABLIST_6@dbeng50w.hlp 4 Join conditions=TABLIST_7@dbeng50w.hlp 4 Join abbreviations=TABLIST_8@dbeng50w.hlp 3 GET DATA statement=GETDATA@dbeng50w.hlp 3 GET DESCRIPTOR statement=GET_DESCRIPTOR@dbeng50w.hlp 3 GET OPTION statement=GET@dbeng50w.hlp 3 GRANT statement=GRANT@dbeng50w.hlp 3 GRANT CONSOLIDATE statement=GRCON@dbeng50w.hlp 3 GRANT PUBLISH statement=GRPUB@dbeng50w.hlp 3 GRANT REMOTE statement=GRREM@dbeng50w.hlp 3 HELP statement=HELPCOM@dbeng50w.hlp 3 IF statement=IFSTMT@dbeng50w.hlp 3 INCLUDE statement=INCLUDE@dbeng50w.hlp 3 INPUT statement=INPUT@dbeng50w.hlp 3 INSERT statement=INSERT@dbeng50w.hlp 3 LEAVE statement=LEAVE@dbeng50w.hlp 3 LOAD TABLE statement=LOADT@dbeng50w.hlp 3 LOOP statement=LOOPS@dbeng50w.hlp 3 MESSAGE statement=MESSAGE@dbeng50w.hlp 3 NULL value=NULLS@dbeng50w.hlp 3 OPEN statement=OPEN@dbeng50w.hlp 3 OUTPUT statement=OUTPUT@dbeng50w.hlp 3 PARAMETERS statement=PARMS@dbeng50w.hlp 3 PASSTHROUGH statement=PASSTHR@dbeng50w.hlp 3 PREPARE statement=PREPARE@dbeng50w.hlp 3 PREPARE TO COMMIT statement=PREPCOM@dbeng50w.hlp 3 PUT statement=PUT@dbeng50w.hlp 3 READ statement=READ@dbeng50w.hlp 3 RELEASE SAVEPOINT statement=RELEASESAVEPOINT@dbeng50w.hlp 3 RESIGNAL statement=RESIG@dbeng50w.hlp 3 RESUME statement=RESUME@dbeng50w.hlp 3 RETURN statement=RETURN@dbeng50w.hlp 3 REVOKE statement=REVOKE@dbeng50w.hlp 3 REVOKE CONSOLIDATE statement=RECON@dbeng50w.hlp 3 REVOKE PUBLISH statement=REPUB@dbeng50w.hlp 3 REVOKE REMOTE statement=REREM@dbeng50w.hlp 3 ROLLBACK statement=ROLLBACK@dbeng50w.hlp 3 ROLLBACK TO SAVEPOINT statement=ROLLBACKTOSAVEPOINT@dbeng50w.hlp 3 ROLLBACK TRIGGER statement=ROLLBACKTRIGGER@dbeng50w.hlp 3 SAVEPOINT statement=SAVEPOINT@dbeng50w.hlp 3 SELECT statement=SELECT@dbeng50w.hlp 3 SET statement=SETVAR@dbeng50w.hlp 3 SET CONNECTION statement=SETCONN@dbeng50w.hlp 3 SET DESCRIPTOR statement=SET_DESCRIPTOR@dbeng50w.hlp 4 SET OPTION statement 4 SET OPTION statement=SET@dbeng50w.hlp 4 Database options=SETDBOP@dbeng50w.hlp 4 Compatibility options=COMPATIBILITY_OPTIONS@dbeng50w.hlp 4 Replication options=SETRPOP@dbeng50w.hlp 4 ISQL options=SETISOP@dbeng50w.hlp 3 SET SQLCA statement=SETSQLCA@dbeng50w.hlp 3 SIGNAL statement=SIGNAL@dbeng50w.hlp 3 START DATABASE statement=STARTDB@dbeng50w.hlp 3 START ENGINE statement=STARTENG@dbeng50w.hlp 3 START SUBSCRIPTION statement=STARTSUB@dbeng50w.hlp 3 STOP DATABASE statement=STOPDB@dbeng50w.hlp 3 STOP ENGINE statement=STOPENG@dbeng50w.hlp 3 STOP SUBSCRIPTION statement=STOPSUB@dbeng50w.hlp 3 SYNCHRONIZE SUBSCRIPTION statement=SYNCSUB@dbeng50w.hlp 3 SYSTEM statement=SYSTEM@dbeng50w.hlp 3 TRUNCATE TABLE statement=TRUNCATET@dbeng50w.hlp 3 UNION operation=UNION@dbeng50w.hlp 3 UNLOAD TABLE statement=UNLOADT@dbeng50w.hlp 3 UPDATE statement=UPDATE@dbeng50w.hlp 3 UPDATE (positioned) statement=UPDATEP@dbeng50w.hlp 3 VALIDATE TABLE statement=VALIDT@dbeng50w.hlp 3 WHENEVER statement=WHENEVER@dbeng50w.hlp 3 CHAPTER 42. SQL Anywhere Database Error Messages 3 CHAPTER 42. SQL Anywhere Database Error Messages=ERRORS@dbeng50w.hlp 3 Error message index by SQLCODE=ERRCODE@dbeng50w.hlp 3 Error messages index by SQLSTATE=ERRSTAT@dbeng50w.hlp 4 Alphabetic list of error messages 4 Alphabetic list of error messages=ERRDESC@dbeng50w.hlp 4 (no message)=ERRORLISTING@dbeng50w.hlp 4 A parameter to an external function is an unsupported datatype=ERRM624@dbeng50w.hlp 4 A thread used internally could not be started=ERRM626@dbeng50w.hlp 4 Aggregate functions not allowed on this statement=ERRM150@dbeng50w.hlp 4 All threads are blocked=ERRM307@dbeng50w.hlp 4 ALTER clause conflict=ERRM125@dbeng50w.hlp 4 An argument passed to a SQL Anywhere HLI function was invalid=ERRM407@dbeng50w.hlp 4 Attempted two active database requests=ERRM298@dbeng50w.hlp 4 Authentication violation=ERRM98@dbeng50w.hlp 4 Calling functions outside the database engine is not supported=ERRM617@dbeng50w.hlp 4 Can only describe a SELECT statement=ERRM160@dbeng50w.hlp 4 Cannot alter a column in an index=ERRM127@dbeng50w.hlp 4 Cannot be started -- %1=ERRM105@dbeng50w.hlp 4 Cannot convert %1 to a %2=ERRM157@dbeng50w.hlp 4 Cannot delete a column referenced in a trigger definition=ERRM269@dbeng50w.hlp 4 Cannot drop a user that owns messages or datatypes=ERRM614@dbeng50w.hlp 4 Cannot drop a user that owns procedures in runtime engine=ERRM270@dbeng50w.hlp 4 Cannot drop a user that owns tables in runtime engine=ERRM128@dbeng50w.hlp 4 Cannot find index named '%1'=ERRM183@dbeng50w.hlp 4 Cannot modify column '%1' in table '%2'=ERRM191@dbeng50w.hlp 4 Cannot open log file %1=ERRM106@dbeng50w.hlp 4 Cannot outer join a view with a UNION or GROUP BY=ERRM162@dbeng50w.hlp 4 Cannot set a temporary option for user '%1'=ERRM203@dbeng50w.hlp 4 Cannot uniquely identify rows in cursor=ERRM295@dbeng50w.hlp 4 Cannot update an expression=ERRM190@dbeng50w.hlp 4 CHECKPOINT command requires a rollback log=ERRM212@dbeng50w.hlp 4 Client/server communications protocol mismatch=ERRM88@dbeng50w.hlp 4 Column %1 in foreign key has a different definition than primary key=ERRM113@dbeng50w.hlp 4 Column '%1' found in more than one table -- need a correlation name=ERRM144@dbeng50w.hlp 4 Column '%1' in table '%2' cannot be NULL=ERRM195@dbeng50w.hlp 4 Column '%1' not found=ERRM143@dbeng50w.hlp 4 COMMIT/ROLLBACK not allowed within atomic operation=ERRM267@dbeng50w.hlp 4 COMMIT/ROLLBACK not allowed within trigger actions=ERRM273@dbeng50w.hlp 4 Communication buffer underflow=ERRM73@dbeng50w.hlp 4 Communication error=ERRM85@dbeng50w.hlp 4 Connection not found=ERRM108@dbeng50w.hlp 4 Connection was terminated=ERRM308@dbeng50w.hlp 4 Connections to database have been disabled=ERRM99@dbeng50w.hlp 4 Correlation name '%1' not found=ERRM142@dbeng50w.hlp 4 Could not allocate resources to call external function=ERRM622@dbeng50w.hlp 4 Could not find the named function in the dynamic library=ERRM621@dbeng50w.hlp 4 Could not load the dynamic library=ERRM620@dbeng50w.hlp 4 Cursor already open=ERRM172@dbeng50w.hlp 4 Cursor has not been declared=ERRM170@dbeng50w.hlp 4 Cursor not open=ERRM180@dbeng50w.hlp 4 Cursor operation conflict=ERR108@dbeng50w.hlp 4 Data definition statements not allowed in procedures or triggers=ERRM623@dbeng50w.hlp 4 Database backup not started=ERRM241@dbeng50w.hlp 4 Database engine already running=ERRM96@dbeng50w.hlp 4 Database engine not running=ERRM100@dbeng50w.hlp 4 Database engine not running in multiuser mode=ERRM89@dbeng50w.hlp 4 Database name not unique=ERRM77@dbeng50w.hlp 4 Database name required to start engine=ERRM87@dbeng50w.hlp 4 Database option '%1' for user '%2' has an invalid setting=ERR113@dbeng50w.hlp 4 Database was initialized with an older version of the software=ERRM266@dbeng50w.hlp 4 Database's page size too big=ERRM97@dbeng50w.hlp 4 Dblib/database engine version mismatch=ERRM231@dbeng50w.hlp 4 Dbspace '%1' not found=ERRM138@dbeng50w.hlp 4 Deadlock detected=ERRM306@dbeng50w.hlp 4 Disallowed language extension detected in syntax near '%1'=ERRM627@dbeng50w.hlp 4 Disk full '%1' -- transaction rolled back=ERRM304@dbeng50w.hlp 4 Division by zero=ERRM628@dbeng50w.hlp 4 Do not have permission to %1=ERRM121@dbeng50w.hlp 4 Duplicate insert column=ERRM637@dbeng50w.hlp 4 Duplicate referencing column=ERRM636@dbeng50w.hlp 4 Dynamic memory exhausted!=ERRM78@dbeng50w.hlp 4 Error in assignment=ERRM641@dbeng50w.hlp 4 Error inserting into cursor=ERRM184@dbeng50w.hlp 4 Error number %1 for RAISERROR is less than 17000=ERRM296@dbeng50w.hlp 4 Error opening cursor=ERRM171@dbeng50w.hlp 4 Error writing to log file=ERRM107@dbeng50w.hlp 4 Feature '%1' not implemented=ERRM134@dbeng50w.hlp 4 Foreign key '%1' for table '%2' duplicates an existing foreign key=ERRM251@dbeng50w.hlp 4 Foreign key name '%1' not found=ERRM145@dbeng50w.hlp 4 Format string argument number %1 is invalid=ERRM294@dbeng50w.hlp 4 Function or column reference to '%1' in the select list must also appear in a GROUP BY=ERRM149@dbeng50w.hlp 4 GRANT of column permission on view not allowed=ERRM635@dbeng50w.hlp 4 I/O error %1 -- transaction rolled back=ERRM305@dbeng50w.hlp 4 Identifier '%1' too long=ERRM250@dbeng50w.hlp 4 Incomplete transactions prevent transaction log renaming=ERRM242@dbeng50w.hlp 4 Index '%1' for table '%2' would not be unique=ERRM196@dbeng50w.hlp 4 Index name '%1' not unique=ERRM111@dbeng50w.hlp 4 INSERT/DELETE on cursor can modify only one table=ERRM199@dbeng50w.hlp 4 Integrated logon failed=ERRM245@dbeng50w.hlp 4 Integrated logons are not permitted=ERRM205@dbeng50w.hlp 4 Internal database error %1 -- transaction rolled back=ERRM301@dbeng50w.hlp 4 Invalid absolute or relative offset in FETCH=ERRM263@dbeng50w.hlp 4 Invalid column number=ERRM159@dbeng50w.hlp 4 Invalid data conversion=ERR103@dbeng50w.hlp 4 Invalid database engine command line=ERRM81@dbeng50w.hlp 4 Invalid datatype for column in WRITETEXT or READTEXT=ERRM609@dbeng50w.hlp 4 Invalid descriptor index=ERRM640@dbeng50w.hlp 4 Invalid escape character '%1'=ERRM629@dbeng50w.hlp 4 Invalid escape sequence '%1'=ERRM630@dbeng50w.hlp 4 Invalid expression near '%1'=ERRM156@dbeng50w.hlp 4 Invalid host variable=ERRM155@dbeng50w.hlp 4 Invalid local database switch=ERRM79@dbeng50w.hlp 4 Invalid operation for this cursor=ERRM187@dbeng50w.hlp 4 Invalid option '%1' -- no PUBLIC setting exists=ERRM200@dbeng50w.hlp 4 Invalid parameter=ERRM95@dbeng50w.hlp 4 Invalid prepared statement type=ERRM133@dbeng50w.hlp 4 Invalid REFERENCES clause in trigger definition=ERRM272@dbeng50w.hlp 4 Invalid setting for option '%1'=ERRM201@dbeng50w.hlp 4 Invalid SQL Anywhere HLI callback function=ERRM405@dbeng50w.hlp 4 Invalid SQL Anywhere HLI command syntax=ERRM400@dbeng50w.hlp 4 Invalid SQL Anywhere HLI cursor name=ERRM401@dbeng50w.hlp 4 Invalid SQL Anywhere HLI host variable name=ERRM403@dbeng50w.hlp 4 Invalid SQL Anywhere HLI host variable value=ERRM404@dbeng50w.hlp 4 Invalid SQL Anywhere HLI statement name=ERRM402@dbeng50w.hlp 4 Invalid SQL descriptor name=ERRM642@dbeng50w.hlp 4 Invalid statement=ERRM130@dbeng50w.hlp 4 Invalid TEXTPTR value used with WRITETEXT or READTEXT=ERRM608@dbeng50w.hlp 4 Invalid type on DESCRIBE statement=ERRM161@dbeng50w.hlp 4 Invalid userid and password on preprocessed module=ERRM104@dbeng50w.hlp 4 Invalid userid or password=ERRM103@dbeng50w.hlp 4 Invalid value for column '%1' in table '%2'=ERRM209@dbeng50w.hlp 4 Item '%1' already exists=ERRM110@dbeng50w.hlp 4 Label '%1' not found=ERRM262@dbeng50w.hlp 4 Language extension=ERRM135@dbeng50w.hlp 4 Language extension detected in syntax=ERR107@dbeng50w.hlp 4 Mismatch between external function platform specifier and current operating system=ERRM618@dbeng50w.hlp 4 More columns are being dropped from table %1 than are defined=ERRM124@dbeng50w.hlp 4 More info required=ERR112@dbeng50w.hlp 4 More than one table is identified as '%1'=ERRM139@dbeng50w.hlp 4 Need a dynamic library name=ERRM619@dbeng50w.hlp 4 No current row of cursor=ERRM197@dbeng50w.hlp 4 No data=ERR100@dbeng50w.hlp 4 No indicator variable provided for NULL result=ERRM181@dbeng50w.hlp 4 No primary key value for foreign key '%1' in table '%2'=ERRM194@dbeng50w.hlp 4 Not allowed while %1 is using the database=ERRM211@dbeng50w.hlp 4 Not connected to SQL database=ERRM101@dbeng50w.hlp 4 Not enough fields allocated in SQLDA=ERRM182@dbeng50w.hlp 4 Not enough memory to start=ERRM86@dbeng50w.hlp 4 Not enough values for host variables=ERRM188@dbeng50w.hlp 4 Null value eliminated in aggregate function=ERR109@dbeng50w.hlp 4 Number in ORDER BY is too large=ERRM152@dbeng50w.hlp 4 Number of columns does not match SELECT=ERRM114@dbeng50w.hlp 4 Only PUBLIC settings are allowed for option '%1'=ERRM202@dbeng50w.hlp 4 Only the DBA can set the option %1=ERRM204@dbeng50w.hlp 4 Operation would cause a group cycle=ERRM122@dbeng50w.hlp 4 Parameter '%1' not found in procedure '%2'=ERRM615@dbeng50w.hlp 4 Parameter name missing in call to procedure '%1'=ERRM639@dbeng50w.hlp 4 Passthrough statement inconsistent with current passthrough=ERRM287@dbeng50w.hlp 4 Primary key column '%1' already defined=ERRM119@dbeng50w.hlp 4 Primary key for row in table '%1' is referenced in another table=ERRM198@dbeng50w.hlp 4 Primary key for table '%1' is not unique=ERRM193@dbeng50w.hlp 4 Procedure '%1' not found=ERRM265@dbeng50w.hlp 4 Procedure has completed=ERR105@dbeng50w.hlp 4 Procedure in use=ERRM215@dbeng50w.hlp 4 Procedure or trigger calls have nested too deeply=ERRM274@dbeng50w.hlp 4 Publication '%1' not found=ERRM280@dbeng50w.hlp 4 RAISERROR executed: %1=ERRM631@dbeng50w.hlp 4 Remote message type '%1' not found=ERRM286@dbeng50w.hlp 4 Remote statement failed=ERRM288@dbeng50w.hlp 4 Request denied -- no active databases=ERRM76@dbeng50w.hlp 4 Request to start/stop database denied=ERRM75@dbeng50w.hlp 4 Result set not allowed from within an atomic compound statement=ERRM222@dbeng50w.hlp 4 Right truncation of string data=ERRM638@dbeng50w.hlp 4 ROLLBACK TO SAVEPOINT not allowed=ERRM221@dbeng50w.hlp 4 Row has been updated since last time read=ERR104@dbeng50w.hlp 4 Row has changed since last read -- operation cancelled=ERRM208@dbeng50w.hlp 4 Run time SQL error -- %1=ERRM300@dbeng50w.hlp 4 Savepoint '%1' not found=ERRM220@dbeng50w.hlp 4 Savepoints require a rollback log=ERRM213@dbeng50w.hlp 4 SELECT lists in UNION do not match in length=ERRM153@dbeng50w.hlp 4 SELECT returns more than one row=ERRM185@dbeng50w.hlp 4 Server/database engine version mismatch=ERRM232@dbeng50w.hlp 4 Specified database is invalid=ERRM84@dbeng50w.hlp 4 Specified database not found=ERRM83@dbeng50w.hlp 4 SQL Anywhere HLI internal error=ERRM406@dbeng50w.hlp 4 SQL statement error=ERRM132@dbeng50w.hlp 4 Sqlpp/dblib version mismatch=ERRM230@dbeng50w.hlp 4 Standard logons are not permitted=ERRM206@dbeng50w.hlp 4 Statement cannot be executed=ERR111@dbeng50w.hlp 4 Statement interrupted by user=ERRM299@dbeng50w.hlp 4 Subquery allowed only one select list item=ERRM151@dbeng50w.hlp 4 Subquery cannot return more than one result=ERRM186@dbeng50w.hlp 4 Subscription to '%1' for '%2' already exists=ERRM282@dbeng50w.hlp 4 Subscription to '%1' for '%2' not found=ERRM283@dbeng50w.hlp 4 Syntax error near '%1'=ERRM131@dbeng50w.hlp 4 Table '%1' has no primary key=ERRM118@dbeng50w.hlp 4 Table '%1' has publications=ERRM281@dbeng50w.hlp 4 Table '%1' is in an outer join cycle=ERRM136@dbeng50w.hlp 4 Table '%1' not found=ERRM141@dbeng50w.hlp 4 Table '%1' requires a unique correlation name=ERRM137@dbeng50w.hlp 4 Table already has a primary key=ERRM112@dbeng50w.hlp 4 Table cannot have two primary keys=ERRM126@dbeng50w.hlp 4 Table in use=ERRM214@dbeng50w.hlp 4 Table must be empty=ERRM116@dbeng50w.hlp 4 Terminated by user -- transaction rolled back=ERRM302@dbeng50w.hlp 4 The selected database is currently inactive=ERRM74@dbeng50w.hlp 4 The supplied buffer was too small to hold all requested query results=ERR400@dbeng50w.hlp 4 There are still active database connections=ERRM109@dbeng50w.hlp 4 There is already a variable named '%1'=ERRM261@dbeng50w.hlp 4 There is more than one way to join '%1' to '%2'=ERRM147@dbeng50w.hlp 4 There is no way to join '%1' to '%2'=ERRM146@dbeng50w.hlp 4 Too many columns in table=ERRM616@dbeng50w.hlp 4 Too many connections to database=ERRM102@dbeng50w.hlp 4 Too many parameters to this external procedure call=ERRM625@dbeng50w.hlp 4 Transact-SQL feature not supported=ERRM611@dbeng50w.hlp 4 Transaction log backup page only partially full=ERR110@dbeng50w.hlp 4 Transaction log was truncated=ERRM244@dbeng50w.hlp 4 Trigger '%1' not found=ERRM268@dbeng50w.hlp 4 Trigger definition conflicts with existing triggers=ERRM271@dbeng50w.hlp 4 Triggers and procedures not supported in runtime engine=ERRM275@dbeng50w.hlp 4 Unable to delete database file=ERRM243@dbeng50w.hlp 4 Unable to find in index '%1' for table '%2'=ERRM189@dbeng50w.hlp 4 Unable to start database engine=ERRM80@dbeng50w.hlp 4 Unable to start specified database=ERRM82@dbeng50w.hlp 4 Unknown backup operation=ERRM240@dbeng50w.hlp 4 Unknown function '%1'=ERRM148@dbeng50w.hlp 4 Unterminated C string=ERRM634@dbeng50w.hlp 4 Update operation attempted on a read-only cursor=ERRM633@dbeng50w.hlp 4 Update operation attempted on non-updatable query=ERRM192@dbeng50w.hlp 4 User '%1' already has grant permission=ERRM120@dbeng50w.hlp 4 User '%1' already has membership in group '%2'=ERRM312@dbeng50w.hlp 4 User '%1' has the row in '%2' locked=ERRM210@dbeng50w.hlp 4 User '%1' is already the publisher for this database=ERRM284@dbeng50w.hlp 4 User '%1' is not a remote user for this database=ERRM285@dbeng50w.hlp 4 User '%1' is not a user group=ERRM123@dbeng50w.hlp 4 User message %1 already exists=ERRM610@dbeng50w.hlp 4 User message %1 not found=ERRM612@dbeng50w.hlp 4 User-defined exception signalled=ERRM297@dbeng50w.hlp 4 User-defined type %1 not found=ERRM613@dbeng50w.hlp 4 Userid '%1' does not exist=ERRM140@dbeng50w.hlp 4 Using temporary table=ERR102@dbeng50w.hlp 4 Value %1 out of range for destination=ERRM158@dbeng50w.hlp 4 Value for column '%1' in table '%2' has changed=ERR106@dbeng50w.hlp 4 Value truncated=ERR101@dbeng50w.hlp 4 Variable '%1' not found=ERRM260@dbeng50w.hlp 4 Warning=ERR200@dbeng50w.hlp 4 WITH CHECK OPTION violated for view '%1'=ERRM632@dbeng50w.hlp 4 Wrong number of parameters to function '%1'=ERRM154@dbeng50w.hlp 4 Wrong number of values for INSERT=ERRM207@dbeng50w.hlp 4 Wrong number of variables in FETCH=ERRM264@dbeng50w.hlp 3 Internal errors (assertion failed)=INTERNAL_ERRORS@dbeng50w.hlp 3 CHAPTER 43. SQL Preprocessor Error Messages 3 CHAPTER 43. SQL Preprocessor Error Messages=INTERNAL_ERRORS_1@dbeng50w.hlp 4 SQLPP errors 4 SQLPP errors=SQLPER@dbeng50w.hlp 4 subscript value %ld too large=SQLPER_1@dbeng50w.hlp 4 combined pointer and arrays not supported for hosttypes=SQLPER_2@dbeng50w.hlp 4 only one dimensional arrays supported for char type=SQLPER_3@dbeng50w.hlp 4 VARCHAR type must have a length=SQLPER_4@dbeng50w.hlp 4 arrays of VARCHAR not supported=SQLPER_5@dbeng50w.hlp 4 VARCHAR host variables cannot be pointers=SQLPER_6@dbeng50w.hlp 4 initializer not allowed on VARCHAR host variable=SQLPER_7@dbeng50w.hlp 4 FIXCHAR type must have a length=SQLPER_8@dbeng50w.hlp 4 arrays of FIXCHAR not supported=SQLPER_9@dbeng50w.hlp 4 arrays of int not supported=SQLPER_10@dbeng50w.hlp 4 precision must be specified for decimal type=SQLPER_11@dbeng50w.hlp 4 arrays of decimal not allowed=SQLPER_12@dbeng50w.hlp 4 Unknown hostvar type=SQLPER_13@dbeng50w.hlp 4 invalid integer=SQLPER_14@dbeng50w.hlp 4 '%s' host variable must be a C string type=SQLPER_15@dbeng50w.hlp 4 '%s' symbol already defined=SQLPER_16@dbeng50w.hlp 4 invalid type for sql statement variable=SQLPER_17@dbeng50w.hlp 4 Cannot find include file '%s'=SQLPER_18@dbeng50w.hlp 4 host variable '%s' is unknown=SQLPER_19@dbeng50w.hlp 4 indicator variable '%s' is unknown=SQLPER_20@dbeng50w.hlp 4 invalid type for indicator variable '%s'=SQLPER_21@dbeng50w.hlp 4 invalid host variable type on '%s'=SQLPER_22@dbeng50w.hlp 4 host variable '%s' has two different definitions=SQLPER_23@dbeng50w.hlp 4 statement '%s' not previously prepared=SQLPER_24@dbeng50w.hlp 4 cursor '%s' not previously declared=SQLPER_25@dbeng50w.hlp 4 unknown statement '%s'=SQLPER_26@dbeng50w.hlp 4 host variables not allowed for this cursor=SQLPER_27@dbeng50w.hlp 4 host variables specified twice - on declare and open=SQLPER_28@dbeng50w.hlp 4 must specify a host list or using clause on %s=SQLPER_29@dbeng50w.hlp 4 no INTO clause on SELECT statement=SQLPER_30@dbeng50w.hlp 4 incorrect Embedded SQL syntax=SQLPER_31@dbeng50w.hlp 4 missing ending quote of string=SQLPER_32@dbeng50w.hlp 4 token too long=SQLPER_33@dbeng50w.hlp 4 '%s' host variable must be an integer type=SQLPER_34@dbeng50w.hlp 4 SQLPP warnings 4 SQLPP warnings=SQLPWAR@dbeng50w.hlp 4 Into clause not allowed on declare cursor - ignored=SQLPWAR_1@dbeng50w.hlp 4 unrecognized SQL syntax=SQLPWAR_2@dbeng50w.hlp 4 unknown sql function '%s'=SQLPWAR_3@dbeng50w.hlp 4 wrong number of parms to sql function '%s'=SQLPWAR_4@dbeng50w.hlp 4 static statement names will not work properly if used by 2 threads=SQLPWAR_5@dbeng50w.hlp 3 CHAPTER 44. Differences from Other SQL Dialects 3 CHAPTER 44. Differences from Other SQL Dialects=DIFFOTH@dbeng50w.hlp 3 SQL Anywhere features=DIFFFEATURES@dbeng50w.hlp 3 CHAPTER 45. SQL Anywhere Limitations 3 CHAPTER 45. SQL Anywhere Limitations =LIMITS@dbeng50w.hlp 3 Size and number limitations=LT_SIZE@dbeng50w.hlp 3 CHAPTER 46. SQL Anywhere Keywords 3 CHAPTER 46. SQL Anywhere Keywords=KEYWD@dbeng50w.hlp 3 Alphabetical list of keywords=ALHAKEYWORDS@dbeng50w.hlp 3 CHAPTER 47. SQL Anywhere System Procedures and Functions 3 CHAPTER 47. SQL Anywhere System Procedures and Functions=SYSPROCS@dbeng50w.hlp 3 System procedure overview=SPOV@dbeng50w.hlp 3 Catalog stored procedures=SPCSP@dbeng50w.hlp 4 System extended stored procedures 4 System extended stored procedures=SPEP@dbeng50w.hlp 5 MAPI system extended stored procedures 5 MAPI system extended stored procedures=SPEPMP@dbeng50w.hlp 5 xp_startmail system procedure=SPMSPST@dbeng50w.hlp 5 xp_sendmail system procedure=SPMSPSE@dbeng50w.hlp 5 xp_stopmail system procedure=SPMSPSP@dbeng50w.hlp 5 Other system extended stored procedures 5 Other system extended stored procedures=SPEPOP@dbeng50w.hlp 5 xp_cmdshell system procedure=SPSPCM@dbeng50w.hlp 5 xp_msver system function=SPSPCM_1@dbeng50w.hlp 5 xp_sprintf system procedure=SPSPSP@dbeng50w.hlp 5 xp_scanf system procedure=SPSPSF@dbeng50w.hlp 3 CHAPTER 48. SQL Anywhere System Tables 3 CHAPTER 48. SQL Anywhere System Tables=SYSDEF@dbeng50w.hlp 3 System tables diagram=STDG@dbeng50w.hlp 4 Alphabetical list of system tables 4 Alphabetical list of system tables=ALPHATABLE@dbeng50w.hlp 4 DUMMY system table=SYSDUMMY@dbeng50w.hlp 4 SYSARTICLE system table=SYSART@dbeng50w.hlp 4 SYSARTICLECOL system table=SYSARTC@dbeng50w.hlp 4 SYSCOLLATE system table=SYSCOLLAT@dbeng50w.hlp 4 SYSCOLPERM system table=SYSCOLPERM@dbeng50w.hlp 4 SYSCOLUMN system table=SYSCOLUMN@dbeng50w.hlp 4 SYSDOMAIN system table=SYSDOMAIN@dbeng50w.hlp 4 SYSFILE system table=SYSTFILE@dbeng50w.hlp 4 SYSFKCOL system table=SYSFKCOL@dbeng50w.hlp 4 SYSFOREIGNKEY system table=SYSFORKEY@dbeng50w.hlp 4 SYSGROUP system table=SYSGROUP@dbeng50w.hlp 4 SYSINDEX system table=SYSINDEX@dbeng50w.hlp 4 SYSINFO system table=SYSINFO@dbeng50w.hlp 4 SYSIXCOL system table=SYSIXCOL@dbeng50w.hlp 4 SYSOPTION system table=SYSOPTION@dbeng50w.hlp 4 SYSPROCEDURE system table=SYSPROC@dbeng50w.hlp 4 SYSPROCPARM system table=SYSPRPAR@dbeng50w.hlp 4 SYSPROCPERM system table=SYSPRPER@dbeng50w.hlp 4 SYSPUBLICATION system table=SYSPUB@dbeng50w.hlp 4 SYSREMOTEUSER system table=SYSREM@dbeng50w.hlp 4 SYSSUBSCRIPTION system table=SYSSUB@dbeng50w.hlp 4 SYSTABLE system table=SYSTABLE@dbeng50w.hlp 4 SYSTABLEPERM system table=SYSTABPERM@dbeng50w.hlp 4 SYSTRIGGER system table=SYSTRIG@dbeng50w.hlp 4 SYSUSERMESSAGES system table=SYSUM@dbeng50w.hlp 4 SYSUSERPERM system table=SYSUP@dbeng50w.hlp 4 SYSUSERTYPE system table=SYSUTP@dbeng50w.hlp 3 CHAPTER 49. SQL Anywhere System Views 3 CHAPTER 49. SQL Anywhere System Views=SYSVIEW@dbeng50w.hlp 4 Alphabetical list of views 4 Alphabetical list of views=ALPHAVIEW@dbeng50w.hlp 4 SYS.SYSCATALOG=SYSCATALOG@dbeng50w.hlp 4 SYS.SYSCOLAUTH=SYVCOLA@dbeng50w.hlp 4 SYS.SYSCOLUMNS=SYVCOL@dbeng50w.hlp 4 SYS.SYSFOREIGNKEYS=SYVFK@dbeng50w.hlp 4 SYS.SYSGROUPS=SYVGRP@dbeng50w.hlp 4 SYS.SYSINDEXES=SYVINDEX@dbeng50w.hlp 4 SYS.SYSOPTIONS=SYVOPT@dbeng50w.hlp 4 SYS.SYSPROCPARMS=SYVPRPAR@dbeng50w.hlp 4 SYS.SYSREMOTEUSERS=SYVREMUSR@dbeng50w.hlp 4 SYS.SYSTABAUTH=SYVTABA@dbeng50w.hlp 4 SYS.SYSTRIGGERS=SYVTRIG@dbeng50w.hlp 4 SYS.SYSUSERAUTH=SYVAUTH@dbeng50w.hlp 4 SYS.SYSUSERLIST=SYVUL@dbeng50w.hlp 4 SYS.SYSUSEROPTIONS=SYVUOPT@dbeng50w.hlp 4 SYS.SYSUSERPERMS=SYVUPER@dbeng50w.hlp 4 SYS.SYSVIEWS=SYVVIEWS@dbeng50w.hlp 1 Glossary=GLOSSARY@dbeng50w.hlp :include servnt.cnt :include nidyna.cnt :include ltm50ent.cnt