home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
ODBC with Perl

Intended for

Application developers, technical analysts and database administrators who are going to use Perl scripts

Background

Programming experience in Perl and basic SQL knowledge (see courses Perl programming: fundamentals course and SQL fundamentals).

Knowledge of object oriented concepts is an advantage but not necessary.

Training method

Classroom instruction, theory with exercises using existing IBM DB2 or Oracle data bases.

Course leader

Peter Vanroose.

Duration

1 day.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

Perl is popular due to its stability, its free availability on nearly each platform, and its facility to write scripts in order to computorize complex tasks.

Besides there is a wide range of extension modules that facilitate the writing of more specific Perl applications by means of an object oriented interface.

One of these modules is DBI, the standard database interface of Perl, that allows relational databases to communicate in a consistent way, independent of the applied database system..

Main topics

  • Overview of DBI:
  • Possibilities and restrictions of DBI.
  • Advantages of Perl
  • Link with ODBC and with SQL/CLI
  • Use of DBI: basics
  • Connection with a data base
  • Set-up and execution of a SQL select statement
  • Result processing: multiple rows
  • More SQL: insert/update/delete
  • The optimal application of Perl-data structures for DBI.
  • More DBI:
  • The use of host-variables
  • Cursors
  • The database-catalog
  • Advanced topics: transactions - locking - performance
  • DBI extensions