Floating Licenses for Profound.js and Profound API At Profound Logic, we are constantly improving our products to meet the evolving needs of our customers. An increasing number of customers are implementing or exploring dynamic, scalable infrastructures in both public and private clouds. In these elastic environments, managing license keys tied to specific hardware slows the Read More
Creating JSON array with SQL Simon Hutchinson
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
Common: iSee – How to Publish SQL Services Data into JSON learn.common.org
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
A screen a story – the system value QSECURITY Rudi van Helvoirt
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
Convert character to hexadecimal Simon Hutchinson
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
