DB2 Server for VSE & VM: Application Programming
The DB2 Server for VSE & VM product is a database
management system that uses the relational data model. You can think of
a relational data model as a collection of ordinary two-dimensional tables,
where each table has a specific number of columns, unordered rows, and a
specific item of data at the intersection of every column and row. You
access data by performing operations on tables. All you need to know
are the names of tables and of the columns that contain the desired
data.
The sample tables in Appendix G of the DB2 Server for
VSE & VM SQL Reference manual are used in examples throughout this manual. In Figure 3, the DEPARTMENT table has columns DEPTNO, DEPTNAME, MGRNO,
and ADMRDEPT.
Figure 3. DEPARTMENT Table Contents
| DEPTNO
| DEPTNAME
| MGRNO
| ADMRDEPT
|
| A00
| SPIFFY COMPUTER SERVICE DIV.
| 000010
| A00
|
| B01
| PLANNING
| 000020
| A00
|
| C01
| INFORMATION CENTER
| 000030
| A00
|
| D01
| DEVELOPMENT CENTER
| ?
| A00
|
| D11
| MANUFACTURING SYSTEMS
| 000060
| D01
|
| D21
| ADMINISTRATION SYSTEMS
| 000070
| D01
|
| E01
| SUPPORT SERVICES
| 000050
| A00
|
| E11
| OPERATIONS
| 000090
| E01
|
| E21
| SOFTWARE SUPPORT
| 000100
| E01
|
Suppose, for example, you want a list of all the different departments
(DEPTNAME) in your company. You could get this information simply by
knowing the name of the table DEPARTMENT and of the column DEPTNAME that the
data is in, and coding this in an appropriate SQL statement.
| DB2 Server for VSE |
|---|
|
You can use the database management system under any supported Virtual
Storage Extended (VSE) operating system. Application programs running
under VSE can be:
- Online programs operating in CICS partitions, controlled by the Customer
Information Control System/Virtual Storage Extended (CICS/VSE)
- Batch programs operating in interactive partitions controlled by the IBM
Interactive Communications and Control Facility (ICCF).
- Pure batch programs.
Under the VSE operating system, you can write batch or online
programs to access one or more DB2 Server for VSE application servers, or
application servers using VSE Guest Sharing. In addition, you can write
online programs to access one or more DB2 family application servers using
DRDA Remote Unit of Work (RUOW). The application server is the facility
that receives and processes requests to access data.
Access to multiple application servers is not available for CICS
application programs; however, CICS programs running in different CICS
partitions can access different application servers. |
| DB2 Server for VM |
|---|
|
You can use the DB2 Server for VM database management system under any
supported Virtual Machine (VM) operating system. Application programs
running under VM can be:
- Online programs that operate in virtual machines and are controlled by the
conversational monitor system (CMS).
- Noninteractive programs that operate in virtual machines in VM.
You can also write distributed applications that can access multiple
application servers, as well as application servers other than DB2 Server for
VSE & VM such as DB2 for MVS. The DB2 Server for VM application
server is the facility that receives and processes requests to access
data.
For a discussion of terms and concepts, such as application server, that
are used throughout this manual, refer to the DB2 Server
for VSE & VM Overview, the DB2 Server for VSE & VM SQL Reference, and the DRDA: Every Manager's Guide manuals. |
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]