Cancelling a SQL job [email protected] (Simon Hutchinson)

​Have you ever been in the position of having a SQL statement running in ACS’s Run SQL Scripts, RSS, and you realize that the reason it is taking so long is something in your selection criteria is too large. I am sure the same thought has crossed all of our minds: “Wouldn’t it be nice if I could just cancel this statement!”
There is a way to do this using the procedure: CANCEL_SQL. The documentation describes this as:
CANCEL_SQL() procedure provides an alternative to end job immediate

This is true I could cancel the RSS job with the End Job command, ENDJOB, with the *IMMED option:
Read more » Read More 

Build and Consume APIs Simply by Using the Right Language Brian May

​Since the beginning, RPG has been the language of choice on IBM’s midrange computing systems (IBM i, AS/400, etc.).  Developers have learned to do everything within the comfort of the RPG language.  However, as technology has advanced, IBM i developers have struggled keeping up with new technologies within a language that was not built for Read More 

How to backup your IBM i to (virtual) tape and upload to Azure BLOB Diego Kesselman

​So I imagined a CL with cloud super-powers we could use to create an Image Catalog with tape virtual media, the best compression I could get in speed and compression ratio, and a stable but easy mechanism to upload those files to Azure BLOB.
Today we can use IBM Cloud Storage Solutions for i (ICC) combined with BRMS to upload an Image Catalog with Virtual Tape from our IBM i to S3 based cloud services like IBM Cloud Object Storage, Wasabi, AWS, Google. Read More 

Verified by MonsterInsights