DB2 UDB for iSeries distributed relational database example program

DB2 UDB for iSeries distributed relational database example program

A remote unit of work relational database example program is included with the SQL product. Several files and members within the QSQL library can help you set up an environment that runs a distributed DB2^® UDB for iSeries™ example program.
To use these files and members, run the SETUP batch job located in the file QSQL/QSQSAMP. The SETUP batch job allows you to customize the example to do the following:

Create the QSQSAMP library at the local and remote locations.

Set up relational database directory entries at the local and remote locations.

Create application panels at the local location.

Precompile, compile, and run programs to create distributed example application schemas, tables, indexes, and views.

Load data into the tables at the local and remote locations.

Precompile and compile programs.

Create SQL packages at the remote location for the application programs.

Precompile, compile, and run the program to update the location column in the department table.

Before running the SETUP, you may need to edit the SETUP member of the QSQL/QSQSAMP file. Instructions are included in the member as comments. To run the SETUP, specify the following command on the system command line:
 
========> SBMDBJOB QSQL/QSQSAMP SETUP  
Wait for the batch job to complete.
To use the example program, specify the following command on the command line:
========> ADDLIBLE QSQSAMP  
To call the first display that allows you to customize the example program, specify the following command on the command line.
========> CALL QSQ8HC3
 
The following display opens. From this display, you can customize your database example program.
DB2 for OS/400 ORGANIZATION APPLICATION  
 
ACTION...........:   _      A  (ADD)                  E (ERASE)
D  (DISPLAY)              U (UPDATE)
 
OBJECT...........:   __     DE (DEPARTMENT)           EM (EMPLOYEE)
DS (DEPT STRUCTURE)
 
SEARCH CRITERIA..:   __     DI (DEPARTMENT ID)     MN (MANAGER NAME)
DN (DEPARTMENT NAME)   EI (EMPLOYEE ID)
MI (MANAGER ID)        EN (EMPLOYEE NAME)
 
LOCATION.........:   ________________  (BLANK IMPLIES LOCAL LOCATION)
 
DATA.............:   _______________________________
 
 
 
 
                                                            Bottom  
F3=Exit                                      (C) COPYRIGHT IBM CORP. 1982, 1991
Parent topic:
Distributed relational database function and SQL