I need your help with an SQL query. I have two database files: a header file and a detail file. There may be many detail records for each header record, but I only want to see certain detail records. Here’s the rub. I want to retrieve all header records, even the headers for which I don’t select any corresponding detail. It seems to me this should be an easy query to write, but my efforts so far produce only the header records for the selected details.

–Wayne

There’s more to this query than meets the eye, Wayne. It is simple,

It’s been a while since we ran an article of odds and ends. Here are several short tips for working with the Integrated File System (IFS). I hope you find something useful.

Question:

The Work with Object Links (WRKLNK) panel doesn’t show complete file names. What I see is the first 18 characters of a file name, a space, and a greater-than sign, like this:

Sales (3Q-2007) Re >
Sales (3Q-2007) Re >
Sales (3Q-2007) Re >
Sales (3Q-2007) Re >
Sales (3Q-2007) Re >

Is there a way to make it show the complete names?

Answer:

You’re close. Just

I recently had to quickly determine the size of my production box’s AS/400 Integrated File System (IFS) when its DASD usage zoomed past its ASP threshold value and was threatening to crash the system. Since I didn’t have a good technique handy, I evaluated several different IFS evaluation methods on the fly. Here’s what I learned and how to use these methods to locate where your big IFS folders live.

Free Tools in Different Packages

Due to my cheap nature and even more limited budget, I usually gravitate toward what IBM and the Internet can offer. For determining IFS folder