I have the following script (extremley simplified)
foreach my $key (sort {$a=$b} keys %run){
my $inp;
$inp=$dbh-selectall_arrayref(select id, [description] from
Kaonix_import_base where idint between ? and ? ,undef,$run{$key}-[0],
$run{$key}-[1]) ;
addrec($inp); -- sub to run very heavy regexs
Hi
Is it a known issue with running bcp while an active db connection
I have a script that basically
opens a db connection
selects some data
parses/transforms the data
writes to a text file
--
runs bcp to import the data into same database
--
does some
HI
If I use printf to round a numeric value before inserting into postgres
table it is altered to 1 rather than the value when it is put into a table
example
CREATE TABLE public.chksize
(
size numeric(10,2), #does not matter what field type
path1 character varying COLLATE
Has anyone done any work on converting SQL queries between RDBMS and perl?
My particular interest is DBD::Pg but anything would be of use
It would be very useful when I am testing complex SQL, it's very easy to
miss a \ or quote between the two
Thanks
Mike