ASA Programming Interface Guide This chapter provides an introductory overview of each of the programming interfaces for Adaptive Server Anywhere. Any client application uses one of these interfaces to communicate with the database, and this chapter provides some guidelines to help you choose an appropriate interface for your application.
ODBC (Open Database Connectivity) is a standard call level interface (CLI) developed by Microsoft. It is based on the SQL Access Group CLI specification. ODBC applications can run against any data source that provides an ODBC driver. You should use ODBC if you would like your application to be portable to other data sources that have ODBC drivers. Also, if you prefer working with an API, use ODBC.
ODBC is a low-level interface--about the same as Embedded SQL. Almost all the Adaptive Server Anywhere functionality is available with this interface. ODBC is available as a DLL under Windows NT, Windows 95, and Windows 3.x. It is provided as a library for UNIX.
ASA Reference Manual
This chapter describes the installation and operating system settings used by Adaptive Server Anywhere. Depending on the operating system, these settings may be stored as environment variables, initialization file entries, or registry
entries. When you install Adaptive Server Anywhere, several directories may be created. Some of the files in these directories are essential, and others are not. This section describes the directory structure.
Adaptive Server Anywhere software, whether you receive it as a product or bundled as part of another product, is installed under a single installation directory. The tools provided with the Adaptive Server Anywhere product, however, are installed in other directories. This section describes only the installation directory structure for Adaptive Server Anywhere itself.
ASA User's Guide
This manual describes how to use Adaptive Server Anywhere. It includes material needed to develop applications that work with Adaptive Server Anywhere and material for designing, building, and administering Adaptive Server Anywhere databases.
Intended for all users of Adaptive Server Anywhere, this book describes the following:
* New features in Adaptive Server Anywhere.
* Behavior changes from previous releases
* Upgrade procedures.
The Application integration for CORBA 2.0 for NT and UNIX A more recent version of this release bulletin may be available on the World Wide Web. To check for critical product or document information added after the release of the product CD, use the Sybase Technical Library Product Manuals Web site.
Enclosed is Sybase Application Integrator for CORBA 2.0 (hereafter referred to as AI for CORBA), which is compatible with the following platform and operating system configurations:
* Windows NT 4.0/2000
* Sun Solaris 2.7
The Java Adaptive Server enterprise Adaptive Server provides a runtime environment for Java, which means that Java code can be executed in the server. Building a runtime environment for Java in the database server provides powerful new ways of managing and storing both data and logic.
* You can use the Java programming language as an integral part of Transact-SQL.
* You can reuse Java code in the different layers of your application--client, middle-tier, or server--and use them wherever makes most sense to you.
* Java in Adaptive Server provides a more powerful language than stored procedures for building logic into the database.
* Java classes become rich, user-defined data types.
* Methods of Java classes provide new functions accessible from SQL.