Home

	Expand Search

Ultralite Developer's Guide

About This Book

About This Book

About This Manual

Subject

This manual describes the UltraLite technology for Adaptive Server Anywhere. UltraLite allows you to deploy database applications to small or mobile embedded devices, such as devices running the Palm Computing Platform or Windows CE.

MobiLink synchronization technology is a key part of UltraLite, and is also described in this manual.

Audience

This manual is intended for all application developers writing programs that use the UltraLite deployment option. Familiarity with relational databases and Adaptive Server Anywhere is assumed.

Adaptive Server Anywhere documentation

Online documentation is most current

Adaptive Server Anywhere online documentation is updated with each maintenance release, and is up to date. Printed documentation is not necessarily updated with each maintenance release.

The Adaptive Server Anywhere documentation consists of the following books:

• New Features and Upgrading Guide

  Intended for all users of Adaptive Server Anywhere, this book describes the following:

  • New features in Adaptive Server Anywhere 6.0 and its maintenance releases.

  • Behavior changes from previous releases

  • Upgrade procedures..

• User's Guide

  Intended for all users of Adaptive Server Anywhere, including database administrators and application developers, this book describes in depth all aspects of how to use Adaptive Server Anywhere.

• Programming Interfaces Guide

  Intended for application developers writing programs that directly access the ODBC, Embedded SQL, or Open Client interfaces, this book describes how to develop applications for Adaptive Server Anywhere.

  This book is not required for users of Application Development tools with built-in ODBC support, such as Powersoft PowerBuilder or Power++.

• UltraLite Developer's Guide

  This book. Intended for application developers writing programs using the UltraLite deployment option of Adaptive Server Anywhere. UltraLite allows you to deploy database applications to small or mobile embedded devices, such as PDAs and cellular phones.

• Reference Manual

  A full reference to Adaptive Server Anywhere. This book describes the database server, the administration utilities, the SQL language, and error messages.

• Data Replication with SQL Remote

  A complete description of the SQL Remote replication system.

• Quick Reference Guide

  A handy printed booklet with complete SQL syntax and other key reference material in a concise format.

The format of these books (printed or online) may depend on the product in which you obtained Adaptive Server Anywhere.

Depending on which package you have purchased, you may have additional books describing other components of your product.

Documentation conventions

This section lists the typographic and graphical conventions used in this documentation.

Syntax conventions

The following conventions are used in the SQL syntax descriptions:

• Keywords

  All SQL keywords are shown in UPPER CASE. However, SQL keywords are case insensitive, so you can enter keywords in any case you wish; SELECT is the same as Select which is the same as select.

• Placeholders

  Items that must be replaced with appropriate identifiers or expressions are shown in italics.

• Continuation

  Lines beginning with ... are a continuation of the statements from the previous line.

• Repeating items

  Lists of repeating items are shown with an element of the list followed by an ellipsis (three dots). One or more list elements are allowed. If more than one is specified, they must be separated by commas.

• Optional portions

  Optional portions of a statement are enclosed by square brackets. For example, ...

  RELEASE SAVEPOINT [ savepoint-name ] 

  ... indicates that the savepoint-name is optional. The square brackets should not be typed.

• Options

  When none or only one of a list of items must be chosen, the items are separated by vertical bars and the list enclosed in square brackets.

  For example, ...

  [ ASC | DESC ]

  ... indicates that you can choose one of ASC, DESC, or neither. The square brackets should not be typed.

• Alternatives

  When precisely one of the options must be chosen, the alternatives are enclosed in curly braces. For example ...

  QUOTES { ON | OFF }

  ... indicates that exactly one of ON or OFF must be provided. The braces should not be typed.

Graphic icons

The following icons are used in this documentation:

Icon	Meaning
	A client application.
	A database server, such as Sybase Adaptive Server Anywhere or Adaptive Server Enterprise.
	An Adaptive Server Anywhere database server.
	A SQL Remote Message Agent
	A Sybase Replication Server.
	A Replication Agent. A replication agent is required for a database to act as a primary data site in Sybase Replication Server installations.

The sample application

CustDB is a simple sales-status application. It is located in the UltraLite samples directory of your installation. Generic files are located in the CustDB directory. Files specific to the Palm Computing Platform are located in the palm subdirectory of CustDB, those specific to Windows CE are in the vc6\CECustDB directory, and those for a Windows console version are stored in vc6\NTCustDB.

This application and its associated database are used many times throughout the documentation.

The following figure shows the tables in the CustDB database and how they are related to each other.

The database schema is described in the file CustDB.sql, also located in the CustDB directory.

For information on building the sample application for the Palm Computing Platform, see Building the CustDB sample application .

For information on building the sample application for Windows CE, see Building the CustDB sample application .