#!/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;
####
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.
##
##
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
.