Perl DBI Scripting for ALEPH

Abstract

Christine Moulen, Library Systems Manager, MIT; John Osborn, Manager, Library Systems Support, University of Iowa.

This presentation topic was requested during the Systems SIG session at last year's meeting. The Perl DBI module can be used to incorporate database queries into Perl scripts, eliminating the need for separate SQL scripts or learning SQL formatting commands. This will be a technical session, geared toward ALEPH system managers, though possibly applicable to other products. The presentation will cover some installation tips for the DBI and DBD:Oracle Perl modules (or do you use the one Ex Libris provides?), how to incorporate this module into your scripts, and some use cases at the presenters' home institutions. A basic sample script will be provided.