Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 Documentation Errata

Copyright © 2007, iAnywhere Solutions, Inc.
All rights reserved. All unpublished rights reserved.

Contents
========

This file lists significant factual corrections to the documentation for
SQL Anywhere Studio 10.0.1.

The entries are arranged by book. The book names appear in the Online 
Books table of contents. Each entry is described by a location and a 
description, as follows:

Location: 
  chapter-name > section-name > subsection-name

Description:
  The text incorrectly states that...
  It should state that...


SQL Anywhere 10 - Introduction
==============================

SQL Anywhere 10 - Changes and Upgrading
=======================================

SQL Anywhere 10 - Context-Sensitive Help
========================================

SQL Anywhere 10 - Error Messages
================================

SQL Anywhere Server - Database Administration
=============================================

Location:
  SQL Anywhere Server - Database Administration
  > Database Administration Utilities
  > Language Selection utility (dblang)

Description:
  The text incorrectly states that -q is the only option for the dblang
  utility.

  It should state that the -m and -u options are also supported. When you
  specify the -m option, the language code is written to the registry under
  HKEY_LOCAL_MACHINE. When you specify the -u option, the language code is
  written to the registry under HKEY_CURRENT_USER. If you do not specify -m
  or -u, then the language code is written to the registry under
  HKEY_CURRENT_USER. You can specify both -m and -u to write the language
  code to both locations.

-----------------------------------------------------------------------------

Location:
  SQL Anywhere Server - Database Administration
  > Database Administration Utilities
  > Initialization utility (dbinit)

Description:
  The documentation should state that the dbinit -e option is deprecated. It
  is recommended that you use the -ea option instead.

-----------------------------------------------------------------------------

Location:
  SQL Anywhere Server - Database Administration
  > Connecting to a Database
  > Working with ODBC data sources
  > Creating an ODBC data source on Mac OS X

Description:
  The text incorrectly states that the data source name is
  SQL Anywhere 10 Demo in step 4 of the procedure "To create an ODBC data
  source". It should state that the name of the ODBC data source is Demo10.

  The connection parameters table in Step 4 of this procedure is missing the
  Driver connection parameter:

  Keyword  Value
  ==================================================================
  Driver   /Applications/SQLAnywhere10/System/lib32/dbodbc10_rbundle

-----------------------------------------------------------------------------

Location:
  SQL Anywhere® Server - Database Administration
  > Transport-Layer Security
  > Encrypting MobiLink client/server communications
  > Configuring MobiLink clients to use transport-layer security
  > Configuring SQL Anywhere clients to use transport-layer security

Description:
  The final two examples are incorrect. The correct examples are as follows:

  The following example specifies RSA security and TCP/IP. It must all be
  written on one line:

    dbmlsync -c "eng=rem1;uid=myuid;pwd=mypwd"
       -e "ctp=tcpip;
       adr=port=3333;
           tls_type=rsa;
           trusted_certificates=c:\test\public_cert.crt;
           certificate_company=Sybase, Inc.;
           certificate_unit=IAS;
           certificate_name=MobiLink"

  Alternatively, you can specify the CommunicationAddress extended option
  using the CREATE SYNCHRONIZATION SUBSCRIPTION or ALTER SYNCHRONIZATION
  SUBSCRIPTION statement:

    CREATE SYNCHRONIZATION SUBSCRIPTION 
     TO pub1 
     FOR user1 
     ADDRESS 'port=3333;
        tls_type=rsa;trusted_certificates=public_cert.crt;
           certificate_company=Sybase, Inc.;
           certificate_unit=IAS;
           certificate_name=MobiLink';

-----------------------------------------------------------------------------

Location:
  SQL Anywhere Server - Database Administration
  > Database Administration Utilities
  > Interactive SQL utility (dbisqlc)

Description:
  In the Syntax section, immediately after the dbisqlc syntax, the following
  sentence should not appear: "Scan commands but do not execute them. This
  is useful for checking long command files for syntax errors."

  The same sentence, located in the description of the -x option, is correct.


SQL Anywhere Server - Programming
=================================

Location:
  SQL Anywhere Server - Programming
  > Deploying Databases and Applications
  > Deploying client applications
  > Deploying JDBC clients

Description:
  The text states that, for dbjodbc10.dll, the Unix shared library name is
  libdbjodbc10.so. The text should also state that, for MAC OS X, the shared
  library is called libdbjodbc10.jnilib.


SQL Anywhere Server - SQL Reference
===================================

Location: 
  SQL Anywhere Server - SQL Reference
  > Views
  > System views in Sybase Central
  > SYSTRIGGER system view

Description: 
  The following two values are also possible for the SYSTRIGGER trigger_time
  field,
    I - INSTEAD OF (row-level trigger)
    K - INSTEAD OF (statement-level trigger)


SQL Anywhere Server - SQL Usage
===============================

Location:
  SQL Anywhere® Server - SQL Usage
  > Working with Database Objects
  > Working with views
  > View dependencies
  > View status

Description:
  The current documentation states: "If you alter t to remove c1, the status
  of v1 is set to INVALID when the database server tries to recompile the
  view as part of the ALTER operation that drops the column. In this case,
  v1 can recompile only after c1 is added back to t, or v1 is changed to no
  longer refer to c1."

  This incorrectly implies that an ALTER VIEW statement can correct the
  problem with the INVALID view. Following are the two ways to resolve an
  INVALID view:

  1. DROP the view, and then CREATE it without the referenced column. Upon 
     successful creation of the view, the view is automatically enabled.
  2. Restore the referenced object (table, column, etc.) and execute an
     ALTER VIEW .. ENABLE to  re-enable the view.


MobiLink - Getting Started
==========================

MobiLink - Client Administration
================================

Location:
  MobiLink - Client Administration
  > MobiLink Client Network Protocol Options
  > trusted_certificates

Description:
  The UltraLite examples are incorrect. The correct examples are as follows:

  On an UltraLite client, the implementation is:
    info.stream = "https";
    info.stream_parms = TEXT(
      "port=9999;
       trusted_certificates=\rsaroot.crt;
       certificate_name=RSA Server");

  On an UltraLite client running Palm OS, the stream and stream_parms can be
  set like this:
    info.stream = "https";
    info.stream_parms = "trusted_certificates=vfs:/rsaroot.crt;port=9999";


MobiLink - Server Administration
================================

MobiLink - Server-Initiated Synchronization
===========================================

QAnywhere
=========

Location:
  QAnywhere
  > Mobile Web Services
  > Compiling and running mobile web service applications

Description:
  The following information is missing: Mobile web services are supported
  only on JDK 1.5 and higher.

SQL Remote
==========

UltraLite - Database Management and Reference
=============================================

Location:
  UltraLite - Database Management and Reference
  > UltraLite Utilities Reference
  > UltraLite Data Management utility for Palm OS (ULDBUtil)

Description:
  The following information is missing from the description: The ULDBUtil
  utility is used to back up and/or delete databases from Palm OS devices.
  It does this by using a filter; only those databases that meet the filter
  requirements are detected. Note that this filter does not detect and list
  any UltraLite databases with the following extensions: .bak, .dat, .dba,
  .htm, .html, .ini, .jpeg, .jpg, .prc, .pqa, and .tda.


UltraLite - AppForge Programming
================================

UltraLite - C and C++ Programming
=================================

UltraLite - M-Business Anywhere Programming
===========================================

UltraLite - .NET Programming
============================