The DB2 Everyplace solution has the following key components:
The DB2 Everyplace database is available for:
DB2 Everyplace includes a Query-by-Example application for Palm OS devices that users can use to view and update the database. All supported devices include a Command Line Processor. The SQL statements supported by DB2 Everyplace enable you to create or drop a table or index, and delete, insert, or update rows of a table. Information about supported SQL statements is found in the DB2 Everyplace Application Development Guide.
You can synchronize data and applications between DB2 Everyplace client devices and enterprise data sources by using DB2 Everyplace Sync Server and DB2 Everyplace Sync Client.
Data synchronization can be bi-directional or uni-directional. Data can be updated at the DB2 Everyplace mobile device or the enterprise database. For example, users could download a subset of data from a DB2 for z/OS database to a DB2 Everyplace database on the mobile device, view the data, make changes to the data, and then synchronize the changed data back to the z/OS server. The synchronization server also provides a mechanism for conflict resolution.
DB2 Everyplace Sync Server supports synchronizing relational data with the following operating systems:
The DB2 Everyplace Sync Client, which runs on mobile devices, is comprised of applications that work with the DB2 Everyplace Sync Server. It handles bi-directional synchronization of enterprise relational data with the DB2 Everyplace database on the device. The client also manages operations related to file subscriptions for easy distribution of mobile applications to the device and can execute stored procedures stored on a DB2 UDB database. The Sync Client is available for the following operating systems:
For information about the Application Programming Interfaces (APIs) provided with the Sync Client, see DB2 Everyplace Application Development Guide.
You can develop DB2 Everyplace applications on a workstation with off-the-shelf C/C++ and Java development tools, such as: DB2 Everyplace Mobile Application Builder; Visual Age Micro Edition; Metrowerks CodeWarrior, Release 6; or the GNU Software Developer's Kit.
DB2 Everyplace Mobile Application Builder can build Palm OS applications without writing a single line of code. DB2 Everyplace Mobile Application Builder is available from the DB2 Everyplace Web site.
The DB2 Everyplace CLI/ODBC interface is a subset of DB2 UDB CLI. For more information on the DB2 UDB CLI functions supported by DB2 Everyplace, see the DB2 Everyplace Application Development Guide.