Subject: | DBD-DB2 does not return rows from views in syscat schema |
Hail to the Maintainer! :)
Version 1.78 does not fetch rows for select statements against views in
SYSCAT. It works well for their background SYSIBM tables and also for
user-created views.
No error is raised or printed.
The very same sql run by the same user gives the expected result via
CLP, and so does using v1.76.
OS info: Red Hat Enterprise Linux Server release 5.5,
2.6.18-194.3.1.el5PAE #1 SMP
Perl info: v5.8.8 built for i386-linux-thread-multi
DB2 info: DB21085I Instance "db2inst1" uses "32" bits and DB2 code
release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and
FixPak "9".
make test finishes 100% successfully.
Sample:
my $sql = q/select * from syscat.tables/;
...
my $sth = $dbh->prepare( $sql);
$sth->execute;
my $colnames = $sth->{NAME_uc};
print "@$colnames\n"; # <- here we have perfect output
while ( my @row = $sth->fetchrow_array) {
print "@row\n";
} # <- here we have nothing
Thanks in advance for any idea!