I just read *NOMAX Does Not Mean Infinite Capacity and I politely beg to differ. I work at some shops with smaller and older systems with smaller disk capacity (70 GB, 140 GB). Some are already using more than 70 percent of available space. If I read the capacities correctly, a physical file can hold over four billion records. I did some calculations and I think I’d fill up a system before reaching capacity.

For DDS-described files, I usually set some maximum number of records, as 10,000 seems ridiculously low. Now that you have mentioned SQL described tables, which I

I have an RPG programs that creates work tables in QTEMP. I’d like to be able to specify the library at runtime. I tried using a host variable for the library in a CREATE TABLE command, but that didn’t fly. I am using the system naming convention. Can you help?

–Ben

I wish CREATE TABLE would allow a host variable for the explicit qualifier, but it doesn’t. Here are a few ways that work.

1. Use dynamic SQL. Embed the library name in the SQL command.

D SqlCommand      s            256a   varying
D WorkLib         s             10a
 /free
     *inlr = *on;
     SqlCommand 

Today’s tip comes from my own experience with a recent model HP Pavilion laptop that I use for my business. The problem occurred when I loaded up the PC5250 emulator software that comes with System i Access for Windows V6R1M0. I attached to and signed on to my production IBM i box with PC5250, executed a green-screen command, and hit the F3 key to exit the screen.

Nothing happened.

The F3 key didn’t work. Neither did F5, F10, F12, or any other F-key from F1 all the way up to F24. My PC5250 F-keys were dead.

Experimenting with different keystroke