Running JasperReports from IBM i Richard Schoen

​For any of you looking to do reporting from IBM i. I created a wrapper around Pete Helgrens RPG Report Generator Java code that can execute Jasper Reports from IBM i. I have done work with Jasper Reports since 2007. JasperReports has a bit of a learning curve but well worth it if you learn to build reports and documents with it. This wrapper is IBM i specific, but Jasper can be used anywhere to generate reports. Have fun.https://github.com/richardschoen/ibmijasper Read More 

Using SQL table function to lookup SQL codes [email protected] (Simon Hutchinson)

​[[{“value”:”It has always been a bit of a bind to look up what a SQL codes means, to be able to discover what error or warning Db2 for i is giving me for a SQL statement I have executed. There is a message file, QSQLMSG, where I can convert the SQL code into a message id and then look in the message file for the message texts:

SQL code -501 = Message id SQL0501

DSPMSGD RANGE(SQL0501) MSGF(QSQLMSG)

With the technology refreshes for IBM i 7.5 TR3 and 7.4 TR9 comes a table function where I can pass it the SQL code, and the results include all the information I desire:

Message id
Message text
Second level message text

Read more »”}]] Read More 

Power of AI on the IBM i Logicmate

​Artificial intelligence is going to change every single industry in ways you can’t even imagine. The possibilities that AI presents are almost limitless and it has already begun to change the way we live and work. From self-driving cars, smart homes, to virtual assistants, AI is transforming our world in ways that were once unimaginable. In a series of short videos I am going to talk through AI in the IBMi world, how businesses and consumers stand to benefit immensely from this advancement and how it will play a decisive role in determining the future of IT. Get ready to witness the transformative power of AI in your applications and how Logicmate along with our partners profound logic can support you in this exciting new IT journey. ****************************** LETS CONNECT! Linkedin – https://www.linkedin.com/in/louise-eastwood-57973879/ Youtube – https://www.youtube.com/channel/UC6sP… Website – https://www.logicmate.co.uk/From: Logicmate Read More 

IBM Banking on Merlin 2.0 to Goose Modern Development on IBM i Alex Woodie

​[[{“value”:”IBM last week shipped most of the new stuff unveiled in the Spring Technology Refreshes, which includes Merlin 2.0, the Web-based application development and modernization environment for IBM i. Big Blue is betting that the new and improved offering will encourage IBM i shops to (finally) begin their journey toward truly modern coding techniques.
Friday, June 14 marked the start of general availability for the majority of the features IBM is including in IBM i 7.5 TR4 and IBM i 7.4 TR10, which it announced on May 8. The version 2.0 release of Merlin – whose official IBM name …
The post IBM Banking on Merlin 2.0 to Goose Modern Development on IBM i appeared first on IT Jungle.”}]] Read More 

MDNA Launches Unit Testing Tool for IBM i Alex Woodie

​[[{“value”:”Midrange Dynamics North America (MDNA) recently launched a new unit testing tool that’s designed to make it easier for IBM i developers to test their code. The software, called MDTest, is works with RDi and VS Code and integrates with MDNA’s change management software for IBM i.
MDNA created MDTest to provide for a simple way for developers to unit test their ILE code. The software automates the process of executing test scripts, recording results, and determining whether the software can be pushed into the next stage of the DevOps processes.
The product includes about 30 pre-built software quality tests …
The post MDNA Launches Unit Testing Tool for IBM i appeared first on IT Jungle.”}]] Read More 

Verified by MonsterInsights