Example 4-38 Verifying deployed Python application

$ cd /home/python_dep/py_app/bin

$python itso_pyapp.py mensa 50001 test db2inst1 password Trying to establish connection...

Is connection active? : True Closing connection...

Connection closed.

4.6.7Help and support

You can seek assistance related to IBM_DB, IBM_DB_DBI, or IBM_DB_SA from following forum

http://groups.google.com/group/ibm_db

4.7 Perl

Perl stands for Practical Extraction and Report Language. It is an interpreted language optimized for scanning text files and extracting information from these text files. It is influenced by a variety of languages such as AWK, C, Lisp, and shell scripts. It supports different programming paradigms such as procedural, object-oriented, and functional. There is also a large collection of third party modules, which makes Perl even more useful. Because of these reasons, Perl is widely used in system administration, network programming, as well as Web development along with text manipulation.

Perl has the ability to access a wide variety of databases through DBI (Database interface module). DBI defines a set of methods and conventions that you can use independent of the database being used. IBM Perl driver conforms to this DBI specification. This driver is an open source.

4.7.1 DBD::DB2

DBD::DB2 is the IBM provided database driver module that implements DBI for accessing IBM DB2 databases. It is supported on Perl version 5.6 and greater. You can use this driver to connect to IBM DB2 version 8.2 and greater and all DB2 supported operating system platforms. You can use features of DB2 such as issue SQL queries, call stored procedures, and work with large objects.

Chapter 4. Deploying applications with DB2 199

Page 213
Image 213
IBM manual Perl, DBDDB2, Example 4-38 Verifying deployed Python application