Getting started with Database On-Demand

The Database On-Demand client allows you to use the SQL Wizard and the File Upload Wizard to build and run SQL statements and File Upload statements.

As an alternative, you can build and run SQL statements and File Upload statements from a 3270 Display session, a 5250 Display session, or a VT Display session. You can also access the SQL Wizard and the File Upload Wizard from these sessions. See Overview of database access.

To open the Database On-Demand client desktop window:

1. Use a supported Web browser to load one of the predefined HTML files for the Database On-Demand client:
   • database.html is the predefined HTML file for the download client.
2. When the Database On-Demand Logon window appears, type your user ID and password and then click Logon.

   If you are loading the Database On-Demand client on a UNIX operating system, and you cannot see the logon text as you type it in, try changing the color of the desktop: Start the application Desktop Style from the toolbar. Start the application Colors and select a different color setting.

The Database On-Demand client desktop window has two tabs:

• SQL Wizard

  The SQL Wizard tab brings the SQL Wizard folder to the top of the Database On-Demand client desktop window. The folder contains a tree that displays the names of the SQL statements that are stored in the current session.

  You can:

  • Open an existing SQL statement.
  • Run an existing SQL statement.
  • Create a new SQL statement (if enabled).
  • Delete an existing SQL statement (if enabled).

• File Upload Wizard

  The File Upload Wizard tab brings the File Upload Wizard folder to the top of the Database On-Demand client desktop window. The folder contains a tree that displays the names of the File Upload statements that are stored in the current session.

  You can:

  • Open an existing File Upload statement.
  • Run an existing File Upload statement.
  • Create a new File Upload statement (if enabled).
  • Delete an existing File Upload statement (if enabled).

The remainder of this help file contains the following sections:

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 Database On-Demand client launches the SQL Wizard or the File Upload Wizard with the Start tab or Logon tab selected.
2. Fill out the Start tab (if present) and the Logon tab (see SQL Wizard (Java 1 browsers), SQL Wizard (Java 2-enabled browsers), and File Upload Wizard).
3. On the Logon tab, click Connect to connect to the database.
4. 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 (see SQL Wizard (Java 1 browsers), SQL Wizard (Java 2-enabled browsers), and File Upload Wizard).

5. When you are satisfied that the SQL statement or File Upload statement is correct, save the SQL statement or File Upload statement:
   1. To save an SQL statement:
      • For Java 1 browsers:
        
        • Click Save on the SQL tab; or
        • Click Save SQL on the Results tab;
      • For Java 2-enabled browsers:
        
        • Click Save on the Review tab; or
        • Click Save SQL on the Results tab;
   2. To save a File upload statement:
      • For Java 1 browsers and Java 2-enabled browsers:
        
        • Click Save Statement on the File tab.
   Once saved, the SQL or File Upload statement appears as an entry on the appropriate Database On-Demand tab for later use.

If you are using Java 2-enabled browser, 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. Select the SQL statement or File Upload statement that you want to open.
2. Click Open. The Database On-Demand client launches the SQL Wizard or the File Upload Wizard with the Start tab or Logon tab selected.
3. On the Logon tab, fill in the required information, if any, then click Connect to connect to the remote database server.
4. The logon tab is displayed. If necessary, fill in the required information and click Connect.
5. Once you are connected, a series of new tabs appears after the Logon tab. These tabs contain either your original SQL statements or your original File Upload statements. You can modify the existing statements, run the new SQL statement 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. Select the SQL statement or File Upload statement that you want to run.
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. If you are running an SQL statement, the SQL Wizard displays the results on the Results tab or sends the results to a file (see Output (SQL Wizard)). If you are running a File Upload statement, the File Upload Wizard uploads the file to the remote database server.

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

Deleting an existing SQL or File Upload statement

You may need to remove SQL statements or File Upload statements that have been previously saved. You can delete an existing SQL or File Upload statement. However, remember that when you delete a statement you cannot recover it. You must build a new statement.

To delete an existing SQL or File Upload statement:

1. Select 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