DBD Runtime Error

2005-09-25 Thread Sath Maripitchai
Hi there, On AIX 5.3, we were able to install DBI and DBD modules successfully (?) on AIX 5.3. I keep getting an error when I connect to Oracle using DBI. I urgently need some advice. Can you help? Sath Maripitchai DBI and DBD versions - drwxr-xr-x 7 root

Subclassing the DBI - any good examples?

2005-09-25 Thread Tim Bunce
I'm interested to hear stories of people who have subclassed the DBI, or used modules that subclass the DBI. Was subclassing the DBI a good approach? Where there any problems? Could it have been done well/better some other way? Thanks! Tim.

Re: How to set language on DB2 on AIX

2005-09-25 Thread Dan Scott
[EMAIL PROTECTED] wrote: Hello, I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3. And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78. Installation may be ok, but when I INSERT double bytes characters, I get the following error. [IBM][CLI Driver] CLI0109E String data

Re: Subclassing the DBI - any good examples?

2005-09-25 Thread Dean Arnold
Tim Bunce wrote: I'm interested to hear stories of people who have subclassed the DBI, or used modules that subclass the DBI. My subclasses (or attempted subclasses): DBIx::Chart - worked (tho it took me a few years to get it right ;^) DBIx::Threaded - didn't work (tho I managed to deliver

Re: how do i find out whether column is signed or not?

2005-09-25 Thread Daniel Kasak
Denis wrote: I need to obtain metadata about the columns in my database. The problem is that column_info does not supply information about the signedness of the column, or I am missing something in the man page. I've googled for some time but found no solution. Any hints where to dig? I

Re: Memoizing non-place-holding sql statements to place-holding

2005-09-25 Thread Steven Lembark
This coding may not be so difficult, but not easy for me. The issue will be converting: insert into foo ( field, fields ) values ( ... ); into insert into foo ( field, fields ) values ( ?, ?, ? ) After that you can use prepare_cached on the sql to get a re-usable statement handle