Filter
Top Products
8.1.9 DL/I Multiple Partition Support
Conversion to IMS/ESA BMPs (Batch Message Processing programs) running
under DBCTL should be considered as an alternative to CICS/OS Shared Data
Base or IMS/ESA Data Sharing support.
8.1.10 Additional Information
A recently announced Redbook,
Interoperability between VSE DL/I and OS/390
IMS DBCTL
, SG24-5249, can provide additional conversion information.
8.2 SQL/DS to DB2 for OS/390 Migration Consideration
Note: Although the formal name of the SQL/DS product has changed to DB2 for
VSE, this document will use the name SQL/DS. This document will also use the
term ′DB2′ to mean the full product name - ′DB2 for OS/390′.
8.2.1 Descriptions of Users
The differences and thus the migration considerations between SQL/DS and DB2
take on meaning only as they pertain to, or are perceived by, the users of the
products. In order to discuss this, we need to define who these users are. The
type of users we want to address are:
•
End Users
•
Application Developers
•
Data Base Administrators (DBAs)
•
System Administrators
•
Security Administrators
It is important to point out at this time that the following is not meant to provide
an exhaustive list of differences between the two products. Instead, it is intended
to point out the most likely areas of difference you will encounter to give a
feeling for how significant or insignificant these differences may be. An
exhaustive treatment and explanation of the differences in the VSE and OS/390
platforms is given in the
IBM SQL Reference
, SC26-8416. This can be ordered
through standard IBM document ordering procedures.
As we will see later, the area of most concern is with the language of both
products - the Structured Query Language or SQL. SQL has the three following
′flavors′:
1. Data Manipulation Language (DML) that is used by End Users and
Applications Developers
2. Data Definition Language (DDL) that is used by DBAs and Systems
Administrators
3. Data Control Language (DCL) that is used by Security Administrators.
8.2.1.1 End Users
From the standpoint of end users, for DML, there are very few differences
between SQL in the two products. DML is what most end users use - the
issuance of SELECT, UPDATE, INSERT and DELETE statements to do work
against a database. End users rarely have a need to know or use DDL or DCL.
As we will see later, the latter two SQL ′flavors′ are used mostly by DBAs,
178 VSE to OS/390 Migration Workbook