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:
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.
Before you begin, ensure that the following actions have been completed:
To run jDemo, perform the following steps:
The system will display the jDemo window.
Perform the following steps to make an SQL request:
For DB2-OS/390:
select * from q.staff
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
To close jDemo, perform the following steps