Views for Query/400!

Hey, Howard:

I have a new challenge. I have a table with suppliers and parts, and more than one supplier may provide the same part number, as well as others. So from the supplier's point, it's a one-to-many relationship. I need to determine how to select only those parts provided by more than one supplier, in SQL or Query/400, if possible. I've tried to do this several ways, including joining a file to itself, but I don't end up with the way I'd like to have it presented to me, for easy analysis.

READ MORE >

Alternate Methods for Returning Data Structures from Subprocedures

I have a concern with Steven Gray's technique [see "Returning a Pointer to a Data Structure from a Function"] using %STR to enable returning a pointer to a data structure: If there are UCS-2, packed, or integer fields in the data structure, it is highly probably that any fields following those fields will be skipped by %STR, because these data types frequently contain x'00' as part of their byte value. If a maintenance programmer unfamiliar with pointers added a subfield of one of those types, the mystery of the missing subfield data would be very difficult to solve.

READ MORE >

Reader Feedback and Insights: Why People Ask Basic Questions

Hey, Ted:

I don't think people are coming to or going out of any platform. The basic problem is that companies are forcing programmers to work on multiple platforms. Companies now do not care about what your skill is; you need to either satisfy business requirements or leave. They don't really care if you use Visual Basic or Java or RPG or Shell script. The result is "learning on demand."