Reader Feedback and Insights: Dynamic Result Field in Query/400

October 16, 2002 Timothy Prickett Morgan

Hey, Ted:

Some time ago I ran into a situation similar to the one described in Midrange Guru by Bruce and Bill: I also needed to generate a result field from a dynamic expression.

I solved the problem by generating the whole Open Query File (OPNQRYF) command on the fly and then using QCMDEXC to run it.

These days I use RPG IV to generate the command. It is much easier than using RPG III.

— Eitan

Sponsored By ADVANCED SYSTEMS CONCEPTS

SEQUEL meets all your iSeries and AS/400 data access needs in a single, integrated solution: Windows, Web

Sorting Lists in Java

October 16, 2002 Timothy Prickett Morgan

Hey, David:

I have a servlet program that builds a list of products. I have several ways of sorting the list of products, and in most cases, I can just change the order by clause in my select statement to return the correct order. In one view, I need to sort the list by the length of a product component name. I built my own sort routine, but I wonder whether SQL or Java provides a way to sort a list of items by their length.

— Michael

You could use a universal disk format (UDF) to return a value

Extending the Network

October 16, 2002 Timothy Prickett Morgan

Hey, Ted:

Our company recently acquired a small company with its own network, on which it uses Microsoft Terminal Server to host the client applications. Our AS/400 is at V4R3, and our Client Access is V3R2. Can we use the Terminal Server to extend the AS/400 green screens to the other network?

— Greg

Yes, that will work. I checked with several of my associates, and all of them strongly recommended you upgrade to newer versions of OS/400 and Client Access as soon as possible.

— Ted

Sponsored By inFORM DECISIONS

ELIMINATE THE COSTS OF PRE-PRINTED FORMS, LABOR AND POSTAGE