sql query to select BLOB



IBM's flagship relational database management system

sql query to select BLOB

Postby KEN » Tue Jun 08, 2010 5:49 pm

Hi,

I want to write a sql query to select the BLOB (binary large object) with size greater than 7MB from the table.

Can anyone hellp me with this?

kind regards,
Ken
KEN
 
Posts: 7
Joined: Tue Apr 27, 2010 4:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sql query to select BLOB

Postby dick scherrer » Wed Jun 09, 2010 12:07 am

Hello,

What have you tried? What problem/confusion was encountered?

From the V8 SQL manual:
A binary large object (BLOB) is a varying-length string with a maximum length of 2 147 483 647 bytes (2 gigabytes minus 1 byte).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post