• A Second Look At SQL Descriptors

  July 19, 2016 Paul Tuohy

  Note: The code accompanying this article is available for download here. My previous article, A First Look at SQL Descriptors, looked at how SQL descriptors can be used in constructing and processing dynamic SQL statements. This article examines how SQL descriptors can be used in processing the information returned through a dynamic SQL statement. As an example, we will write a program that dynamically constructs the select clause in an SQL select statement. Traditionally, this would cause us a problem in our RPG programs since we would not be able to code the INTO clause correctly. We have

  … Read more

• New OLAP Aggregate Functions In DB2 for i, Part 1

  July 12, 2016 Michael Sansoterra

  In my last tips about the new OLAP features in DB2 for i 7.3, I discussed the OLAP Aggregation Specification and the new LAG and LEAD OLAP functions. In this article and the next one, I continue the discussion of new OLAP features by highlighting four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE, and RATIO_TO_REPORT. The value of these functions is that they can reference data from other rows in a query result set relative to the current row. The new OLAP aggregate functions differ from normal aggregate functions (such as MIN, MAX, SUM, and AVG) in that they can

  … Read more

• Formatting Dates With SQL, Take 3

  July 12, 2016 Ted Holt

  This story contains code, which you can download here.   I love it when someone improves something I’ve produced. In this case, that someone was Barry Arnold, an A-1COBOL programmer with whom I had the privilege to work once upon a time. Barry improved my FMTDATE SQL function for use in his shop. Maybe his enhancement will help you, too. Barry’s shop, like many others, must deal with data from many different sources, and that data is often formatted in ways that are not conducive to RPG and COBOL programming. Barry found himself having to de-edit character dates before

  … Read more

• A Generic Character Editing Routine

  July 12, 2016 Jon Paris

  Note: The code accompanying this article is available for download here. Recently I was asked if I knew of a way to edit character strings. For example, take a character string representing a product code such as “AX12345Q” and edit it to produce “AX-123-45 Q”. My initial reaction was to reach for an edit word, but sadly they only work for numerics, for some strange reason. I set about building a subprocedure that offered the necessary flexibility in insert characters and also added a few “defenses” against mismatched parameters. Before describing the code, let’s look at the prototype for

  … Read more

• Maxava Opens Up Bidding For iFoundation Grants

  July 11, 2016 Timothy Prickett Morgan

  For the sixth year running now, high availability software maker Maxava is putting its money where its mouth is in the IBM i community and donating a big bag of cash through its Maxava iFoundation to causes that benefit the maintenance and expansion of the IBM i community. Maxava launched its first iFoundation grants back in April 2011, promising to pay up to $50,000, in increments of up to $2,000 a pop, to organizations in the IBM i community that could use a little extra help in fulfilling their missions. Every little bit helps, in the first year $45,000

  … Read more

• Cloud-Based Email Migrations Keep IBM i Vendor Busy

  July 11, 2016 Dan Burger

  As more businesses migrate email services from desktops to the cloud, users at IBM i shops look for the tools that allow them to work quickly, efficiently, and securely. You can’t stay mired in the past. You have to adapt. That’s what BVSTools has done with its latest enhancement of GreenTools, which integrate with Microsoft Office 365’s Outlook and Google‘s Gmail for Business, two popular business email options. “We are noticing a lot of our current customers, when moving to the cloud for email, are choosing Microsoft Office 365 in greater numbers than those using Google’s Gmail for Business

  … Read more

• IBM i Open Sourcerers

  July 11, 2016 Dan Burger

  Who will inherit the IBM i? And what will that business computer look like? My crystal ball is in the shop, so I’ll have to rely on what is currently going on and make some projections based on that. Collaboration would seem to be the key. Even without my crystal ball, I see new technologies being explored and applied. For IBM i to be relevant to future generations, open source software and the collaboration with other innovation teams needs to take place. Development of the IBM i platform is not happening on its own island anymore. It’s an integrated world.

  … Read more

• IBM i Skills Shortage A Barrier To Digital Transformation

  July 11, 2016 Alex Woodie

  Quick–what’s the top barrier to achieving digital transformation in your shop? If you said “IBM i skills,” then you’re in good company. In a recent informal poll conducted by SoftLanding Systems, a majority of IBM i professionals cited a lack of IBM i skills (taken to mean RPG programming expertise in particular) as the number one impediment to implementing projects such as development of Web and mobile interfaces and electronic document management. SoftLanding operations manager Jim Fisher admitted that he wasn’t expecting a lack of IBM i skills to be the number one answer to a question about barriers

  … Read more

• What Price Power (Eight And Maybe Nine)?

  July 11, 2016 Timothy Prickett Morgan

  Call me old school if you want, but I believe in Moore’s Law and I believe that IT vendors have to keep giving customers more bang for the buck if they want organizations to keep investing in technology. There are basically only two levers to help push a new technology into the market, and that is increasing the performance of a device or lowering its price, the latter hopefully occurring if the cost of production comes down but sometimes not as vendors seek to maximize their profits and make it up with performance leaps. This has certainly been the case

  … Read more

• Flynet Pivots To Catch IBM i Web Business In U.S.

  June 27, 2016 Alex Woodie

  There’s scarcely any new project for the IBM i these days that doesn’t involve the Web in some way, shape, or form. Mobile front-ends, application modernization, Web services–heck, even the lowly terminal emulator has become a Web app these days. One IBM i software vendor that is positioned to capitalize on this trend is Flynet, which sells a single product that can address multiple Web initiatives for IBM i shops. You may have never heard of Flynet, but the company, which is based in the United Kingdom, is by no means new to this sector. In fact, Flynet has

  … Read more

Previous Articles Next Articles