problem in fetching clob data in db2

From: Nagaraj_Hayyal (Nagaraj_Hayyal_at_satyam.com)
Date: 02/14/05 

To: tomasz konefal <twkonefal@yahoo.ca>, "dbi users perl.org" <dbi-users@perl.org>
Date: Mon, 14 Feb 2005 12:04:02 +0530

 

Hi there,

I am newbee to this perl.

I am using db2 as a database.

I have a problem in fetching clob data in perl.

I have set all the necessary parameters as shown below.

 

use DBD::DB2;

use DBD::DB2::Constants;

 

use DBD::DB2 qw( $attrib_dec $attrib_int $attrib_char $attrib_float

$attrib_date $attrib_ts $attrib_binary $attrib_blobfile

$attrib_clobfile $attrib_dbclobfile

              );

 

Even I have set

 

$dbh->{LongReadLen} = 5000000;

$dbh->{LongTrun***} = 1;

 

But still I have a problem in fetching a single row of clob data.

 

Can anyone help me ASAP.

 

Thanks

 

 

 

Thanks & Regards

Nagaraj Hayyal

Mobile:+919849975748

**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************

Quantcast