TFH Volume: 30 Issue: 3 Archives

There’s Always A New Last Laugh With Legacy

January 13, 2020 Timothy Prickett Morgan

On my bookshelf beside my desk is a shelf that has all of my relevant AS/400 books and copies of the first decade of The Four Hundred, back when it was a monthly newsletter printed on paper. Sometimes, when I get stuck for ideas, I page through my history and yours, and I am often amazed at the wealth of information that myself and my colleagues – as well as many, many sources – helps us to create. AS/400s were a lot more expensive than IBM i machines, and helping people save money was our primary mission, and there …
Read more
SAP Sending Mixed Messages On ERP Platform Support

January 13, 2020 Alex Woodie

Thousands of SAP Business Suite customers around the world are awaiting clarification from the German software giant about whether their chosen ERP software will continue to run on their chosen platform in five years. SAP is strongly hinting that it may move forward just with S/4 HANA, which at the moment is a Linux-only affair. But its actions suggest a more diverse array of databases and operating systems may be accommodated in the future.

Questions about SAP’s intentions originated with a statement it made in 2014. At that time, SAP announced that it would fully support its current flagship …
Read more
Guru: Formatting Numbers and Dates/Times/Timestamps in SQL

January 13, 2020 Paul Tuohy

In this article, I want to share with you an SQL scalar function that I happen to have been using quite a bit recently. At times, when using an SQL select statement, you may want to format a number or date. Something along the same lines as using the %EDITC or %EDITW built in functions in RPG or the EDTCDE or EDTWRD keywords in DDS. In SQL we can use the VARCHAR_FORMAT or TO_CHAR (they are synonyms for each other – both work exactly the same way) scalar function to provide similar functionality.

Since they are synonyms for each other, …
Read more
As I See It: Digital Trafficking

January 13, 2020 Victor Rozek

The Constitution and the Bill of Rights contain many fine words but “privacy” is not among them. At best the right to privacy is implied in the 4th Amendment, which protects against unreasonable search and seizure, and the Due Process Clause of the 14th Amendment that protects against the arbitrary denial of life, liberty, or property.

One would think that the systematic and deliberate tracking of our movements would constitute an unreasonable search and seizure or, at the very least, an infringement on our liberty. But the founding fathers could not have conceived of a technology that digitized human beings …
Read more
IBM i PTF Guide, Volume 22, Number 1

January 13, 2020 Doug Bidwell

We want to remind you once again about the LPARs that are hanging on machines that have the latest Technology Refreshes applied to IBM i 7.3 and IBM i 7.4 in cases where the Hardware Management Console (HMC) is not managing the partitions. The details of the issue with the Technology Refreshes are outlined in APAR MA48101, which is essentially a bug report that warns customers of an issue with the software stack and oftentimes gives hints about when and how it will be fixed.

Here is the issue in a nutshell: IPL-SRCC6003962-WAIT Hang with IBM i 7.3 with …
Read more
Participate In The 2020 IBM i Marketplace Survey Webcast

January 13, 2020 Timothy Prickett Morgan

Every fall for the past six years, HelpSystems puts out the call for the IBM i community to participate in its annual survey of the base so we can find out what is going on out there in your shops. And then as the new year just gets going, the company hosts a webinar that goes over the results of the survey with commentary from a bunch of people.

Tom Huntington, the executive vice president of technical solutions at HelpSystems, will host the webinar, and I plan to attend as do two familiar IBMers and a new one. That would …
Read more

There’s Always A New Last Laugh With Legacy

SAP Sending Mixed Messages On ERP Platform Support

Guru: Formatting Numbers and Dates/Times/Timestamps in SQL

As I See It: Digital Trafficking

IBM i PTF Guide, Volume 22, Number 1

Participate In The 2020 IBM i Marketplace Survey Webcast

Content archive

Recent Posts

Subscribe

Pages

Search