Hi,

Thanks for using our driver and you suggestions. 

Can you provide us a sample, which is using all these functions/APIs (the way you are expecting it)? Also provide the information about the contain of the tables and the expected output of that sample. 

I will look into it and will try to add these APIs.

Regards,
Ambrish Bhargava

Here is testcase for my proposed new functions

Database setup;

drop table b1;
commit;
create table b1 (id integer not null, data blob not null);
insert into b1 (id,data) values(10,blob('--binary-blob-here--'));
commit;

$conn = db2_connect('SAMPLE);
$stmt = db2_prepare($conn,'select data from b1 where id=10');
db2_execute($stmt);
db2_fetch_row($stmt);

// first function is easy get length of blob
// but entire blob should not travel over wire to db2 client because
// i plan to about 700 MB big blobs

db2_lob_length($stmt,1);
    returns 20;

// get lob object handle
$lobj = db2_lob_open($stmt,1);
    returns large object handle
	
db2_lob_read($lobj,2);
     returns '--';

db2_lob_read($lobj,2);
	 returns 'bi';

db2_lob_seek($lobj, 0);
	  returns true; // returns boolean value - sucess
	  
db2_lob_read($lobj,2);
	  returns '--';
	  
db2_lob_write($lobj,'un');
	  returns true; // boolean - success
	  
db2_lob_read($lobj,2);
	  returns 'na'

db2_lob_seek($lobj,2);
	  returns true;
	  
db2_lob_read($lobj,2);
	  returns 'un';
	  
db2_lob_close($lobj);
	  returns true; // success

i just looked at package documentation and there is already 
function db2_lob_read. I propose to make functions, 
compatible with current lob API.

1.
boolean db2_lob_write ( resource $stmt , int $colnum , 
string  $data )
writes data into large object

2.
int db2_lob_seek ( resource $stmt , int $colnum , int   
$offset )
changes offset in LOB object for reading/writing. returns 
new offset

3.
function for truncating lob object
int db2_lob_set_size ( resource $stmt , int $colnum , int   
$size )
sets LOB size to $size. if lob is larger it will get 
truncated. returns new offset

4.
returns size of lob object
int db2_lob_get_size($stmt,int $colnum);

As this issue is very old, Closing this.