Visual LANSA Forum

I have a picture in c:\temp. My function is running connected to IBM i. I try to insert a record into my table with a blob field and I get fieldName length is 0. https://www.ibm.com/support/knowledgece ... n404.html

It looks like it's happening for large image files (23meg), but not for smaller ones. I don't see a timeout connection in the VLF-WIN server connection.

Hi there,

Can it be this : https://www.lansa.com/support/tips/t0476.htm

Pierre

That sure looks like it. Care to share your search method?

I just remembered that issue we had long time ago.

Hope that solves it for you and that it's not something else.

Good luck - Pierre

Darn that wasn't it. Unless I have to restart the listener subsystem?

You need to check-in and recreate the table on the IBM i

From the tip:

After changing this to an acceptable value for your system, save the x_dbmenv.dat, and redo the check-in (ensure you select to recreate the file)

Maybe you did, just checking..

Any joy after recreating the file? Maybe have a look at it with DSPFFD to see what it says about the BLOB field?

Dspffd shows 30 meg which is what I set the environment variable to.

I also reduced the size of my images. Something fixed it.