Guru: Alternate SQL Row-Selection Criteria Revisited Revisited

I am not a “do as I say and not as I do” kind of person. After I wrote the article Guru: Alternate SQL Row-Selection Criteria Revisited, I got serious about using dynamic SQL in my RPG programs instead of enabling and disabling logical expressions in the WHERE clause. I’m reliving the days when OPNQRYF was my best friend, trying to make apostrophes play nice with string concatenation.

Overall, I’m happy with the change. When I have converted the switch-laden version to dynamic SQL, I have seen a noticeable performance improvement in some cases, and at least a slight

The post Guru: Alternate SQL Row-Selection Criteria Revisited Revisited appeared first on IT Jungle.

IBM Adds Public Cloud Targets For IBM i Cloud Backup

The cloud has become a popular place for organizations to store backups. And with the recent Technology Refreshes (TRs) for IBM i, the number of targets for the Cloud Storage Solutions for i has increased significantly.

IBM debuted Cloud Storage Solutions for i back in 2016 as a connector that allowed Backup, Recovery, and Media Services (BRMS) to push IBM i backups over the Amazon S3 protocol to the Cleversafe object storage system running in SoftLayer, the public cloud platform that would become IBM Cloud in 2018 (IBM would subsequently rename Cleversafe as IBM Cloud Object Storage).

IBM has augmented

The post IBM Adds Public Cloud Targets For IBM i Cloud Backup appeared first on IT Jungle.

The Big Iron Customers That The Power E0180 Is Aimed At

One of the central tenets of our philosophy here at The Four Hundred is: Anything that makes Power Systems stronger helps IBM i last longer.

For as long as we have been watching the AS/400 and IBM i market, big iron has driven a lot of revenue for machines based on IBM’s proprietary CISC processors and then PowerPC and Power RISC processors. And the big iron machines drove even more of the profits from these products. Big iron is, therefore, important. But just how much money are we talking about?

A lot more than you probably think, as it

The post The Big Iron Customers That The Power E0180 Is Aimed At appeared first on IT Jungle.

Verified by MonsterInsights