Category: Feedly

​Last week I showed how I could retrieve information from a JSON array using SQL. This week I thought it would be a good thing to do the opposite: create a JSON array and insert it into a column in a SQL table.
To accomplish this I will be using several Db2 for i Table functions:

JSON_ARRAY:  Creates a JSON array
JSON_ARRAYAGG:  Creates a JSON array with an array element from each result row returned from a SQL statement
JSON_OBJECT:  Create a JSON object (not a physical object like a file)

Creating the most basic JSON array is very simple. I just need to use the JSON_ARRAY table function and pass values to it:
Read more » Read More 

​Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development.
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. Read More 

​You may wonder what the screen below has to do with the system value QSECURITY. A change in this system value was part of the announcement of IBM i 7.5, which had a strong focus on security. Level 20 is no longer supported and a new system is shipped with level 40. Setting your system
The post A screen a story – the system value QSECURITY appeared first on PowerWire.eu. Read More 

​The idea for this post came from a question I was asked by a friend. In a RPG program is there a simple way to convert a character value to hexadecimal, and vice versa.
I know of two Machine Instruction procedures that will do this for me:

cvthc:  Convert character to hex
cvtch:  Convert hex to character

In my examples I am going to convert a couple of character strings to hex, and then convert one back from hex to character. All of this I performed in one RPG program. Let me start by showing all the definitions:
Read more » Read More 

​IBM Takes PowerVM And PowerVC Upscale  IT Jungle Read More