Saving BLOB while connected to IBM i in VLF-Forms (RESOLVED)

[atostaine]

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.

[PierreLefrancois]

Hi there,

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

Pierre

[atostaine]

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

[PierreLefrancois]

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

[atostaine]

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

[PierreLefrancois]

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

[MarkD]

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

[atostaine]

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

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