Testing the MAS driver connections

jDemo is a Windows user interface provided with the MAS connector. This interface is used to access data structures. The following sections describe how to use jDemo:

An overview of jDemo

jDemo was installed onto your computer during the MAS installation (see Installing and configuring the connector). By default, it is stored in the Systems folder, located on your C:\ drive as follows:

IBM Shadow Client\Shadow\Bin32\jDemo32.exe

With jDemo, you can use Microsoft(TM) Access, Microsoft Excel, Crystal Reports, and many other tools to access DB2, IMS, CICS, and ADABAS data. You can also use standard SQL statement calls to access data from IMS, ADABAS, and VSAM.

You can also use jDemo to verify installation of the Shadow Direct Interfaces for ADABAS, DB2, IMS, CICS, and VSAM.

Planning considerations

Before you begin, ensure that the following actions have been completed:

Administering jDemo

Starting jDemo

To run jDemo, perform the following steps:

  1. Open the Start Menu and select Programs/Neon Systems/jDemo 32-bi application.

    The system will display the jDemo window.

  2. From the Connections menu, select Add New Connection.
    Note:
    You can have more than one connection open at the same time.
  3. Type the correct connection name in the text box.
  4. Click OK. The system will display the User Authentication dialog box.
  5. Enter your mainframe userid in the Userid field, and enter your mainframe password in the Password field.
  6. Click OK. The system issues a message indicating that the connection was established.
  7. Click OK to return to the jDemo window.

Making SQL requests

Perform the following steps to make an SQL request:

  1. Enter one of the following statements, depending on the type of data you are accessing:

    For DB2-OS/390:

    select * from q.staff
    

    Note:
    If you select the Tables button, only the tables defined in the table filter are shown. The table filter was defined during data source configuration (see "Configuring the JDBC driver"). If you did not define a table filter, the system will display only those tables that you own or that you created under your user id.

    For ADABAS:

    ('select first_name birth sex from employees where last_name = "jones"')

    For CICS:

    CALL CICSEX.NESPSEL
    

    For IMS:

    IMS/TM statements use the following syntax:

    call ims.imssp('','','','s','Sobieski', 'Henry','F','','','','','','','')
    

    A record will be retrieved by specifying the first name, last name and middle initial in parm 5 (D05751), parm 6 (D05757), and parm 7 (D05752). Note that parm 4 (REVFLD) is populated with an 's'.

    The resultset will look like this:

              ADDFLD                     CHGFLD                    REMFLD
    

    REVFLD          D05751                 D05757              D05752
    

    D05754          D05755                 D05756              D15333  
    

    D15334          D07786                           F00028
    

    SOBIESKI        HENRY                  F          FAIRFAX           VA           
    

            IBM    TEST          SDBB000          0SDBB00001246581
    

    ITINERARY RETRIEVED
    
  2. ClickQuery. The system displays the following information, depending on the type of data you requested.

Closing jDemo

To close jDemo, perform the following steps

  1. To exit the jDemo program, click Disconnect. The system will display a message indicating that the connection was closed.
  2. Close the jDemo window.

Copyright IBM Corp. 1997, 2004