SQL Understands Microseconds

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.

-- Jeff Haddix

READ MORE >

Changing Languages on a 5250 Screen

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

READ MORE >

Reader Feedback and Insights: Retrieving Query Definitions

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 Retrieve Query Management Query (RTVQMQRY) command.

-- Mary