From: Daniel Rychlik <dan.rychlik@...>
Date: 2011-02-10T01:18:08+09:00
Subject: ODBC sth.fetch_hash

Hello All.

I am experiencing an issue with the fetch_hash method in the DBI module.
I am executing a rather complex SQL query to a DB2 database on our
as400.  The column names, in the key index, are coming up as integer
values if the column names appear to be too long.

e.g
{"00001"=>"User data ", "OTHER_COL_NAME"=>"MA1"}

The 00001 is the problem.  I need to see the real column name here,
which in my case is a concat of a two columns.

In PERL you can simply pass the 'NAME_lc' to solve this however I don't
find anything possible for fetch_hash.

PERL e.g
while (my $ref = $$sth->fetchrow_hashref('NAME_lc'))

What am I missing or is this a bug?

Respectfully,
Daniel

-- 
Posted via http://www.ruby-forum.com/.