Entering a TimeStamp value into DB2

From: Richard Rice (Richard.Rice_at_conti-na.com)
Date: 03/24/05 

To: dbi-users@perl.org
Date: Wed, 23 Mar 2005 23:21:59 -0500

I am having a problem using the Perl DBD::DB2 module to enter a 'TimeStamp'
value into a DB2 table. I have been able to write a perl script which can
enter an 'integer' or 'varchar' value into a DB2 table. I also need to
enter a 'TimeStamp' value into the same table. I have not been able to
correctly format the 'TimeStamp' value in my script so that the 'INSERT'
command executes without errors.

Does anyone have a perl example script for entering 'TimeStamp' values into
a DB2 table?

*****************************************
Richard Rice
Continental Tire North America, Inc.
(704) 583-8668
*****************************************

Relevant Pages

  • Re: Entering a TimeStamp value into DB2
    ... I went to google and searched for "db2 timestamp" and this ... If formatting the date and time data is a major consideration for your ... These facilities are not available for TIMESTAMP columns. ... correctly format the 'TimeStamp' value in my script so that the ...
    (perl.dbi.users)
  • Re: crontab script
    ... if it is off the perl script tries to connect again and lunch a perl ... get the timestamp. ...
    (comp.lang.perl.misc)
  • crontab script
    ... if it is off the perl script tries to connect again and lunch a perl ... get the timestamp. ...
    (comp.lang.perl.misc)
  • DBI - DB2 Perl Script ... TWiki
    ... I have this script that am trying to use to connect to DB2. ... run the Perl script, then I can connect to DB2. ... #use DBI; ...
    (perl.beginners)
  • an approach
    ... i am working on db2 and need a perl script to delete data from a ... There is a column in that table X lets say Xdate. ... timestamp format so its creating problems for me. ... db2 "select countfrom tableX" into a variable say $DD... ...
    (comp.lang.perl.misc)