The Four Hundred Archives - Page 335 of 1507

TEMBO Adds Development Tool to Database Modernization Kit

August 17, 2016 Alex Woodie

TEMBO Technology Lab is beefing up its DB2 for i modernization solution. The South African provider of DB2 for i database modernization solutions has reached an agreement with Relational Data to resell its rapid application development tool for IBM i as part of its core Adsero Optima (AO) suite.

Based in West Jordan, Utah, Relational Data is a longtime provider of IBM i-based applications and tools to the education market. Its OnePoint suite of software automates a range of processes for schools, including recording grades, managing student and parent data, and streamlining back-office functions like operations, HR, and finance.

The

…

Cilasoft Offers No Cost Job Log Exploration Tool

August 17, 2016 Dan Burger

The IBM i equivalent of a mountain avalanche is the job queue file. It’s a mass of files with the potential to eventually bury system admins as they search for good jobs that have gone bad. When job logs are thousands of pages in length and contain many similar entries, the search for specific troublesome job logs can become tedious, aggravating, and time consuming. About this time, users start wishing for a tool that efficiently sorts job log information.

You might happily pay for a tool that reduces the amount of time it takes to track down jobs that are

…

Overlaid Packed Data In Data Structures

August 16, 2016 Jon Paris

Note: The code accompanying this article is available for download here.

Sometimes things that should be simple give us difficulty. Jon Paris recently helped a Four Hundred Guru reader to solve a problem with overlaid packed-decimal data in data structures. We’re sharing their conversation for the benefit of others.

Hi, Jon:

My question has to do with overlaid packed-decimal data in a data structure. I store a date in CYMD format in a seven-digit, packed-decimal field. I am trying to extract the two-digit year from that.

Dcl-Ds cymdDate;
   currentDate  packed(7);
   currentYear  packed(2) overlay(currentDate:2);
End-Ds;

When I set

…

How To Insert With A Common Table Expression

August 16, 2016 Hey, Ted

I have to merge some new item numbers into our item master file. The problem I’ve run into is that there is more than one record for some items. None of the examples I found on the Web work for me. How do I write an SQL statement to copy all records from one file to another avoiding duplicates on part number?

–Trent

This is a new wrinkle on a challenge about which I have written before, namely the need to select only one row (record) to represent a group. (See the Related Stories below.) The wrinkle is that not

…

Assorted DB2 for i Questions

August 16, 2016 Michael Sansoterra

Shown below are assorted questions related to DB2 for i. If you have a question you’d like Four Hundred Guru to try to answer, be sure to visit the IT Jungle Contact page. Note that some of these questions were modified from their original form for clarity and simplicity.

Adding an attribute to an element based XML

Q: The FHG tips on composing XML documents from DB2 data (Part 1 and Part 2) do not describe how to add a custom attribute to element based XML. Consider the following query:

SELECT XMLAGG(
       XMLROW(NAME as "Name",
              Color as "Color",

…

IBM i Requirements: It’s About (To) Change

August 15, 2016 Alex Woodie

Have you ever wondered how IBM comes up with ideas for how to improve the IBM i platform? According to the IBM i chief architect Steve Will, the most strategic ideas originate internally within IBM. However, many new features come from the customer base through formal requirements processes. And this fall, IBM intends to launch a new requirements program that will allow users to vote on new features over the Web.

There are currently four formal requirements programs that feed ideas for new IBM i features to IBM. These include the COMMON Americas Advisory Council (CAAC), COMMON Europe Advisory Council

…

Talking Modernization With Profound Logic

August 15, 2016 Timothy Prickett Morgan

Modernization, in its many guises, seems to be a big driver of the IBM i ecosystem these days. For a long time, high availability software was major propellant diving the market alongside System/38 and System/36 upgrades–a kind of modernization effort in its own right. Then along came the ERP wave in the 1990s, and packaged software is all the rage. Now, the diehard IBM i faithful need to update their code to work with modern devices and to look and feel like other modern software, and they need some help.

A programmer or two using good tools are perhaps better

…

No Seats At Cruikshank’s SQL Database Sessions

August 15, 2016 Dan Burger

Dan Cruikshank’s presentations at the OCEAN Tech Conference last month were packed. Conference attendees had plenty of session options running opposite of Cruikshank, but his topics enticed IBM i advocates like free ice cream cones in the park on the Fourth of July. The seats are filled by folks hungry for technical advice on SQL, database efficiency, and business value. He gave them sessions on database re-engineering, reusable SQL procedures, modernizing IBM i applications, and data-centric programming.

Based on “hands-up” session surveys during similar sessions he presents around the world, Cruikshank is convinced that programmers are increasing their efforts to

…

Mad Dog 21/21: Vulcan’s Fury

August 15, 2016 Hesh Wiener

When Vulcan gets riled, steer clear of volcanos. Be nice. Show him some respect. Admire his metalworking skills. Celebrate his holiday, Vulcanalia, on August 23. Don’t hurt Vulcan’s feelings as Pompeii apparently did. In 79 AD, Pompeii was buried alive in ash and lava. Vulcan is obviously implicated: Vesuvius erupted on August 24, right after Vulcanalia.

IBM, which has supported a huge study of Pompeii’s destruction, should know better than to trifle with Vulcan. But Big Blue has been vexatious, deprecating the hardware business. Vulcan is surely offended; he could strike at any moment. Watch out!

Pompeii And

…

New Round Of Enhancements For Access Client Solutions

August 15, 2016 Dan Burger

With every Technology Refresh there are new features and functions added to IBM i Access Client Solutions (ACS) that make the official announcement list. But in reality, ACS upgrades also occur in between TRs with their announcement held off until the next TR. On July 31, the latest batch of ACS enhancements became available as a download on the IBM i Access webpage. ACS replaced the legacy Access for Windows several years ago.

Like the traditional Access products, IBM i Access Client Solutions is primarily used for 5250 emulation, but is also popular for accomplishing data transfers, printer output,

…

Previous Articles Next Articles

Search for:

Content archive

The Four Hundred
Four Hundred Stuff
Four Hundred Guru

Content archive

Recent Posts

Subscribe

Pages

Search