Re: YAJL - VARCHAR - CLOB question

Hi Vicki,

Its not clear from your post whether the varchar is working for you, or whether it's even needed?  If you want to look into the varchar situation further, please post a code sample so I can understand what you are doing.  I will admit, it can be a bit tricky to convert to varchar due to the fact that yajl_copyBuf() uses pointers rather than strings...  but it's possible.  Just let me know.  (Or, use yajl_copyBufStr() instead.)

With regards to a CLOB, its pretty easy. As Birgitta explained, the SQLTYPE CLOB will generate a data structure with separate fields called xxx_DATA and xxx_LEN. The DATA field is a 'char' field, and importantly, the LEN field is unsigned (so uns(10) in RPG.) The only tricky part of that is that yajl_copyBuf() expects a signed integer rather than unsigned, so you need to use a temporary variable.

With that in mind, the logic looks like this:

       dcl-s myClob SQLTYPE(CLOB:256000);
       dcl-s len int(10);

yajl_genOpen(*on);

       ... your logic to generate your JSON document goes here ...

       yajl_copyBuf( 0
                   : %addr(myClob_DATA)
                   : %size(myClob_DATA)
                   : len );

       myClob_LEN = len;
       yajl_genClose();

Then, of course, you'd use SQL to insert or update the CLOB field.


On 6/27/2018 6:12 PM, Vicki Wilson wrote:

Hi all,

Working on first YAJL - proof of concept program - we are on v7r1 (v7r2 not an option right now.)

I have successfully written to the IFS using the yajl_saveBuf function to verify I'm creating the JSON correctly.
Instead of writing to the IFS I would like to write it to a CLOB field in the database. Here's where I'm stumbling.

I have defined a varchar of 256000 in the program. I tried to yajl_copyBuf to retrieve the data into the varchar field. I'm not sure I succeeded. I'm not used to working with such large varchar fields. Can I see it when I debug? - It has something in it - just not sure what.

So here's where it gets murkier. Can I insert a varchar into and SQL clob? Or do I need to move the varchar into an SQLCLOB first and then insert? And/or can I use the yajl_copyBuf to retrieve into the sql type of clob and then insert into the database.

Examples and references would be great.

Thanks.
Vicki Wilson