Using Database On-Demand clients
The Database On-Demand client is a Java applet that allows an end user to build SQL statements and File Upload statements, to send these SQL statements and File Upload statements to a remote database server, and to retrieve the results of SQL queries (SQL Select statements) from the remote database server.
The user can communicate with a database server running on an IBM System i server or other platform, so long as the proper Java Database Connectivity (JDBC) driver is installed on the Database On-Demand client workstation. For more information refer to Obtaining and installing a JDBC driver in this manual.
- Text and graphical interfaces for constructing SQL statements and File Upload statements.
- The ability to save and reuse SQL statements and File Upload statements.
- For SQL statements:
- The ability to run an SQL statement and display the results.
- The ability to save the results of an SQL statement into a file in various file formats, including XML (see File formats for database access in this manual).
- For File Upload statements:
- The ability to use the following File Upload types: create, replace, append, and update.
- The ability to read data files in various file formats, including XML (see File formats for database access in this manual).
The Database On-Demand client is available only through one of three predefined client HTML files (see Database On-Demand predefined clients). You cannot use the Deployment Wizard to create a Database On-Demand client.
However, as an alternative to the Database On-Demand client, you can now use database functions in Z and I Emulator for Web emulation clients and in macros (see Database functions in Display Emulation clients and in macros).
For more information see Overview of database access in the Z and I Emulator for Web online help.
- An end user running a Java-enabled browser automatically runs the Java version of the Database On-Demand client.