Blob limits

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
atostaine
Posts: 131
Joined: Wed Jan 20, 2016 7:38 am

Blob limits

Post by atostaine » Wed Oct 18, 2017 5:24 am

I copied xEmployeeImage and am using my version in a table. The table is on IBM i. We tried to insert a record/blob that was over 10 meg and it failed. We reduced the file size to less than 10meg and the same image worked.

Is there any limit on blob sizes by LANSA or i?

Thanks, Art

PierreLefrancois
Posts: 11
Joined: Wed Nov 09, 2016 3:02 am

Re: Blob limits

Post by PierreLefrancois » Wed Oct 18, 2017 6:08 am

Art,

You need edit file "lansa_xxxpgmlib\x_lansa\x_dbmenv.dat" file.

Look for this:
* ====================================================
* DB2 - iSeries platform (For runtime NOT Development)
* ====================================================

and then for this line:

TYPE_LONGVARBINARY_DEFAULT_LEN=10M

Change it to something like "50M" and recompile your file.

This value will be reset to 10M when you upgrade your LANSA system to a new version so put this in your procedure of things to do after an upgrade.

Hope this helps - Pierre

atostaine
Posts: 131
Joined: Wed Jan 20, 2016 7:38 am

Re: Blob limits

Post by atostaine » Fri Oct 20, 2017 1:10 am

Thanks Pierre. I will try it out. Have you watched the NJ Devils this year? :mrgreen:

PierreLefrancois
Posts: 11
Joined: Wed Nov 09, 2016 3:02 am

Re: Blob limits

Post by PierreLefrancois » Sat Oct 21, 2017 2:44 am

Devils 6 and 1, Habs 1 and 5 :-(

atostaine
Posts: 131
Joined: Wed Jan 20, 2016 7:38 am

Re: Blob limits

Post by atostaine » Tue Oct 24, 2017 1:35 pm

We lost our last game. We have off for a week.

I always keep an eye out for the Habs just to keep up with what Pierre might be doing. Thanks for the help

Post Reply