Introduction to PowerBuilder

Adaptive Server Anywhere

Adaptive Server Anywhere (also called 'Watcom SQL') was a product of Watcom, which later merged with Powersoft at the time of PowerBuilder 4.0 development. Adaptive Server Anywhere is a full-featured transaction processing SQL database management system, which performance excellently even with its fewer resource requirements (memory space, disk space, and CPU speed) than other database management systems.

Adaptive Server Anywhere is a fast and efficient database for many environments, from notebook computers to servers supporting large numbers of concurrent users. It is a flexible and scalable solution for today's diverse needs. One great feature that you don’t find in any other database is that the database files are compatible between versions and across all operating systems.

Adaptive Server Anywhere is available for Windows NT, Windows 95, Windows 3.x, OS/2, NetWare, Solaris, HP-UX, AIX, DOS, and QNX operating systems. Adaptive Server Anywhere can be used as a standalone database management system or (on non-UNIX operating systems) as a network database server, in a client/server environment.

Adaptive Server Anywhere is an ideal database for a variety of application developers—such as C, PowerBuilder, etc. for developing single-user and/or client/server applications for workgroups and mobile usage. Currently Adaptive Server Anywhere supports ODBC 2.1 level 2, as well as other interfaces.

From version 5.0 onwards, this database completely supports Transact SQL (Transact SQL is an enhanced version of ANSI SQL, used in Sybase SQL Server as well as Microsoft SQL Server), and also, Adaptive Server Anywhere supports replication in different ways, which ideally is used in mobile applications.

Home	Previous Lesson: PowerDesigner Next Lesson: PowerBuilder Library for Lotus Notes