New Features and Upgrading Guide
CHAPTER 2. New Features in Adaptive Server Anywhere 6.0.1
Starting with Adaptive Server Anywhere Version 6.0.1, a single connection can access data from external data sources, as if it were stored on the local server. Supported external data sources include the following:
Adaptive Server Anywhere databases
Adaptive Server Enterprise databases
Oracle databases
IBM DB2 databases
Microsoft SQL Server Databases
Other ODBC data sources
There are several aspects to the remote data access features::
Carry out queries that join tables in external data sources to tables in the local data source, or to other external data sources.
Insert, update, and delete data in external data sources.
Send statements to a remote server in its native SQL syntax.
Migrate data from one server to another.
For information about remote data access, see the chapter Accessing Remote Data and the chapter Server Classes for Remote Data Access. These chapters contain pointers to the relevant reference sections.
Sybase Central (Java Edition)Sybase Central is now available in a Java Edition as well as the 32-bit Windows version. The Java Edition of Sybase Central runs on any platform for which a Java runtime environment is available.
Java Sybase Central can be used to manage the remote data access features of Adaptive Server Anywhere. This feature is not available in the Windows version of Sybase Central.
For information, see Accessing Remote Data.
Sybase Central (Java Edition) is not included on the 6.0.1 CD-ROM.
To obtain Sybase Central (Java Edition), go to http://techinfo.sybase.com/css/techinfo.nsf/DocID/ID=47872 at the Sybase Technical Library.
You can connect to databases using either JDBC (through Sybase jConnect) or ODBC (using a JDBC/ODBC bridge). It is recommended that you use JDBC (jConnect) to connect to databases.
To use jConnect, you must specify a user ID, password, and a URL. The URL consists of the following:
Machine name If the server is running on the same machine as Sybase Central, you can use the machine name localhost.
Port Number By default, Adaptive Server Anywhere uses port 2638 for TCP/IP connections. You need change this setting only if your server was instructed to use a different port when it was started.
Database name If you are connecting to a server running more than one database, you can enter a database name to select which one you will connect to.
Online Help for the Java Edition of Sybase Central will be provided once JavaHelp, the online Help system for Java applications, is available. Currently, Java has no online Help system.
For information on using Sybase Central to manage access to remote data, see the following locations:
The Java Edition of Sybase Central does not currently have all the features of the Windows version. In the Java Edition you cannot do the following:
Manage or start Windows NT services.
Use drag and drop operations
Use copy and paste operations.
Use connection profiles
Start Interactive SQL to view data.
Display a list of available ODBC data sources when connecting to a database.
Start other tools (PowerDesigner, ODBC Administrator, and so on) from Sybase Central
Use Integrated logins, although you can create them.
Execute SQL Remote passthrough mode statements.
Add base Java classes to the database
Re-install metadata support for jConnect.
Upgrade a database from the utility folder. Instead, you must right-click the database and select Upgrade from the popup menu.
Extract a database for SQL Remote by right-clicking on the database.