RE: selecting millisecond or microsecond accuracy from varray of timestamps

2010-01-28 Thread John Scoles
> From: carlso...@llnl.gov > To: dbi-users@perl.org > Date: Thu, 28 Jan 2010 11:42:42 -0800 > Subject: selecting millisecond or microsecond accuracy from varray of > timestamps > > We have an oracle type, > > CREATE OR REPLACE TYPE ARCHIVE.VOLTAGE_TIMESTAMP_ARRAY AS VARRAY(200) OF > TIMEST

selecting millisecond or microsecond accuracy from varray of timestamps

2010-01-28 Thread Carlson, John W.
We have an oracle type, CREATE OR REPLACE TYPE ARCHIVE.VOLTAGE_TIMESTAMP_ARRAY AS VARRAY(200) OF TIMESTAMP; We would like to get millisecond or microsecond accuracy out of these timestamps. We are currently using DBD::Oracle 1.21. Here is a sample query, with several varrays & rows being ret

Re: Teradata

2010-01-28 Thread Alexander Foken
"Unable to get host address" means that you have a problem with your name resolver. Try to ping the DB server by using the same name as in the connect string, and from the same machine your Perl script runs on. This will probably fail. If it does, you will have to set up one or more DNS serve

ANNOUNCE: IBM DB2 Database Driver for Perl DBI Version 1.78 released

2010-01-28 Thread Open Source Application Development
IBM DB2 Database Driver for Perl DBI Version 1.78 has been uploaded on CPAN. Testers are please welcome to test the new features and report the bugs. DBI is an open standard application programming interface (API) that provides database access for client applications written in Perl. DBI defin

Teradata

2010-01-28 Thread Faizel Isaacs
http://www.vodacom.co.za/getconnected/index.jsp Hi There This is my first attempt at connecting to a Teradata database. My DBI - connect string does not seem to work as expected as I'm getting a error back that states-: Unable to get host address, I'm not sure if I should add more attributes t