******************************************************************************
* (c) Copyright IBM Corp. 2007 All rights reserved.
*
* The following sample of source code ("Sample") is owned by International
* Business Machines Corporation or one of its subsidiaries ("IBM") and is
* copyrighted and licensed, not sold. You may use, copy, modify, and
* distribute the Sample in any form without payment to IBM, for the purpose of
* assisting you in the development of your applications.
*
* The Sample code is provided to you on an "AS IS" basis, without warranty of
* any kind. IBM HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR
* IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
* MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions do
* not allow for the exclusion or limitation of implied warranties, so the above
* limitations or exclusions may not apply to you. IBM shall not be liable for
* any damages you suffer as a result of using, copying, modifying or
* distributing the Sample, even if IBM has been advised of the possibility of
* such damages.
*
******************************************************************************
*
* README for Perl Samples
*
* The <install path>sqllib\samples\perl directory contains this README file
* where <install_path> is the location of DB2 9.7 on your hard drive. The
* default location for <install_path> is C:\Program Files\IBM on Windows and
* $HOME on unix
*
* This README describes how to run Perl sample code for DB2 9.7.
* The DB2 9.7 sample code and build files for Perl are located
* in the following directory:
*
* Windows:
* <install_path>\sqllib\samples\perl
* Unix:
* <install_path>/sqllib/samples/perl
*
* Copy the sample files from this directory to a working directory prior to
* running the sample programs. The sample program directories are typically
* read-only on most platforms and some samples produce output files that
* require write perimssions on the directory.
*
* WARNING: Some of these samples may change your database or database manager
* configuration. Execute the samples against a test database
* only, such as the DB2 SAMPLE database.
*
******************************************************************************
*
* Prepare your DB2 sample development environment
*
* On Windows all samples should be run and built in a DB2 Command Window.
* The DB2 Command Window is needed to execute the db2 specific commands.
* Listed below is how to opening the DB2 Command Window:
*
* o From the Start Menu click Start --> Programs --> IBM DB2 -->
* <DB2 copy name> --> Command Line Tools --> Command Window
*
* 1) Copy the files in <install path>sqllib\samples\perl\* (windows),
* <install path>sqllib/samples/perl/* (unix) to a working directory and
* ensure that directory has write permission.
*
* 2) Start the Database Manager with the following command:
* db2start
*
* 3) Create the sample database with the following command:
* db2sampl
*
* 5) Test that you can connect to the database with the following command:
* db2 connect to sample
*
* 6) cd to the directory containing the files copied in Step 1.
*
******************************************************************************
*
* Common file Descriptions
*
* The following are the common files for Perl samples. For more
* information on these files, refer to the program source files.
*
*******************************************************************************
*
* Common files
*
* README - this file!
*
******************************************************************************
*
* Script files
*
* tbselinit.bat (Windows)
* tbselinit (UNIX) - A script file used to set up some databases for
* tbsel.pl
*
******************************************************************************
*
* Common Utility Perl Module
*
* DB2SampUtil.pm - Defines common functions like command line argument
* checking. Also, functions to prepare and execute an SQL
* statement, and roll back if an error occurs.
*
* DB2WlmHist.pm - Defines common functions like prepare and execute SQL
* statements and roll back if an error occurs that will be
* used for the WLM Historical Generator and the WLM
* Historical Reports tools.
*
******************************************************************************
*
* Perl Samples Design
*
* The Perl sample programs form an object-based design reflecting the
* component nature of DB2. Related samples demonstrate a specific level of
* database programming. Each level is identified by the first two characters
* of the sample name. Here are the database levels represented by the
* samples:
*
* Identifier DB2 Level
*
* db Database Level.
* tb Table Level.
* dt Data Type Level.
* sp Stored Procedure client program.
*
******************************************************************************
*
* Perl Sample Descriptions
*
* The following are the Perl sample files included with DB2.
* For more information on the sample programs, refer to the program source
* files.
*
******************************************************************************
*
* Database Level
*
* dbauth.pl - How to grant/display/revoke authorities at database level.
* dbuse.pl - How to use database objects.
*
******************************************************************************
*
* Table Level
*
* tbconstr.pl - How to work with table constraints.
* tbinfo.pl - How to get and set information at a table level.
* tbpriv.pl - How to grant/display/revoke privileges at a table level.
* tbsel.pl - How to select from each of: insert, update, delete.
* Please run 'tbselinit.bat' (on Windows) or
* 'tbselinit' (on UNIX) prior to running this sample.
* Refer to the sample header for detailed instructions.
* tbselcreate.db2 - How to create the tables for the tbsel program.
* tbseldrop.db2 - How to drop the tables for the tbsel program.
* tbtrig.pl - How to use a trigger on a table.
* tbuse.pl - How to manipulate table data.
*
******************************************************************************
*
* Data Type Level
*
* dtlob.pl - How to read and write LOB data.
*
******************************************************************************
*
* Stored Procedure Level
*
* spclient.pl - Client application that calls the stored procedures in
* the spserver or SpServer shared library (which must be
* built in another supported language).
*
******************************************************************************
*
* WLM Historical Analysis sample tool
*
* wlmhist.pl - Generates historical data for activities that are captured
* in the event_activity and event_activitystmt logical data
* groups. The data that is generated is put into the
* wlmhist table. This table will be created if it does not
* already exist.
* wlmhistrep.pl - Generates historical analysis reports based on user input
* and input from the wlmhist table.
******************************************************************************