Re: DB2, how to insert TIMESTAMP

2009-11-02 Thread Bruce Johnson
On Oct 29, 2009, at 6:15 PM, 田口 浩 wrote: Hello, Is there a way to insert TIMESTAMP data or null by 1 SQL? $stmt = "INSERT INTO T_TAB1_T (C1, MEMO, T1) VALUES(?,?,?)"; This cannot insert null data. The simplest way around this is to prepare two statements: $stmt = "INSERT INTO T_TAB1_T (C1,

Re: 'External Connections" on different Oracle versions.

2009-11-02 Thread jeff
:-) Can't, privileges do vary from SID to SID so need user's real access. DBI::Proxyserver for one or the other is a winner I think. On Mon, 2009-11-02 at 09:10 -0700, Bruce Johnson wrote: > On Oct 29, 2009, at 2:15 AM, jeff wrote: > > > Oracle.pm built against 8 works great with Oracle 8 when do

Re: 'External Connections" on different Oracle versions.

2009-11-02 Thread Bruce Johnson
On Oct 29, 2009, at 2:15 AM, jeff wrote: Oracle.pm built against 8 works great with Oracle 8 when doing an 'external connection' (i.e., No user or password supplied in DBI->connect ) but will not connect to 10 without a username/password. Each version of Oracle uses a different mechanism to do

DBD TimesTen coredump on HP-UX 64 bits

2009-11-02 Thread Thiebot, Christophe
I have installed DBD:TimesTen 0.06 on a HP-UX 11.23 IA64 server (HP rx2600) together with TimesTen 7.05 for 64 bits. The DBI "make test" command fails with core dumps notifications (my perl program core dumps as well) tough perl Makefile.PL and make commands do not show any error. To make DBD

Re: Multiple Oracle clients in same code - no usernames needed

2009-11-02 Thread jeff
Going with DBI::Proxyserver. Seems to work well. All Oracle 10 connections are handled by script while all Oracle 8 are handle by Proxyserver ( built with Oracle 8 libs ). :-) On Mon, 2009-11-02 at 15:36 +1100, Matthew Watson wrote: > Might not be an option... > > But any reason why you couldn'