• IBM i PTF Guide, Volume 21, Number 5

  February 6, 2019 Doug Bidwell

  In the latest iteration of the IBM i PTF Guide, you will see that there is a new Database Group for IBM i 7.3. Also, you will find that IBM Navigator for i is affected by the security vulnerability that is posted in CVE-2019-4040, which you can read about more at this link. The patches relating to this security vulnerability are handled by latest group for the HTTP server for IBM i 7.2 and 7.3.

  As for new links in the Guide  this week, there are none as yet – I am still catching up.

  Here is a …

  Read more

• Guru: Create A UDTF Wrapper For A Stored Procedure Result Set

  February 4, 2019 Michael Sansoterra

  In the tip, Arranging Query Logic in DB2 for i Routines, I addressed a reader’s question about how to create a user-defined table function (UDTF) in DB2 for i that would return the same result set as an existing stored procedure. The purpose of having the UDTF would be to do additional processing on a result set, such as joining the result set with another query or dumping the result set to a temporary table for analysis. To accomplish this, I suggested moving the stored procedure query logic into a UDTF and then replace the query within the stored …

  Read more

• Guru: Arranging Query Logic in DB2 for i Routines

  January 7, 2019 Michael Sansoterra

  Hey, Mike:

  We use a stored procedure to return the result set to Java and display the results to a screen. I would like to make this stored procedure put the result set into a temporary table and then do some processing on the temporary table. Is this possible and if so how can I achieve this? Thanks.

  Your dilemma is understandable: stored procedure result sets are great when data needs to be returned to a client. However, once generated, the result set cannot be joined, sorted, or stored in a temporary table. Thankfully, a user-defined table function (UDTF) allows …

  Read more

• For Entry IBM Shops, Power9 Is About Performance And Security

  December 10, 2018 Timothy Prickett Morgan

  Buying new systems costs money, often a lot of money relative to the size of the overall IT budget and the revenue and profit streams of the companies for which they work and, in essence, actually embody what that company really is. So in a sense, systems are always worth the money if they are actually letting people do their work properly.

  That said, there is always an argument to be made for doing an upgrade – often actually a migration because the system itself cannot easily or economically be upgraded – and another set of arguments for waiting a …

  Read more

• The Impact On IBM i Of Big Blue’s Acquisition Of Red Hat

  October 31, 2018 Timothy Prickett Morgan

  Well, we can honestly say that we did not see that coming when IBM and Red Hat announced late last Sunday afternoon that Big Blue would be shelling out $34 billion to acquire the world’s most successful business that peddles support for open source infrastructure software.

  Ironically, at the time I happened to be writing about how IBM and Red Hat had just announced that they had brought the OpenShift Container Platform, a mashup of Docker and Kubernetes, to Power Systems machines running Linux, and I was lamenting that it was not trivial to figure out how to integrate …

  Read more

• Guru: Phonetic Functions In SQL, Part 2

  September 24, 2018 Paul Tuohy

  In my previous article I discussed the use of the standard SOUNDEX and DIFFERENCE functions for phonetic processing. I also identified the major problems with SOUNDEX (based on U.S. English and the first character is static) and DIFFERENCE (loose because it is based on SOUNDEX).

  In this article I will discuss how to tackle these problems by writing a customized phonetic function to use in place of or in conjunction with SOUNDEX. The good news is that you do not have to become an expert in phonetics — others have already done the job for you. There are a number …

  Read more

• Guru: Table Value Constructors Build Tables On The Fly

  June 25, 2018 Ted Holt

  Because I wish to be as valuable and productive as possible to the people who pay me to program their computers, I continually search the Web for new ideas and techniques. Doing so often leads me to sites that cater to other computing platforms. Today I want to share with you some SQL techniques that I learned from Microsoft SQL Server professionals.

  These techniques are based on the Table Value Constructor (TVC), which is a group of data values, usually literals, organized into rows and columns. In its simplest form, a table value constructor is literal tabular data that is …

  Read more

• IBM Patches ‘ROBOT’ Flaw in IBM i Crypto Library

  February 21, 2018 Alex Woodie

  IBM has issued patches to fix a serious security problem in the IBM Global Security Kit, or GSKit, a relatively obscure crypto package that implements SSL/TLS encryption algorithms across a variety of IBM products, including IBM i. An old flaw in the underlying RSA crypto algorithm that could let hackers decrypt data in a “side channel” attack has resurfaced under a new moniker: “ROBOT.”

  GSKit is an IBM toolkit that implements various encryption-related functions, including symmetric and asymmetric ciphers, random number generation, hashing algorithms, and encryption key management capabilities, for products that need over-the-wire encryption, including IBM i, Linux, and …

  Read more

• Should Spark In-Memory Run Natively On IBM i?

  November 6, 2017 Alex Woodie

  There’s a revolution happening in the field of data analytics, and an open source computing framework called Apache Spark is right smack in the middle of it. Spark is such a powerful tool that IBM elected to create a distribution of it that runs natively on its System z mainframe. Will it do the same for its baby mainframe, the IBM i?

  So, what is Apache Spark, and why should you care? Great questions! Let’s introduce you to Spark.

  Spark came out of UC Berkeley’s AMPLab about five years ago to provide a faster and easier-to-use alternative to MapReduce, which …

  Read more

• Guru: Logging SQL Errors And Warnings

  October 30, 2017 Birgitta Hauser

  If something goes wrong with an embedded SQL statement or an SQL routine (a trigger, stored procedure or user-defined function), the system does not crash. Instead, DB2 returns a negative SQL code and an SQL state that starts with something other than 00, 01, or 02. If the routine does not handle the error, the program continues to run.

  It is good practice to log errors to a table, especially unexpected ones. Before you can log any errors, you need to know how an SQL error can be trapped and handled. You need to know how to write a condition …

  Read more

Previous Articles