Re:IBM DB2 and Delphi - can connect through CLI? (For large blobs)
Are you using the BDE calls ?
Dataset.updatecursorpos;
check(dbiOpenBlob(Dataset.handle, Dataset.activebuffer,
Dataset.fieldbyname(FieldName).fieldNo, dbiReadOnly));
try
check(dbiGetBlobSize(Dataset.Handle, Dataset.ActiveBuffer,
Dataset.fieldbyname(FieldName).FieldNo,BufferSize));
if BufferSize < 1 then
begin
Buffer := nil;
BufferSize := -1;
exit;
end;
inc(buffersize);
if Get_buffer(Buffer, Buffersize) then
check(dbiGetBlob(Dataset.Handle, Dataset.ActiveBuffer,
Datset.fieldbyname(FieldName).FieldNo , 0, BufferSize-1, buffer,
result_size));
finally
Check(dbiFreeBlob(Dataset.handle, Dataset.ActiveBuffer,
Dataset.fieldbyname(FieldName).FieldNo));
end;
Quote
Jevgeny Pyatakov wrote:
> BDE can't read part of the blob. DB2 allows it through CLI. Also it allows
> put it directly to file. Is there somewhere header files? Can I get from
> BDE handle needed for CLI?
> jevg...@yahoo.com