Field >32K

[k2R400]

Hello,

I want to use TinyMCE, but a 32K varchar is very small for a document like an agrement.
RPGLE can use field with a size of 16MB and SQL can use CLOB field with a siez of 2GB.
Is it a way to use a field > 32K with the DESIGNER and RPGLE (or SQLRPGLE) ?

Thank you in advance

[Scott Klement]

Yes, you can make an AJAX call to an RPG program written using the Universal handler or something like RPGsp or CGIDEV2 or something like that. This would allow you to send as much data as you like.

Profound UI has routines for making AJAX calls built in
http://www.profoundlogic.com/docs/displ ... evelopment

[k2R400]

Thank you scott

[sgagn0]

Would there be a way to do that outside of an ajax call?
Ex: My main program (which build the header & grid) also build a JSON string longer than 32k and I would like to have that JSON passed to the weg page (and same field would need to be resent to the program).

Maybe I am wrong, but doing it using ajax would require to store the info somewhere (ifs, db, ...), then having the WS/universal handler/CGI retrieve the info from there. This means 2 additional (1 from server to web page and 1 from web page to server) calls and additional process (I/O) to store the info. I would like to bypass these additional requests and I/O if possible, but, as of now, could not find a way to do it.

Thanks

[Scott Klement]

Open Access will limit you to 32k because it uses a record format to pass data to/from the handler.

You could potentially drive your screens without OA, such as building your own JSON data and sending it via the Universal hander, or something like RPGsp or CGIDEV2. Then you could send all of your data in a single request/response if you want, I guess.