Presentation materials from the September 2003 UNITE Conference in Reno, Nevada.
Click on a link to view or download the slides, notes, or sample files.
Using OLE DB (MCP-4024)
Object Linking and Embedding for Data Bases (OLE DB) is one of the
newer enablers for open access to data managed by the MCP Enterprise
Database Server (DMSII) facility. OLE DB is a Microsoft technology
implemented by Unisys for the ClearPath MCP. It provides a powerful
and efficient mechanism for inquiry and update of data bases in the
MCP environment from external client systems, particularly Microsoft
The speaker will discuss the capabilities and features of the OLE DB Provider for DMSII, compare OLE DB capabilities to those of ODBC, briefly review installation and configuration of the software, highlight special considerations in dealing with DMSII data structures, and describe how the OLE DB Provider can be invoked from a variety of external environments, including ADO for Visual Basic and VBScript, Microsoft SQL Server, Microsoft Office, the Java Data Base Connector (JDBC), and the new XML Provider for MCP systems.
|Slides & Notes||Presentation slides and notes in Adobe Acrobat .PDF (198K)|
|Slides, Notes, & Examples||Presentation slides and notes in Adobe Acrobat .PDF, along with numerous examples using ADO and VBScript. All contained in a single ZIP archive file. (291K)|
Physical File Design for DMSII Databases (MCP-4025)
The DASDL schema compiler automatically calculates physical file
attributes (record size, block size, area size, etc.) for each
structure in an Enterprise Database Server (DMSII) data base. These
defaults are sometimes acceptable, but almost never optimal.
Specifying values for selected attributes can often have a major
impact on the performance and resource consumption of DMSII data
The speaker will describe the physical file formats for the most common DMSII structures -- Standard fixed-format data sets, Standard variable-format data sets, Random data sets, and Index Sequential sets. He will describe how attributes specified in DASDL can affect the physical layout of these types of structures, discuss some of the design trade-offs involved, illustrate the concepts with sample cases, and present a spreadsheet tool that aids in performing the necessary design calculations.
|Slides & Notes||Presentation slides and notes in Adobe Acrobat .PDF (158K)|
|Slides, Notes, & Spreadsheet||Presentation slides and notes in Adobe Acrobat .PDF, along with the file design spreadsheet mentioned in the presentation. All contained in a single ZIP archive file. (150K)|
|Paradigm Home||Back to Resources||
Copyright and Site Access Notices
Revised 7 October 2005