Paradigm Corporation

2017 UNITE Conference

Presentation materials from the November 2017 UNITE Conference in Atlanta, Georgia.

 

Get a GREP: Regular Expressions for the MCP

Abstract Regular expressions are a powerful pattern-matching mechanism that first came to prominence in the classic Unix utility "grep." They are essentially wildcard patterns on steroids. Regular expressions are frequently incorporated into file system tools and text editors for Windows, Unix, and Linux systems. Since MCP 13, an API for Perl Compatible Regular Expressions (PCRE) has been available in the MCP's WEBAPPSUPPORT library.

The speaker will present the components of the MCP regular expression API and describe how they can be used within MCP applications to search for simple and complex character patterns in strings and files. The speaker will also present a home-grown library for MCP directory searching, and together with the regular expression API, demonstrate a utility program that does basic grep-like searching across a directory of MCP files.

Presenter Paul Kimpel
Slides Presentation slides as Adobe Acrobat .PDF (95KB)
Resources The source and example files for the presentation, all contained in a single ZIP archive file. (56KB)
 

Using the New MCPSQL

Abstract The DMSQL relational interface for DMSII data bases has been available for more than a dozen years. A rewrite of DMSQL, named MCPSQL, has been available since 2014 as a separately licensed product. Starting in MCP 18, however, Unisys has bundled MCPSQL and deprecated the older DMSQL in favor of it. MCPSQL includes a replacement for the DMSQL JDBC driver, plus a new ODBC driver.

The speaker will present an overview of the new MCPSQL interface to DMSII. The session will cover MCPSQL features, differences from DMSQL, installation and configuration of MCPSQL and its ODBC driver, demonstrations the MCPSQL tools and APIs, and a brief review of performance differences between DMSQL and MCPSQL. The JDBC driver and ability to define a true relational data base using SQL DDL will not be covered in this presentation.

Presenter Paul Kimpel
Slides Presentation slides as Adobe Acrobat .PDF (69KB)
Resources The source and example files for the presentation, all contained in a single ZIP archive file. (56KB) FORTHCOMING

 


Paradigm Home Back to Resources Copyright and Site Access Notices
Revised 10 November 2017