• Guru: Parsing JSON That Has Spaces In The Key

  July 8, 2024 Mike Larsen

  One of my favorite tasks is working with APIs. I’ve worked with many APIs over the years, and some introduce unique challenges that must be overcome. Recently, I worked on a project where I was to consume a REST API that provided a JSON payload. While that seems straight forward, I quickly discovered a challenge.

  The JSON payload had keys that have spaces in them (Figure 1). That may be considered bad practice, but I still needed to figure out how I could parse it correctly. Having never seen JSON like this before, I started with a Google search. I …

  Read more

• Guru: Web Concepts For The RPG Developer, Part 2

  June 10, 2024 Chris Ringer

  Hello again! Part 1 of Web Concepts for the RPG Developer was an introduction on how to build components in an HTTP request and I hope you enjoyed it. Part 2 is just a continuation of that vast topic because there is so much to learn. I encourage you to click on the links in this article and explore on your own too.

  JSON

  A web API endpoint may require the data in the body of an HTTP POST request to be constructed as JSON (“jay sahn,” short for JavaScript Object Notation). JSON is formatted text (a string) containing key:value …

  Read more

• Guru: Testing URLs With HTTP_GET_VERBOSE

  May 20, 2024 Gregory Simmons

  In my previous article Fooling around with SQL and RPG, I explored having a little fun with the HTTP_GET function to fetch a witty Dad Joke from https://icanhazdadjoke.com/. In this article, I want to demonstrate a more practical use of this great function. Or should I say, another version of HTTP_GET, that is HTTP_GET_VERBOSE, which also was introduced to us by the DB2 team in V7R3.

  In its simplest implementation, I can insert the URL I want to test into an SQL statement:

  select *
  from table(QSYS2.HTTP_GET_VERBOSE('https://icanhazdadjoke.com/',''))
  

  I will later want to run this embedded in an RPG …

  Read more

• Guru: The OpenAI API – The Easy Way

  May 13, 2024 Dan Darnell

  When it comes to programming in a particular programming language there is what you can do and what you can do easily. I use RPG every day and have done so since the System/34 days. I love the language but I’ve also picked up other programming languages over time because sometimes RPG isn’t the right tool for the job.

  I’ve been using IBM EGL – Enterprise Generation Language – to create IBM i applications since 2009. IBM made a push at one time to entice RPG programmers to pick up the language and toolset (Rational Business Developer) for modernization …

  Read more

• What’s Up with Open Source on IBM i?

  March 27, 2024 Alex Woodie

  Open source software has become a steadfast component of the IBM i stack. But what open source software are IBM i shops using today? Results from Fortra’s recent IBM i Marketplace Survey provide answers.

  It may seem odd now, but open source hasn’t always been a staple of the IBM i server’s software diet. Until PHP arrived on the platform two decades ago, proprietary software was the only option for IBM i shops.

  But today, IBM i shops have hundreds of open source products to choose from. Thanks to the IBM i server’s openness, just about any product that can …

  Read more

• Guru: Getting Started With The Code 4 i Extension Within VS Code

  January 22, 2024 Gregory Simmons

  The Code for IBM i extension is growing in popularity and has certainly become my favorite source code editor. This article is not an attempt to convince you to drop RDi and switch to VS Code. Rather, I aim to share with you a few of my favorite settings and features in VS Code.

  Join In The Discussion

  Can’t figure out how to do something? Have a suggestion for a new enhancement? I am continually impressed with the speed at which I get responses when I post something. The team of coders and contributors to the Code for IBM i …

  Read more

• ACS, Merlin Hit With Serious Security Vulnerabilities

  December 11, 2023 Alex Woodie

  Three serious security vulnerabilities in IBM i Access Client Solutions and six in Merlin were disclosed and patched by IBM last week. The flaws could allow attackers to commit a range of crimes, from executing arbitrary code and denial of service attacks, to obtaining sensitive data on IBM i conducting phishing attacks. All of the flaws – including another three reported by IBM in November – should be patched immediately.

  IBM published a security bulletin December 8 covering all three of the ACS flaws, which impact ACS versions 1.1.2 through 1.1.4 and 1.1.4.3 through 1.1.9.3. The fix is to download …

  Read more

• Thoroughly Modern: Practical Ways IBM i Developers Can Use AI Today

  December 4, 2023 Scott Gingerysty

  This October at COMMON’s NAViGATE Conference, I presented a session about practical ways that IBM i developers can use AI in their day-to-day development practices. We discussed how you can streamline and optimize the development process, improve coding velocity, enhance code hygiene, testing and documentation, and we also looked at some of the caveats. After connecting with the folks at COMMON – and seeing their enthusiasm – I felt inspired to share these examples with the IT Jungle community.

  So, why AI for developers? AI offers a transformative toolkit that streamlines learning and amplifies creative problem-solving. Through machine learning algorithms, …

  Read more

• Eradani Lays Waste to API Payload Restrictions

  November 15, 2023 Alex Woodie

  Eradani Connect customers who need to pass large amounts of data to IBM i via external API calls have often been stymied by a built-in restriction in IBM i that limits their payload to a mere 16MB. Those customers will be thrilled that Eradani has launched a new big data connector that smashes those payload restrictions to smithereens.

  Eradani Connect is a packaged application designed to simplify the creation and execution of API calls on IBM i. The software functions as a middleware layer that makes it easy for .NET, JavaScript, and Python developers to get access to the IBM …

  Read more

• Guru: The Transition From Modern RPG IV To Modern SQL

  October 30, 2023 Bob Cozzi

  Seven or eight years ago I was working with a client who needed more contemporary reporting than provided by the legacy Query/400 product. Initially I looked at Db2 Web Query and realized the documentation was sparse and the tutorials for most things, even “getting started” were virtually non-existent. It was also about four times more expensive than I felt it was worth to a P05 or P10 client. I mentioned the documentation issue to the folks at IBM and they agreed. Some of it was eventually resolved, but not enough in my opinion to get the masses to replace Query/400 …

  Read more

Previous Articles Next Articles