scottklement.com

If in the future you need rel, you can just define it using dcl-subf inside your DS.

Hello,

You need to add DECEDIT(0,) to your H-spec or CTL-OPT statement.

https://www.ibm.com/docs/en/i/7.3?topic ... brun-value

Brian

For completeness: It turned out the person creating the sheet had to make a change to how they were creating the sheet as they were doing something wrong.

I don't have the full definition of the JSON so DATA-INTO is a problem.

I'm sure I can get the definition so that might be worth a try.

Thank you for the suggestion.

I have a task where I need to read a database file that has a column that contains a JSON string. I will then execute code based on the value of a key in that string and then modify the value for that key and update the table. All that is pretty straightforward except for "modify the value for ...

On yajl_genOpen that first parameter is whether or not to make the JSON "pretty". If you pass *OFF instead of *ON it will drop all the line feeds (\n) from the string. You don't show how you added "OUT_JSON" to the JSON object in your code example but it looks like that may be wh...

The slash indicates an escape character. My guess is you added a string containing the { and what follows instead of adding those elements individually.

Can you share some code? Both how you build the JSON object and how you extract it into a string. That may help us determine what is happening.

ArrData is an array you cannot do "dsply arrdata;"

You could do something like this:

I'm trying to parse an XLSX file that was generated by another system (not IBM i) using Apache POI XSSF routines (I'm not sure which version of POI they are using). When parsing I only get calls to my numeric cell call-back routine. All string cells are ignored. The sheet opens fine in Excel and Goo...

All of Scott's utilities are at scottklement.com

You can get HTTP API at scottklement.com/httpapi/