• View Scheduled Jobs with Excel

  April 19, 2016 Ted Holt

  At the recent RPG & DB2 Summit in Dallas, I presented a session that dealt with the use of SQL in CL. One of my examples used the SCHEDULED_JOB_INFO view to retrieve scheduled jobs from the IBM i job scheduler. After the talk, one of the attendees gave me a great idea, and I’ve just got to pass it along to you. SCHEDULED_JOB_INFO returns the same information that you can see with the Work with Job Schedule Entries (WRKJOBSCDE) command. It’s one of the IBM i Services. The gentleman told me that he and others in his shop had been

  … Read more

• Surge of Services in DB2 for i, Part 2

  April 19, 2016 Michael Sansoterra

  Continuing where we left off in Part 1, a slew of new IBM i services (and enhancements to existing services) were released in IBM i 7.2 TR3 and IBM i 7.1 TR11. This article continues to detail some of the important new services. As always, keep in mind that just an overview is given here and that the developerWorks documentation or IBM i Services in the Knowledge Center should be consulted in order to understand the full capability of each service. SYSTOOLS.GROUP_PTF_DETAILS This view runs a real-time query against the IBM Preventative Service Planning (PSP) website and can indicate

  … Read more

• We Can Just Barely See RPG In i 7.3

  April 18, 2016 Dan Burger

  Just another day in RPG paradise. No place we’d rather be. Kicked the old fixed-format habit and have gone free. Embedded SQL and integrated XML. Got RDi wired. You’re totally modern, so what’s next? Well . . . if you’re looking for RPG fun in i 7.3, you’ll be mostly disappointed. The IBM shopping cart isn’t empty, but that loaf of bread and a package of baloney isn’t the rib-eye steak we were hoping for. In case you missed it, the steak was delivered with the IBM i 7.2 TR 1 release in the fall of 2014, which was also

  … Read more

• As I See It: He Loves Me, He Loves Me Not

  April 18, 2016 Victor Rozek

  The sheer magnitude of the math first caught my attention. It was an article I came across called 19 Signs Your Employer Doesn’t Care About You. Nineteen, mind you! Not the usual 3 or 7 or even the venerable Top 10; someone actually dredged up 19 different indications that a stranger–who they only glimpse professionally–may not be their most ardent admirer. OK. Just because you’re paranoid doesn’t mean they don’t dislike you. But let’s face it, you have to break a sweat to think up 19 tells that prove someone doesn’t give a rat’s thumb drive about you. Most

  … Read more

• DB2 Web Query For i Now Supports External Databases

  April 18, 2016 Alex Woodie

  New OLAP and temporal data capabilities in DB2 headlined the launch of IBM i 7.3. But those weren’t the only analytic functions delivered last week by IBM. Tucked inside the announcements was a new release of DB2 Web Query for i that will make it easier to bring data from outside databases into an IBM i-based data warehouse. IBM is including new data adapters with DB2 Web Query for i Standard Edition version 2.2 that support PostgreSQL, MariaDB, and MySQL. The new release also includes support for generic Type 4 JDBC drivers, which will make it easier to get

  … Read more

• IBM i Strategy And Roadmap Loses Business Focus

  April 18, 2016 Dan Burger

  A white paper is supposed to help readers understand challenges and provide an objective discussion of problems and solutions. It should not be a thinly disguised image enhancement device. Do that once and it rains on all your subsequent white papers. We all would like to see IBM sell more IBM i servers. But after reading the latest white paper on IBM i, it misses the mark of a real white paper. Let me start by giving you a link where you can download this document titled the IBM i Strategy and Roadmap. I recommend everyone read it. It

  … Read more

• Sundry April Power Systems Announcements

  April 18, 2016 Timothy Prickett Morgan

  As we reported last week in discussing IBM‘s Power processor roadmap for the next five-plus years, there is not going to be a Power8+ revamp of existing Power Systems machines. Instead, IBM has rejiggered the Power8 chip to create a variant aimed at supercomputing and deep learning workloads that allows for high-speed NVLink coupling between Nvidia “Pascal” Tesla GPU coprocessors and the Power8 chip. That means there is no performance boost or list price cut (or both) that is normally expected and delivered with a “plus” variant of the Power chips. But as we expected, IBM has made a

  … Read more

• OpenLegacy Partners with ‘Nearshore’ IT Services Provider Softtek. . . Linoma Adds 2FA from RSA to GoAnywhere MFT Suite. . . RVI Partners with Accounting Software Maker. . .

  April 13, 2016 Timothy Prickett Morgan

  OpenLegacy Partners with ‘Nearshore’ IT Services Provider Softtek OpenLegacy, a provider of legacy modernization solutions for IBM i and mainframe shops and their applications, this month unveiled a partnership with Softtek, a provider of outsourcing services headquartered in Mexico. The partnership gives OpenLegacy customers access to the development resources of Softtek, a Monterrey-based IT services provider with 30 offices around the world, including United States, Mexico, Brazil, Argentina, Spain, China, and India. The company, which trademarked the term “Global Nearshore,” positions itself as a closer provider of outsourced IT services than those based in India. “Our strategic partnership

  … Read more

• WOW Makes a Good Database Story

  April 13, 2016 Dan Burger

  Those who do more with less get rewarded. Sometimes the incentive is a raise or a bonus. Sometimes it’s just being able to keep your job. Either way, you could be surprised what can be accomplished in terms of business intelligence, graphical presentations, and modernization with a relatively unknown product called WOW, which is the name of the Web application development tool from PlanetJ. WOW, an abbreviation for Web Object Wizard, was designed to extract data in real time from relational databases, including DB2 for i and all the other enterprise databases of note, while generating the kinds of

  … Read more

• How InterForm Simplifies XML Document Handling for IBM i

  April 13, 2016 Alex Woodie

  At the turn of the century, extensible markup language (XML) promised to simplify many data interchange tasks for IT professionals. Sixteen years later, XML is firmly part of the technological menagerie in the United States, but nowhere near a universal standard. However, over in Europe, XML is a much bigger deal, which is why InterForm added significant new XML capabilities in the latest release of its IBM i-based forms package. Supporting XML isn’t just a good idea for companies who deal with clients in Europe. In many cases, it’s the law, says InterForm CEO Peter Sørensen. “In Europe almost every

  … Read more

Previous Articles Next Articles