Re: Data-Into (YAJLINTO) question

Hi Greg,

Try using the Parser Options.

Example:

data-into(E) dataStructure %DATA(Wrk_Json:Wrk_Opt)
%PARSER('YAJLINTO'
:'{ "document_name": "json", +
"value_true": "1", +
"value_false": "0", +
"value_null": " " }');

It ("value_null": " " ) will replace the NULL value with blanks.

Regards,
Surender K

On Wed, Jun 19, 2019 at 3:19 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

I apologize if this question is not appropriate for this mailing list...

I'm using YAJLINTO to load JSON into my data structure... In some of the
elements I'm gathering, the element literally contains "null". Sometimes
it contains "". YAJLINTO converts this to "*NULL" (that ends up in my DS
fields).

Example:
"SellerOrderID": null,
In my DS field SellerOrderID (char(128)) contains *NULL

Since I'm using mostly all character definitions, I was wondering how to
handle this.

Is there option with YAJLINTO to convert "null" to blank instead of
"*NULL", or do I need to look for "*NULL" in each field before loading the
data into my database files?

How is this normally handled?

Thx,
Greg
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com