Re: Data-Into (YAJLINTO) question

[Suren K <suren7437@xxxxxxxxx>]

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