• Guru: SQL and QTEMP

  January 4, 2021 Ted Holt

  Hey, Ted.

  For many years IBM i developers, operators, and others have taken advantage of an operating system feature called the QTEMP library. Through the years you have referenced it various times in IT Jungle as a useful feature of IBM i. I recently read an article in which a respected IBM expert from the Rochester lab services team told people not to use the QTEMP library when working in SQL. It would be very interesting if you could dive into this topic and explain when/if there is still a time and place for QTEMP. I think a lot of …

  Read more

• X Marks The Spot For CYBRA’s Forms Software

  December 14, 2020 Alex Woodie

  When it comes to creating forms and labels on the IBM i server, CYBRA’s MarkMagic is one of the most frequently used products in the market, and is used by the biggest companies in consumer goods and retail. With the latest release of MarkMagic X, the company is finding new and creative ways to get additional functionality into the hands of its users.

  MarkMagic X, which is also called version 10, introduces a host of new features that have been requested by CYBRA’s sizable installed base. With over 30 years in business, CYBRA has amassed 2,700 customers, including nine …

  Read more

• The Ultimate Set Of Tools

  December 14, 2020 Rob McNelly

  Those of a certain age will certainly remember the moment in Fast Times At Ridgemont High when Jeff Spicoli got himself into a bind after he wrecked his friend’s car. Luckily, Spicoli’s dad was a TV repairman, and he had an ultimate set of tools. Spicoli knew that with those tools, he could fix it. That level of confidence is intoxicating, although in this case it was possibly misplaced.

  I have a friend that lives around the corner from me that actually does have the ultimate set of tools, and knows how to use them. For example, he recently rebuilt …

  Read more

• VS Code Provides Another Coding Option for IBM i

  December 9, 2020 Alex Woodie

  IBM i shops that are looking for an alternative to IBM’s Rational Developer for IBM i (RDi) may want to check out a lightweight code editor from Microsoft called Visual Studio Code (VS Code). Thanks to extensions for IBM i languages developed by the opensource community, VS Code can support native development in RPG, CL, and SQL.

  First released by Microsoft in 2015, VS Code provides a basic environment for writing and editing code. It features debugging, syntax highlighting, intelligent code completion, snippets, and code refactoring, as well as embedded Git. It runs on Windows, Linux, and Mac, and while …

  Read more

• New Release Of ACS Now Available

  December 9, 2020 Alex Woodie

  IBM delivered a new release of Access Client Solutions (ACS) last week, right on schedule. With ACS version 1.1.8.6, users will find a host of new features designed to accelerate their productivity across a range of uses.

  ACS is the Java-based utility that has become one of the most used (and useful) ways that administrators, programmers, and engineers can interact with the IBM i server. The software, which is free to IBM i customers on maintenance, features a 5250 emulator, 5250 printer emulation, data transfer capabilities, IFS file viewing, spool file management, and a virtual console for LAN and HMC …

  Read more

• Swedish Manufacturer Plans A New Path Forward

  December 2, 2020 Alex Woodie

  The Swedish manufacturing company Dahrentrad knew its S/36-era production planning solution was getting a bit long in the tooth. The question was, what should the company do about it? Migration and modernization were weighed as the two primary options, but which was the better path?

  A subsidiary of LWW Group, Dahrentrad specializes in producing copper and aluminum wiring used in electrical motors, pumps, transformers, and other industrial and automotive components. The 75-year-old company runs factories in Sweden, Germany, and Poland.

  The company relied on an old but reliable business application that utilized 5250 greenscreen interfaces, according to Mats Lidström, …

  Read more

• Guru: SQL Writes CL

  November 30, 2020 Ted Holt

  SQL is the one tool I cannot work without. Take it away from me and I’ll start driving a truck for a living. Naturally I’m eager to find more ways to make SQL work for me. Today I’d like to share how I recently used SQL to write a huge CL command for me. This is a technique that’s good to know.

  My challenge was to copy all of the several hundred physical data files in a library to a save file so that those files could be loaded onto another IBM i system. The Save Library (SAVLIB) command was …

  Read more

• Additions To The Db2 Web Query Family

  November 9, 2020 Alex Woodie

  Change is in the air for Db2 Web Query, the primary business intelligence tool for IBM i environments from Big Blue. Earlier this year, IBM launched two new versions of the product, and this fall, IBM delivered version 2.3 of the product. Finally, there’s been a change of ownership of the third-party company behind the software.

  Let’s start with the change in ownership. Last month, TIBCO Software announced its intent to acquire Information Builders, the privately held New York City business intelligence software company that Gerald Cohen founded way back in 1975. IBI’s primary product is WebFOCUS, which forms …

  Read more

• IBM Delivered An RDi Update, Too

  November 4, 2020 Alex Woodie

  Next week, IBM is planning to deliver the PTFs that include the functionality contained in the Technology Refreshes it just unveiled for IBM i 7.3 and 7.4 last month. You will want to stay on the lookout for those updates. But some of the capabilities that IBM “announced” in the TRs shipped months ago, including those for Rational Developer for i (RDi).

  The latest release of RDi, or version 9.6.0.8, was included as a feature for IBM i 7.3 TR9 and IBM i 7.4 TR4. IBM, of course, announced those TRs on October 6 and says it plans to …

  Read more

• Guru: SQL and Expanding Subfiles

  October 26, 2020 Ted Holt

  I’ve heard it said on more than one occasion that SQL does not work as well as record-level access (RLA) when loading subfiles. I understand why people feel that way. They’re usually thinking about repositioning to a key value, and there is no SETLL (Set Lower Limit) op code in an SQL cursor.

  Yet I think SQL is better, and today I’d like to share one case that I think presents a good illustration. I had in mind the expanding subfile. There’s a parallel between the two. Consider:

  • Every time you clear the subfile, you open a new cursor.
  • Every

  …

  Read more

Previous Articles Next Articles