Retrieving Query Definitions

July 31, 2002 Timothy Prickett Morgan

Hey, Ted:

You mentioned in your article, “Print Query Definitions from a Batch Job,” in the May 22 issue of Midrange Guru, OS/400 Edition, a way of getting print definitions of Query/400 queries by using a process of RUNQRY and PRTDEF(*YES). This method didn’t help me much; I had too many queries and that meant too much processing time. I had to resort to manually printing the query definitions to an output queue, typing option 6s while in WRKQRY for each library. I was about to do the same for Query Management queries but I found the

SQL Understands Microseconds

July 31, 2002 Timothy Prickett Morgan

Hey, Ted:

I am writing regarding your article, “Using Timestamps as Unique Keys ,” which printed on July 17 in Midrange Guru, OS/400 Edition. I would like to add the following option for consideration.

Although the timestamp microsecond value returned by the TIME operation code is only accurate to three positions, SQL’s current timestamp register returns a value accurate to six positions.

To verify this assumption, I created the following simple SQLRPGLE program:

D timestamp1      s               z
D timestamp2      s               z

C                   time                    timestamp1
C/exec sql
C+ set :timestamp2 = current timestamp
C/end-exec
C
C                   eval      *inlr = 

Changing Languages on a 5250 Screen

July 31, 2002 Timothy Prickett Morgan

Hey, Joe:

I do technical support for a country in South America, where the AS/400’s primary language is 2931 (Spanish). But when I telnet over to do tech support, I want my screens to display in language code 2924 (English), which is installed on the machine as a secondary language. Is it possible to change my PC5250 screens to display English?

— Alex

It’s possible to change a user session’s PC5250 screen to display in any installed secondary language by adding a language library to the first position in the system part of the user’s library list. By default, your