#!/usr/bin/perl -w
use strict;
use warnings;
use DBI;

my $dir = '.';
my $eol = "\n";
my $sep = ',';

my $dbh_match = DBI->connect (
    "DBI:CSV:",
    undef, undef,
    {
        f_dir        => $dir,
        f_ext        => ".csv/r",
        csv_eol      => $eol,
        csv_sep_char => $sep,
        RaiseError   => 1,
        PrintError   => 1,
    }
) or die "Cannot connect: " . $DBI::errstr;

my $sth_match = $dbh_match->prepare (
    qq|
        CREATE TABLE new AS SELECT file_01.Prefix, file_01.NumberRange, 
		file_02.Termination, file_02.Service, file_02.ChargeBand
        FROM file_01 INNER JOIN file_02
        ON file_01.Chargeband = file_02.ChargeBand
        WHERE file_02.Termination LIKE '%something%'
      |
);
$sth_match->execute or die "Cannot execute: " . $sth_match->errstr ();

DBI->trace (1);

$dbh_match->disconnect;

##</code><code>##

DBD::CSV::st execute failed: You passed 0 parameters where 1 required [for State
ment "
        CREATE TABLE new AS SELECT file_01.Prefix, file_01.NumberRange,
                file_02.Termination, file_02.Service, file_02.ChargeBand
        FROM file_01 INNER JOIN file_02
        ON file_01.Chargeband = file_02.ChargeBand
        WHERE file_02.Termination LIKE '%something%'
      "] at test_DBI__CSV_read_for_PM.pl line 32.
DBD::CSV::st execute failed: You passed 0 parameters where 1 required [for State
ment "
        CREATE TABLE new AS SELECT file_01.Prefix, file_01.NumberRange,
                file_02.Termination, file_02.Service, file_02.ChargeBand
        FROM file_01 INNER JOIN file_02
        ON file_01.Chargeband = file_02.ChargeBand
        WHERE file_02.Termination LIKE '%something%'
      "] at test_DBI__CSV_read_for_PM.pl line 32.

##</code><code>##

Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
  Platform:
    osname=MSWin32, osvers=5.1, archname=MSWin32-x86-multi-thread
    uname=''
    config_args='undef'
    hint=recommended, useposix=true, d_sigaction=undef
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
    use64bitint=undef, use64bitall=undef, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc', ccflags =' -s -O2 -DWIN32 -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTE
XT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX',
    optimize='-s -O2',
    cppflags='-DWIN32'
    ccversion='', gccversion='3.4.5', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='long long', lseek
size=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='g++', ldflags ='-s -L"C:\strawberry\perl\lib\CORE" -L"C:\strawberry\c\li
b"'
    libpth=C:\strawberry\c\lib
    libs= -lmsvcrt -lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32
-ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lwinmm
 -lversion -lodbc32 -lodbccp32
    perllibs= -lmsvcrt -lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdl
g32 -ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lw
inmm -lversion -lodbc32 -lodbccp32
    libc=-lmsvcrt, so=dll, useshrplib=true, libperl=libperl510.a
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
    cccdlflags=' ', lddlflags='-mdll -s -L"C:\strawberry\perl\lib\CORE" -L"C:\st
rawberry\c\lib"'


Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
                        PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS
                        PERL_MALLOC_WRAP PL_OP_SLAB_ALLOC USE_ITHREADS
                        USE_LARGE_FILES USE_PERLIO
  Built under MSWin32
  Compiled at Apr  5 2008 10:33:57
  %ENV:
    PERL5LIB="/lib/perl5/site_perl/5.10"
  @INC:
    /lib/perl5/site_perl/5.10
    C:/strawberry/perl/lib
    C:/strawberry/perl/site/lib
    .