INF: Finding Length of SQL IMAGE Fields While Using DB-LIBRARY

ID Number: Q63605

1.10 1.11 4.20

OS/2

Summary:

The following information discusses how to find the length of an

IMAGE field using DB-LIBRARY (db-lib) or the datalength() function.

More Information:

DB-LIBRARY does not support huge pointers; therefore, no single data

block can be larger than 64K. For image data less than 64K, the

DBDATLEN() command returns the correct size (if TEXTSIZE is set to

64K). Otherwise, a query to SQL Server using the datalength()

function is the best method to use to retrieve this information. For

example:

select datalength(Imagecolum) from Imagetable where

Fname = "MARTIAN.BMP"

The DBDATLEN() command returns the minimum of the actual data length

of the image field or the TEXTSIZE as set by the SET TEXTSIZE command.

Additional reference words: 1.10 1.11 4.20 dblib Transact-SQL