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


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,
Posts: 7
Joined: Tue Apr 27, 2010 4:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sql query to select BLOB


Re: sql query to select BLOB

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


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,
User avatar
dick scherrer
Global moderator
Posts: 6308
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 90 times

Return to DB2


  • Related topics
    Last post