IBM Mainframe Forum

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

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).