Visual LANSA Forum

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

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

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

Devils 6 and 1, Habs 1 and 5

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