Introduction

Using Adaptive Server Anywhere you can:

Access data in relational databases such as Sybase, Oracle, and DB2.
Access desktop data such as Excel spreadsheets, MS-Access databases, FoxPro, and text files.
Access any other data source that supports an ODBC interface.
Perform joins between local and remote data.
Perform joins between tables in separate Adaptive Server Anywhere databases.
Use Adaptive Server Anywhere features on data sources that would normally not have that ability. For instance, you could use a Java function against data stored in Oracle, or perform a subquery on spreadsheets. Adaptive Server Anywhere will compensate for features not supported by a remote data source by operating on the data after it is retrieved.
Use Adaptive Server Anywhere to move data from one location to another using insert-select.
Access remote servers directly using passthrough mode.
Execute remote procedure calls to other servers.

Adaptive Server Anywhere allows access to the following external data sources:

Platform availability
The remote data access features are supported on the Windows 95 and Windows NT platforms only.

Accessing remote data from PowerBuilder DataWindows

You can access remote data can be accessed from a PowerBuilder DataWindow by setting the DBParm Block parameter to 1 on connect.

In the design environment, you can set the Block parameter by accessing the Transaction tab in the Database Profile Setup dialog and setting the Retrieve Blocking Factor to 1.
In a connection string, use the following phrase:
```
DBParm="Block=1"
```