Re: Using QSYS2.HTTP_GET_BLOB to download file larger than 16mb with SQL

What are you trying to do with the blob thing?Let it live in its own "blob bubble", ie store it in db or in ifs if you than need some post processing.
bye


On Friday, January 9, 2026 at 04:33:43 PM GMT+1, Vern Hamberg via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

LOL - The "rest"of the world is not all computer professionals. IBM uses
the 1024 in its evaluation of kilobytes and megabytes and all - thus, I
believe we do know better then to follow the "rest". Especially if
making a statement of comparative size.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.6YCgsbFX.0FTYId1b@centurylink.net> CAAC
(COMMON Americas Advisory Council) IBM Influencer 2023


On 1/9/2026 7:47 AM, Daniel Gross wrote:

Vern Hamberg:
I am sorry to have to say, but 2 GB is actually 1 more than 2,147,483,647 - still, it is more than 16 MB - I believe a GB in this context is 1024 * 3, not 1000 * 3.

It can be - and it's also my preferred calculation

    2GB = 2 * 1024 ** 3 bytes

but the rest of our world already adopted the "new" form of 2 * 1000 ** 3 - just ask Google "How many bytes in 2GB" and your answer will be

    2GB = 2000000000 bytes

Anyway - those 2GB (or 2.14GB however we like to see it) are hopefully enough.

Regards,
Daniel