Proper Use of QTEMP

June 5, 2002 Timothy Prickett Morgan

Hey, Ted:

In the article, “Suggestions for a Temporary Library,” the author writes the following statement: “…the top of the library list. QTEMP is already there.”

So many sites put QTEMP at the top of the library list to save qualifying file names with QTEMP. I have always felt that this exposes a potential security risk. This is mainly for reasons that might never happen, but, if damage can be done, some day it is bound to happen. For example, a user using Query/400 could easily create a file in QTEMP that has the same name as a

Build SQL to Define Your Existing Files

June 5, 2002 Timothy Prickett Morgan

Note: The code accompanying this article is available for download here.

Hey, Ted:

We have always defined our files with DDS, but now we’re ready to use SQL for data definition.

Do you have a good way to convert our DDS to SQL Data Definition Language (DDL) commands?

— Paul

IBM included just the tool you need in V5R1.

It’s the Generate Data Definition Language (QSQGNDDL) API.

You can read about it on the Web at http://publib.boulder.ibm.com/html/as400/v5r1/ic2924/index.htm?info/apis/qsqgnddl.htm .

I’ll give you an example of what it can do. Then I’ll give you some code you can use to generate

Making PC5250 Look like a Dumb Terminal

June 5, 2002 Timothy Prickett Morgan

Hey, Joe:

Is there any way I can make my PC5250 sessions look like dumb terminal sessions? I have some operators who dislike the Windows framing panel of a PC5250 session, and they just want to see the 5250 screen filling up the display and nothing else when they bring up the program. Is there a way to do this?

— Jeff

Sure, this functionality is part of PC5250’s Windows Setup function. Windows Setup is a series of check boxes and radio buttons that allow you to manipulate certain features of PC5250’s Windows interface. In this case, you want to