SoftWoehr QCDemo User Manual

Version 1.1

Copyright 2000, Jack J. Woehr
P.O. Box 51, Golden, Colorado 80402-0051

Table of Contents

DISCLAIMER

USE AT YOUR OWN RISK. THERE IS NO GUARANTEE OR WARANTEE FOR THIS FREE SOFTWARE. QCDemo can modify files and settings on any AS/400 to which it is connected. To the best of our belief, it performs exactly what you direct it to do, which is dangerous enough, isn't it? Other slightly dangerous aspects of JTOpen itself include the following:

System Requirements

To run QCDemo you need the following which are not provided with QCDemo:

Launching QCDemo

Make sure the following are in your classpath, or add them via the -classpath argument to the Java environment: The main class of the QCDemo jar file is
com.SoftWoehr.JTOpenContrib.QCDemo.QCDemo
Enter a command appropriate to your installation to run the main class of the QCDemo jar file, such as
java com.SoftWoehr.JTOpenContrib.QCDemo.QCDemo

General Considerations

QCDemo opens a window with a tabbed notebook in it. Each tab demonstrates one or more beans from the JTOpen project and offers access to different resources. The tabs should be self-explanatory. Use the widgets which the tab pane presents to operate on your AS/400, or flip to another tab to perform a different task. Please remember when you are connected to your AS/400 that any changes you make using QCDemo are real!

Each tab pane allows you to make a connection to an AS/400 independently of the other tab panes. Thus, all the tab panes can be connected to the same AS/400 or to different AS/400s. You can change the connection of any page. Connections are managed centrally so that resources are used economically. There is a tab pane for seeing the managed connections; its tab says "Connection Manager".

Help for using QCDemo is provided by this document and by flyover text which pops up over different fields and buttons if you leave the mouse pointer sitting over these fields and buttons for a few seconds.

Much of the data returned by JT400 components is in the form of graphic objects having their own popup menus. Try right-clicking on graphic objects returned in the windows of QCDemo; often more information can be returned and operations performed on the target AS400 in this fashion.

The Individual Tabs

There are currently ten (10) tabs to the QCDemo notebook. They are described and illustrated below in their notebook order.

The Command Tab

The Command Tab illustrates JTOpen's AS400CommandButto and allows you to execute a non-interactive command on the AS/400. You are informed of completion of the command and any error messages are returned.
  1. Enter the name of the server.
  2. Press the Set System button.
  3. Enter the command and press enter.
  4. The command button is now set to the command and its legend changes.
  5. Press the button to execute the command.
  6. Wait for the completion message before continuing.
Below, the execution of a successful command is illustrated.

QCDemo Command Tab

Below, the execution of an unsuccessful command is illustrated.

QCDemo Command Tab after a bad command

The IFS Tab

The IFS Tab allows you to navigate the file system. Clicking on graphic objects returned frequently returns more information. Please note that while your author has set the hourglass "wait" cursor for the original load of the IFS data, the returned graphic components don't do the same. Therefore, if you click on an object and the window seems to lock up, it's just the component fetching more data.
  1. Enter the system name
  2. Press the Set System button.
  3. Enter the IFS path you wish to explore.
  4. Press the Set IFS Path button.
You may also switch views between views by using the clearly labeled buttons provided for this purpose.

Below, a session with the IFS Tab in an explorer view is illustrated.

The User List Tab

The User List Tab returns a list of those users whose profiles you are authorized to access on the server of your choice.
  1. Enter the system name.
  2. Press the Get User List button.
Below, a session with the User List Tab is illustrated.

QCDemo User List Tab

The Job List Tab

The Job List Tab returns a list of active jobs you are authorized to access on the server of your choice.
  1. Enter the system name.
  2. Enter the selection criteria or *ALL.
  3. Press the Get User List button.
NOTE that if you ask for jobs you aren't authorized to see, you may receive many, many error dialog popups, one after another, one or two for each job!

Below, a session with the Job List Tab is illustrated.

QCDemo Job List Panel

The Printer List Tab

The Printer List Tab returns a list of printers and documents on the server of your choice.
  1. Enter the system name.
  2. Enter the selection criteria or *ALL.
  3. Press the Get Printer List button.
NOTE that this panel may come up with the separator bar all the way over to the left hiding the printer list. Just grab the bar with the mouse and slide it to the right. (See Bugs.)

Click on a printer to see its documents.

Below, a session with the Printer List Tab is illustrated.

QCDemo Printer List Panel

The Spooled File Viewer Tab

The Spooled File Viewer Tab returns a printable WYSIWYG view of spooled files on the server of your choice.
  1. Enter the system name.
  2. Enter the spooled file name.
  3. Enter the spooled file number
  4. Enter the job name which produced the spooled file.
  5. Enter the user name which produced the spooled file.
  6. Enter the job number which produced the spooled file.
  7. Press the View Spool File button.
NOTE that since graphic data is transferred in this operation it may take a bit of time.

Below, a session with the Spooled File Viewer Tab is illustrated.

QCDemo Spooled File Viewer Tab

The SQL Query Builder Tab

The SQL Query Builder Tab presents a JTOpen SQL Query Builder pane. You can create SQL queries and execute them, sending the results to either the SQL Result Table Tab or the SQL Result Form Tab.
  1. Choose a driver from the radio buttons offered. The URL will then be partially filled in by QCDemo.
  2. Finish the partial URL by adding the server name and any other JDBC URL information such as
  3. Press the Connect Now button.
  4. If you connect successfully, you are now ready to formulate queries.
  5. When you wish to execute the query, press either Do Query button depending on which Result Tab you wish the results of your query to go to.
  6. Flip to the Result Tab of your choice to see the results of your query.
Below, a session with SQL Query Builder Tab is illustrated.

QCDemo SQL Query Builder Tab

See also the SQL Result Table Tab and SQL Result Form Tab.

The SQL Result Table Tab

The SQL Result Table Tab shows the results of using the SQL Query Builder Tab in a table, as illustrated below.

QCDemo SQL Query Result Table Tab

The SQL Result Form Tab

The SQL Result Table Tab shows the results of using the SQL Query Builder Tab in a form, as illustrated below.

QCDemo SQL Result Form Tab

The DataQueue Browser Tab

The DataQueue Browser Tab allows you to write, read (destructively) and peek (read non-destructively the first message) an OS/400 data queue object of the OS/400 type *DTAQ. In the illustration below, all three operations are directed at the same data queue, but they each could be different data queues on the same or different servers.

To use the DataQueue Browser, for any or each enter the server, library and queue name. Then, for the read operation, click the "Read" button. For a peek operation, that is, a read of the first messsage in the queue, click the "Peek" button. To write a text message to the queue, enter the message next to the "Write" button, then either press Enter on the keyboard or click the "Write" button.

The Connection Manager Tab

The Connection Manager Tab shows the QCDemo simple connection manager's current status. This view does not update itself. You must push the Refresh button to update the view.

The display of the Connection Manager Tab is illustrated below.

QCDemo Connection Manager Tab

There is more information about the Connection Manager in the QCDemo Programmer Manual.

Bugs



Fairmount, Colorado
December 5, 2000