On 06/09/12 18:32, Keith Carangelo wrote:
Hello,
We connect to an iSeries AS400 using DBI and DBD::ODBC on a RHEL6 64-bit
web server. Since upgrading to a 64-bit server, we've had trouble with
outer joins that return NULLs (when there is no corresponding record on the
joined table).
select
On 07/09/12 13:49, Keith Carangelo wrote:
Hi Martin,
Thank you so much for your response. I've attached the simplest sql query I
could think of - it just returns NULL in a single row and column, and the log
file. Here is the output:
mater6:~/as400_dbd$ export DBI_TRACE=DBD=trace.log; perl
Martin,
Your diagnosis is correct. Unfortunately, the ODBC driver I'm using is
IBM's iSeries Access for Linux 64-bit ODBC Driver. I'm sure I'll have a
lot of luck getting them to change it. The only thing I don't understand is
that everything works fine using unixODBC's isql command line tool.
I
On 07/09/12 16:05, Keith Carangelo wrote:
Martin,
Your diagnosis is correct. Unfortunately, the ODBC driver I'm using is
IBM's iSeries Access for Linux 64-bit ODBC Driver. I'm sure I'll have a
lot of luck getting them to change it.
I think you might be surprised if you have a license and you