Re: Need help with json_table

[Jerry Draper <midrangel@xxxxxxxxxxxxx>]

   We us .json files to pass parms to our Python pgms.

   On thing really great about .json is that you can test your json online
   for syntax.

   Just DuckDuckGo "test json" and go from there.

   Jerry

   On 11/3/2021 8:08 AM, Tim Fathers wrote:

 I made some examples a while back that might help, you can find them here:

 [1]https://github.com/fathert/json-rpg-example/blob/master/invoice-extract.sql
 [2]https://github.com/fathert/json-rpg-example/blob/master/json.sqlrpgle

 Tim.

 ________________________________
 From: MIDRANGE-L [3]<midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of compgmr via MIDRANGE-L [4]<midrange-l@xxxxxxxxxxxxxxxxxx>
 Sent: 03 November 2021 12:37
 To: [5]midrange-l@xxxxxxxxxxxxxxxxxx [6]<midrange-l@xxxxxxxxxxxxxxxxxx>
 Cc: compgmr [7]<compgmr@xxxxxxxxx>
 Subject: Need help with json_table

 Does anyone have experience with json_table.  I've tried it a number of different ways and I just can't get a row selected.
 Any help would be appreciated !
 Examples are available.\Thanks,
 Larry
 --
 This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
 To post a message email: [8]MIDRANGE-L@xxxxxxxxxxxxxxxxxx
 To subscribe, unsubscribe, or change list options,
 visit: [9]https://lists.midrange.com/mailman/listinfo/midrange-l
 or email: [10]MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
 Before posting, please take a moment to review the archives
 at [11]https://archive.midrange.com/midrange-l.

 Please contact [12]support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

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

 --
 Jerry Draper, Trilobyte Software Systems, since 1976
 IBM I, Network, and Connectivity Specialists, LAN/WAN/VPN
 Representing WinTronix, Synapse, HiT, and others .....
 (415) 457-3431 . [14]www.trilosoft.com

References

   Visible links
   1. https://github.com/fathert/json-rpg-example/blob/master/invoice-extract.sql
   2. https://github.com/fathert/json-rpg-example/blob/master/json.sqlrpgle
   3. mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx
   4. mailto:midrange-l@xxxxxxxxxxxxxxxxxx
   5. mailto:midrange-l@xxxxxxxxxxxxxxxxxx
   6. mailto:midrange-l@xxxxxxxxxxxxxxxxxx
   7. mailto:compgmr@xxxxxxxxx
   8. mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
   9. https://lists.midrange.com/mailman/listinfo/midrange-l
  10. mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
  11. https://archive.midrange.com/midrange-l
  12. mailto:support@xxxxxxxxxxxxxxxxxxxx
  13. https://amazon.midrange.com/
  14. http://www.trilosoft.com/