Getting started with Database On-Demand

The Database On-Demand client lets you extract data from an iSeries database for use in a client workstation application, and upload files created on the client to the iSeries database.

To start Database On-Demand:

1. Load the Database On-Demand client, HODDatabase.html, into a browser.
2. Type your user ID and password for the Host On-Demand server that you are accessing.
3. Click Log On.

When the client window opens you are presented with two tabs:

• The SQL Wizard tab
  The SQL Wizard tab is the default view. It displays a view of previously saved SQL statements. You can open, run and delete existing SQL statements, and create new SQL statements.
• The File Upload tab
  This tab displays a view of previously saved File Upload statements. You can open, run and delete existing File Upload statements, and create new File Upload statements.

Creating a new SQL or File Upload statement
Opening an existing SQL or File Upload statement
Running an existing SQL or File Upload statement
Deleting an existing SQL or File Upload statement

If you are loading the Database On-Demand client on a UNIX operating system, and you cannot see the logon text you enter, try changing the color of the desktop:

1. Start the application Desktop Style from the toolbar.
2. Start the application Colors and select a different color setting.

Creating a new SQL or File Upload statement

To create a new SQL or File Upload statement and save the statement for later use:

1. Click New. The logon tab displays.
2. Type the URL for the iSeries database:

   jdbc:as400://iSeriesname

   To use SSL when connecting:

   jdbc:as400://iSeriesname;secure=true

   To use a proxy server when connecting to the iSeries database, include the proxy server name and port number:

   jdbc:as400://iSeriesname;proxy server=HODServerName:proxyServerPort
   

3. Type your user ID and password (if required) for the database.
4. Select the JDBC driver you want to use to access the database. (See Logon tab for more information for this tab.)
5. Click Connect to connect to the database.
6. Once you are connected, a series of new tabs appears at the top of the Logon tab. The tabs that appear depend on whether you are creating a new SQL statement or a new File Upload statement.
7. When you are satisfied that the SQL statement is correct, click Save SQL on the SQL tab to save the statement. Or, when you are satisfied that the File Upload statement is correct, click Save statement on the File tab to save the statement. Once saved, the SQL or File Upload statement appears as an entry on the appropriate Database On-Demand tab for later use.

If you have Java 2-enabled browsers, you must press and hold the Ctrl key while selecting multiple table names.

Opening an existing SQL or File Upload statement

You can view and edit the options used to create an existing SQL or File Upload statement. This allows you to make changes to commands without reconstructing them each time. For example, if you are running an SQL statement that pulls all the payment records received for the current month, you might want to change the month options in the SQL statement at the beginning of each month. If you open and edit your existing SQL statement, you do not have to build a new SQL statement each month.

To open an existing SQL or File Upload statement:

1. Click the icon for the SQL or File Upload statement that you want to open.
2. Click Open.
3. The logon tab displays. If necessary, fill in the required information and click Connect.
4. Once you are connected, a series of new tabs appears at the top of the Logon tab. These tabs contain either your original SQL statements; or your original File Upload statements. You can change the supplied information, execute the new SQL and save the results, or run the new File Upload statement.

Running an existing SQL or File Upload statement

To run an existing SQL or File Upload statement:

1. Click the icon for the SQL or File Upload statement you want to execute.
2. Click Run.
3. Enter your ID and password (if they were not saved with the selected SQL or File Upload statement). Type the information and click Connect. If you saved the ID and password with this SQL or File Upload statement, skip the next step.
4. Either your SQL statement results are displayed or sent to a file (see Output tab for more information); or you File Upload statement uploads the file to the host database.

After running the SQL or File Upload statement, you can modify it by changing one or more of the options on the various tabs. Click Run SQL on the SQL tab to rerun the SQL statement, or click Run statement on the File tab to rerun the File Upload statement.

Deleting an existing SQL or File Upload statement

You may need to remove SQL or File Upload statements that have been previously saved. You can delete an existing SQL or File Upload statement but remember that once statements are deleted they cannot be recovered; you must build a new statement.

To delete an existing SQL or File Upload statement:

1. Click the icon for the SQL or File Upload statement you want to delete.
2. Click Delete.
3. Click OK.

You must log on as an administrator to delete statements at the Group level.

Related topics