DDS-defined logical files can have multiple record formats, each one of them coming from different physical files of different types of data. I would like to do the same sort of thing in SQL. That is, I want to retrieve all the records from one file followed by all the records from a second file, grouped by one or more common key fields. This is not a join, and it doesn’t seem like a union either, because the two data sets are so different. Am I trying to do the impossible?

–David

What you’re doing may be unusual, but it’s

If you already know about these, then just hit the ol’ delete key on the message. I learned how to do this today. SQL is great for going “down the page.” It’s when they want data summed across that it gets to be a real kludge! Pivot tables are the answer.

It started with your article Load a Spreadsheet from a DB2/400 Database. I got it working! Sweet! Miracles never cease! Thanks a bunch!

Once the data is loaded into the spreadsheet via the SQL statement, make sure the column headings have decent labels. Open the Data menu and

I have searched every configuration I know of on our 9406-720 (running OS/400 V4R4), but I cannot find what is limiting the total number of Client Access 5250 sessions running on my machine. No matter what, the machine will only accept about 70 sessions. I’ve had to cut out multiple user sessions in order to allow everyone a single session. Any ideas on where the limit is coming from?

–Rick

It’s like Rubik’s Cube for the iSeries… with No Prize

Rick sent his question in this week and so far I haven’t been able to come up with an answer.