Category: IBMi

Retrieve commands with F8

Generate JSON data from SQL

We can generate Json data on ibm i using JSON_OBJECT sql function. Example: If we have a Empmst table with the following record. Emp_ID is numeric, First_Name and Last_Name fields are CHAR. Emp_ID  First_Name    Last_Name 1                 Nanda              Jay   Select Json_Object […]

Hello IBM i 7.4

Ibm i – The most amazing IBM product you have never heard of