• 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

• Visual Data Exploration Comes To Db2 Web Query

  October 18, 2017 Alex Woodie

  The IBM i server isn’t known as an analytics powerhouse — transaction processing is more its thing. But with the latest release of Db2 WebQuery for i, customers are getting visualization capabilities that will let them explore their data in powerful new ways.

  IBM announced Db2 Web Query for i version 2.2.1 on October 3 as part of its Technology Refreshes (TRs) for IBM i 7.2 and 7.3. While the release number would seem to indicate a minor update, the improvements are actually quite substantial, says Robert Bestgen, IBM’s product development manager for Db2 Web Query.

  “We kind of moved …

  Read more

• IBM Adds Support For Publishing JSON In DB2

  October 4, 2017 Alex Woodie

  At long last, IBM i shops will be able to publish JavaScript Object Notation (JSON) documents from their Db2 for i database. That much-desired capability will finally arrive as part of the latest Technology Refreshes (TRs) for IBM i versions 7.2 and 7.3, which were announced yesterday and ship this month. New SQL commands and security log enhancements round out the release.

  The capability to publish JSON documents has been a long time coming for IBM i shops, who until now have had to content themselves with the capability to consume and store JSON within their database, but who lacked …

  Read more

Previous Articles Next Articles