Odds and Ends

Dear Readers:

As requested, here are more short tips that don't qualify as tips in their own right, for whatever reasons. I hope you find something useful.

-- Ted

Question:

Is it possible for an initial program to determine if the user who is running it is already signed on with another session?

READ MORE >

Using Library Lists for JDBC File Access

Hey, David:

How do you set your library list with JDBC and JTOpen? The JDBC documentation says that I should use system naming along with a libraries property. When I do that, it appears that the search stops on the first library. The only way I can get a select statement that uses files from more than one library is to qualify the library name. That makes it difficult to test.

-- James

READ MORE >

Reader Feedback and Insights: A Better Way to Get Query/400 Definitions?

I am writing in response to your article, "Print Query Defintions from a Batch Job ," which was published in the May 22 issue of Midrange Guru, OS/400 Edition. A better solution is to use the Retrieve Query Management Query (RTVQMQRY) command, which works fine for a Query/400 definition (*QRYDFN object). This puts the output into a source file that can be manipulated with a program.

See the following example: