The driver fails silently while fetching clob column.
This problem manifest itself on
DB2 Server: v.9.7 fp7, 64 bit, installed on Linux SuSe 11 fp2
DB2 Client: same instance as server
DBI : originally 1.607, upgraded to 1.625, but the problem persists
DBD::DB2 : 1.85
Perl: 5.10.0
However, if I catalog the same database on DB2 v.9.5 fp5 running on WinXp, the error disappears:
DB2 Server: v.9.7 fp7, 64 bit, installed on Linux SuSe 11 fp2
DB2 Client: v.9.5 fp5, 32 bit, installed on WinXP
DBI : 1.607
DBD::DB2 : 1.74
Perl: 5.8.9 (Activestate)
Please let me know if you need any additional information.
Here is an excerpt from the DBI trace log. Row 18 is fetched correctly, row 19 is causing an error:
DBI_TRACE=9=dbitrace_3.log perl my_script.pl
#Normal fetch:
-> fetchrow_array for DBD::DB2::st (DBI::st=HASH(0xcfed38)~0xc7c590) thr#78e010
dbd_st_fetch 5 fields
0: rc=0 '94608'
1: rc=0 '010'
2: rc=0 '618'
3: rc=0 'O04/01/21'
4: rc=0 'clob text goes here' [5 items] row18 at my_script.pl line 194
#Abnormal fetch:
-> fetchrow_array for DBD::DB2::st (DBI::st=HASH(0xcfed38)~0xc7c590) thr#78e010
dbd_st_fetch 5 fields
0: rc=0 '94630'
1: rc=0 '010'
2: rc=0 '618'
3: rc=0 'O04/01/22'
!! info: '' 'SQL_NO_DATA returned from Diagnostic Information. There might be no diagnostic records for this handle. Please see Infocentre for more details!!' (err#0)
<- fetchrow_array= ( ) [0 items] row19 at my_script.pl line 194
Show quoted text
>> err DISPATCH (DBI::st=HASH(0xcfed38) rc1/1 @1 g0 ima4 pid#14321) at my_script.pl line 201
-> err in DBD::_::common for DBD::DB2::st (DBI::st=HASH(0xcfed38)~0xc7c590) thr#78e010
info: '' 'SQL_NO_DATA returned from Diagnostic Information. There might be no diagnostic records for this handle. Please see Infocentre for more details!!' (err#0)
<- err= '' at my_script.pl line 201
Show quoted text >> finish DISPATCH (DBI::st=HASH(0xcfed38) rc1/1 @1 g0 ima1 pid#14321) at my_script.pl line 203
!! info: '' CLEARED by call to finish method