• Easier Overloading of SQL Functions

  June 14, 2016 Hey, Ted

  In Formatting Dates with SQL, Take 2, you have shared a great technique. Function overloading is a real boon to SQL programming. Here’s another way to handle the same issue with what I believe is less code and less invasive (meaning you won’t have to recompile programs that use the FMTDATE service program). Leave your original FMTDATE function alone, but add the following to the SQL source: create function xxx/fmtdate (inDate varchar(8), inFromFmt varchar(8), inToFmt varchar(8)) returns varchar(10) language SQL specific FMTDATEA deterministic returns null on null input begin declare DateNum numeric (8,0); declare OutDate varchar(10); set DateNum =

  … Read more

• The Basics Of XML-SAX

  June 14, 2016 Jon Paris

  Note: The code accompanying this article is available for download here. In XML-INTO And Optional Elements, I showed a reader how he could use XML-INTO to parse an XML document that effectively contained one of two completely different payloads. As I noted in that article, for this type of “does the document contain X” processing, XML-SAX can be a better choice than XML-INTO. That is the task that I’m going to demonstrate in this tip. In his email, the reader mentioned that his original intent had been to simply identify the type of payload (Report or Event) and

  … Read more

• The Server Refresh Cycle Loses Steam

  June 13, 2016 Timothy Prickett Morgan

  With one way of looking at it, the server market that drives the IT business is very mature and relatively flat, which shows demand for compute (and in some cases storage) remains steady and healthy. But in another way of looking at it, in a world obsessed by growth and often demanding it to drive revenues, profits, and stock prices, the server market has taken a dip and this is bad news. Which way is it? Like an electron, perhaps, it is neither and both at the same time. What we can tell you is that the box counters at

  … Read more

• Focal Point Emphasizes Security Assessments, Documents In The Cloud

  June 13, 2016 Dan Burger

  Focal Point Solutions Group, an IBM i-based managed service provider specializing in high availability, disaster recovery architectures, and security monitoring has expanded its services to include security assessments and document management in the cloud. Slowly but surely the word is getting around that IBM i systems are securable but not inherently secure. The distinction is that it takes skills and knowledge to secure the box. Security doesn’t just happen when you push the power button. More to security than locking down the network. Customers are realizing they need to know that security issues are being monitored and addressed when

  … Read more

• Rocket Ties Analytic Database Into IBM i

  June 13, 2016 Alex Woodie

  IBM i shops that are interested in extracting insights from their data under the guidance of automated statistical analysis and machine learning may want to check out a new offering from Rocket Software. Called Rocket Discover for IBM i, the new software combines data discovery capabilities with self-service data preparation, and is aimed at regular business users who find things like Tableau Software‘s products too geeky or difficult to learn. Rocket began building its Rocket Discover tool several years ago to serve the growing need for self-service tools that can handle the entire analytic spectrum–from data preparation and

  … Read more

• Fresche Makes Bold Move In IBM i Modernization Arena

  June 13, 2016 Dan Burger

  Another IBM midrange earthquake was reported last week as two of the big application modernization vendors joined forces to create a single source of a wide range of products and services. Throughout the IBM i community, windows rattled and light flickered as Fresche Legacy–now known simply as Fresche–announced it was purchasing Quadrant Software. According to Fresche, it now has a client base totaling more than 22,000 IBM i customers. Financial details of the acquisition were not reported, as both software companies are privately owned. Fresche’s CEO Andy Kulakowski said the purpose of this acquisition was to allow Fresche

  … Read more

• Talking IBM i Ecosystem With HelpSystems CEO Chris Heim

  June 13, 2016 Timothy Prickett Morgan

  There has been a flurry of acquisitions in the IBM i marketplace in the past several years–you might even call it a blizzard. That got me to thinking last week about the changes in the OS/400 and IBM i ecosystem that we have seen in the past several decades, which I talked about in an essay last week. HelpSystems has built one of the largest software business dedicated to the IBM i platform. Infor could have a larger one, and Vision Solutions might, too, but they are all private companies so we can’t tell. Fresche, with its recent

  … Read more

• Learning From Experience

  June 6, 2016 Dan Burger

  I’ve got good news and bad news. I’ll give you the good news first. We’re never too old to learn something new. The bad news? Don’t ever expect to graduate. Learning is a never-ending process, or at least is should be. Taking breaks from learning is a good idea, but calling it quits is not. My mother used to tell me: What counts most is what you allow yourself to learn after you think you know enough. While attending the COMMON Annual Meeting and Exposition a couple of weeks ago in New Orleans, I met with Kevin Mort and Manzoor

  … Read more

• Mad Dog 21/21: Qubit’s Rubes

  June 6, 2016 Hesh Weiner

  In May, IBM said it would give the public a free taste of quantum computing: IBM is providing free access to a five-qubit quantum processor in the cloud, surrounded by support facilities to enable friendly experimentation. The offering has garnered a lot of favorable press coverage. This stunt is reminiscent of the unveiling of Angler, an augmented cell phone first shown at Comdex in 1992 to press acclaim. Two years later, in August 1994, Angler had evolved into an actual IBM product, the Simon Personal Communicator. Six months and 50,000 units later, Simon was gone. IBM Simon:

  … Read more

• Modernization Prioritization Based On Observation

  June 6, 2016 Dan Burger

  Amidst all the chatter in the IBM midrange community, nothing rises above the catch-all category of modernization. Just about anything that’s done to the system, including brushing the dust off an old AS/400, seems to qualify as modernization. But, after separating the wheat from the chaff, there is real modernization being done and with it comes the realization that the IBM i is as modern as you allow it to be. After years of Earl Scheib paint jobs–We’ll paint your car for $99–modernization efforts have become better planned, better executed, and better suited for a future that extends

  … Read more

Previous Articles Next Articles