Installation manual

Chapter 11. Database On-Demand overview

Note: If you are using Database On-Demand with Netscape 4.x, you must turn the

Just In Time (JIT) compiler off. Unfortunately, due to problems found with

the JIT compiler, this means that you cannot take advantage of both the

Database On-Demand and integrated Windows domain logon functions.

Database On-Demand is a Java applet that allows users to perform SQL requests to

iSeries databases through a JDBC driver. Database On-Demand is shipped with a

JDBC driver for the iSeries. Other user-installed JDBC drivers can be registered and

used, although IBM does not provide support for these drivers.

Features of Database On-Demand include:

v A graphical interface to aid in constructing SQL statements and File Upload

statements

v The ability to display on screen the results of the executable statements you

build, to save the results of SQL statements in various file formats and to upload

entire files in various formats to a host database

v The ability to create dynamic queries, using the graphical interface, that can be

executed or saved for later use

For more Database On-Demand overview information, see Database On-Demand

in the Host On-Demand online help.

To configure users so they can access Database On-Demand, you must first either

have groups and users defined or define them. Then you can define the database

functions that groups and users can perform and later manage the statements that

users have created. The administrator cannot create SQL statements for users.

For more detailed information about setting up groups and users to access

Database On-Demand, see getting started with Database On-Demand and setting

Database On-Demand options for users in the Host On-Demand online help.

If you wish to use multiple code pages with Database On-Demand, you must add

jar or cab files to your HTML. Only those code pages that correspond to the

language of the HTML file are automatically loaded, so for example you are

running from a French computer but you want to access a Dutch host, you must

make these modifications.

If you are using Database On-Demand as a Download Client with Netscape 6 or

another Java2-enabled browser, then the HODDatabase_xx.html file must be

modified, where xx is the two- or four-letter country or region designator. Look for

the line that starts with the ″APPLET archive=″ tag. Add the correct jar filename

from the table below.

If you are using Database On-Demand as a Cached Client with a non-Java 2

enabled browser (such as Internet Explorer 5.x), then you must edit the file

HODDatabaseCached_xx.html. In the line starting ″PARAM

NAME=PreloadComponentList″, add the correct component from the table below.

If you are using Database On-Demand as a Cached Client with Netscape 6 or

another Java2-enabled browser, then you must make two changes to the