Hi, I'am using DBI::DB2 for a lot of program and now I
need to create a programme to archive data. So, I
would like to export data from database to a file and
then load that file in another db2 database.
Here is what I try:
$dbh->do(q{export to test.ixf of ixf select * from
steph_test}) or die $db
I did not see a lot of sample script regarding perl and DB2 but if you want
tell me what kind of example you are looking for and I will sent you a
couple of script I've made. I use DB2 and Perl on a regulary basis.
Stéphane Legault, ing.
Services Mondiaux IBM
IBM Canada Ltée
Architecte, SEDQ/Tech
I'm using DB2 with perl and I make this select in my code:
$sth= $dbh->prepare ("select
date(wedthreenregis),wenid_app,wealias,count(weduration) from
slegault.weexectime where date(wedthreenregis)= ? and wenid_app= ? group by
date(wedthreenregis),wenid_app,wealias");
when the count(weduration) is
I do a lot of select in many statement and fetch the result on a array as
needed. But now one of my staement is a "select count() from ...". How can
I get the value of this statement?
I use Perl to connect to DB since a long time but my needed until now was
just make a select and insert!! Now I want to update a specific row (in
fact the first row) in a simple table. I use a DB2 database. Can someone
help me?
Thanks
"RMD"
<[EMAIL PROTECTED]Pour :Stephane
Legault/Quebec/IBM@IBMCA
I'am parsing a text field delimited by ; (see example belown). I split the
file into multiple variable ($) and then execute the request. When the NO
is blank: no problem the record is write inside DB but when de DATE is
blank I receive a message from DB telling me that the format of the date is
no