Page 1 of 1

Field >32K

Posted: Mon Feb 01, 2016 1:26 pm
by 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

Re: Field >32K

Posted: Mon Feb 01, 2016 5:42 pm
by 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

Re: Field >32K

Posted: Tue Feb 02, 2016 3:44 am
by k2R400
Thank you scott

Re: Field >32K

Posted: Tue Feb 02, 2016 8:37 am
by 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

Re: Field >32K

Posted: Tue Feb 02, 2016 9:53 am
by 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.