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 

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 

Common: N2i: Getting Started with a Career on IBM i learn.common.org

​Simon has been writing his acclaimed IBM i blog, RPGPGM.COM, for almost ten years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL.
Steve’s deep background in retail began on the sales floor while in college, and he’s applied those lessons learned to many roles in IT throughout his 33 year career with PC Richard. Read More 

Verified by MonsterInsights