IBMi Software Announcement: Complete info from IBM
- IBM i Access Client Solutions has “Run SQL” interface
- “Run SQL” scripts was previously only available in the Windows Client (System i Navigator / System i Access for Windows).
- Web Sockets w/ Apache level 2.4.12
- allows for real-time communication. A lot of chat applications, and real time collaboration apps are using Web Sockets because of the server’s connection to the client.
- Learn more here
- allows for real-time communication. A lot of chat applications, and real time collaboration apps are using Web Sockets because of the server’s connection to the client.
- Free-form RPG is no longer forced to columns 8 – 80.
- Zend Server for IBM i 8.5 (5639-ZC1)
DB2 for I new features and enhancements
- SQL Functions
- LIMIT and OFFSET for pagination of a file.
//return only 10 records, start on record 11 (OFFSET 10), records 11–20 are returned. | |
$sql = "SELECT * FROM CUSTOMERS LIMIT 10 OFFSET 10"; |
- ASSOCIATE LOCATOR for processing result sets from a remote db.
- LOCATE_IN_STRING() – SQL Function – Find a string inside a string. (PHP devs think strpos)
- OVERLAY() – SQL Function – easily insert a string/variable inside a string (PHP devs think sprintf but not exactly)
- Viewing Record locks or Object Locks in SQL by utilizing the DB2 for i services
—View Object Locks | |
SELECT * FROM QSYS2.OBJECT_LOCK_INFO | |
WHERE SYSTEM_OBJECT_NAME = 'CUSTOMER'; | |
—View Record Locks | |
SELECT JOB_NAME, COUNT(*) AS ROWS_UPDATING | |
FROM QSYS2.RECORD_LOCK_INFO | |
WHERE FILE_NAME = 'CUSTOMER' AND | |
LIBRARY_NAME = 'PRODUCTION' AND | |
LOCK_STATE = 'UPDATE' | |
GROUP BY JOB_NAME | |
ORDER BY ROWS_UPDATING DESC; |
Other New features:
- Open Source tools now included
- GCC, Git, .zip, .tar, bash, Python 2.7, and many others in Open Source for IBM i (5733-OPS)
- Integrated Web Services (IWS) server makes it easy to open your ILE objects up to webservices done in SOAP or REST
References: