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



This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.