• Settling In With IBM i For The Long Haul

  February 11, 2019 Timothy Prickett Morgan

  If nothing else, the IBM i platform has exhibited extraordinary longevity. One might even say legendary longevity, if you want to take its history all the way back to the System/3 minicomputer from 1969. This is the real starting point in the AS/400 family tree and this is when Big Blue, for very sound legal and technical and marketing reasons, decided to fork its products to address the unique needs of large enterprises (with the System/360 mainframe and its follow-ons) and small and medium businesses (starting with the System/3 and moving on through the System/34, System/32, System/38, and System/36 in …

  Read more

• More IBM i Predictions For 2019

  February 6, 2019 Alex Woodie

  We kicked off our 2019 soothsaying last week with predictions from IBM i leaders on what the New Year will bring. We keep the ball rolling this week with another batch of predictions from our friends around the IBM i community.

  According to Alison Butterill, IBM‘s the program director for offering management for IBM i, the platform will build off the momentum generated with last year’s 30th anniversary celebrant.

  “The excitement begun in 2018 as we highlighted client innovation around the world will continue into 2019,” Butterill says. “The momentum continues to grow as clients are looking at ways …

  Read more

• IBM i Has Been Getting With The Program For Years

  February 4, 2019 Timothy Prickett Morgan

  There are many things that one could constructively criticize IBM about when it comes to the Power Systems platform running the IBM i operating system. But, in recent years at least, one of those things would not be – and could not be – that the company has not done enough to embrace the most important elements of the modern programming toolbox.

  In fact, the company has done and increasingly good job of embracing and extending the compilers, interpreters, frameworks, and models of the programming languages that have gone mainstream since Java first took the stage at the beginning of …

  Read more

• One Repository To Rule The Source – And Object – Code

  February 4, 2019 Floyd Del Muro

  (Sponsored Content) The concept of a single repository for source is not necessarily a new one. When I interviewed with ARCAD back in 2011, I did so at the at the Rational conference called Innovate in Orlando. The research and development team and our chief technology officer were already in dialogue with IBM to resell ARCAD technology alongside its Rational development suite, adding power to Rational Team Concert that development organizations could effectively have a similar repository for IBM i and open source applications.

  At the time, RTC supported the open source world very well, just like Git …

  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

• IBM Delivers New Goodies with ACS Update

  December 5, 2018 Alex Woodie

  IBM has issued a new release of Access Client Solutions (ACS), the indispensable Java-based client that delivers a range of functionality to administrators, developers, and users alike. In the new release of ACS, IBM delivers enhancements across a range of functions, including SQL queries, database schemas, data transfer, and printing and emulation.

  IBM first unveiled ACS way back in August 2012 as the strategic replacement for older IBM i client interfaces, such as Access for Windows, Access for Web, and Access for Linux. With a full 5250 emulator, support for printing, the capability to view IFS, spool file, and message …

  Read more

• High Schools: The New Recruiting Grounds for IT Jobs

  November 28, 2018 Alex Woodie

  Companies that are having trouble filling entry-level IT jobs due to the tight job market and low unemployment rate may want to check out another resource for finding and attracting workers: their local high school.

  Recruitment, retention, and training of new talent are always hot topics during the roundtable discussions that take place at the CIO Summit. “It’s always a very fruitful and productive topic to see what CIOs are doing,” says Alan Seiden, who has been running the bi-annual event for IBM i tech executives for the past year-and-a-half.

  So when one of the CIOs at last month’s …

  Read more

• Is Nagios The Future Of Monitoring For IBM i?

  November 12, 2018 Alex Woodie

  For decades, technology professionals turned to established frameworks from IBM Tivoli, CA, Hewlett Packard, and BMC (“The Big Four”) to monitor their hardware and software stacks. But the open source world has caught up with those closed monitoring environments, and a project dubbed Nagios is poised to be the go-to platform for IT monitoring, including on IBM i.

  Nagios, if you are not familiar, is a free and open source software product that provides monitoring and alerting for servers, network gear, applications, and the array of services that organizations increasingly rely on. The software –backed by the obligatory recursive acronym …

  Read more

• Modernizing IBM i Apps with Microservices

  November 7, 2018 Alex Woodie

  Application modernization means different things to different people. For some, it could be turning a 5250 screen into a Web or mobile interface, or replacing database access with SQL. But for others in the IBM i community, including the vendor OpenLegacy, modernization refers to exposing existing business logic as APIs through a microservices architecture.

  Microservices refers to a software development technique whereby applications are broken down into multiple self-contained components and served via APIs in a loosely coupled but coordinated manner. The main advantage of this approach is each microservice is built independently of others, which can boost productivity and …

  Read more

Previous Articles Next Articles