1. A Good Search Engine Can Augment Business Intelligence Use

The Go! Search module in IBM Cognos 8 V4 supports unstructured data, thereby expanding a searcher's reach while enhancing the BI user's self-reliance. By Chris Smith Recent articles raise the question about the positioning of en

2. Could Open-Source Collaboration Be Key to Solving the World's Toughest Socioeconomic Challenges?

One author says the current subprime mortgage meltdown might have been avoided if large financial players had been more collaborative. By Chris Smith Regardless of the hardship it is causing many people, the subprime mortgage meltdown m

3. Putting Business Intelligence at Your Fingertips, Part II

Sophisticated DB2 for i5/OS features provide important benefits within the business intelligence environment. In the first part of this two-part series, we covered business intelligence concepts, architecture, and methodology—ideas th

4. Putting Business Intelligence at Your Fingertips, Part I

Having a practical knowledge of BI can give your organization a distinct competitive edge.   Business intelligence (BI) is rapidly regaining the attention of business executives because a well-designed and well-implemented data war

5. Shouldn't You Be Exploiting Knowledge Management (KM) in Your System i Shop?

Powerful, affordable technology is available to midsize firms, and the benefits are enormous.   Enterprises have always been organized around the fact that somebody knew something—market needs, technology capabilities, econom

6. Internal or External? Two Methods of Providing Business Intelligence to Partners

The key to any successful business intelligence or data warehousing solution is its ability to provide information to those who need it.   CEOs want a lot these days: Lower costs Improved customer and supplier satisfaction

7. Selecting and Deploying Business Intelligence (BI) Suites

Don't be distracted by mysterious terms and acronyms. Just do the proper homework.

8. Knowledge Management

What is it, and how do we implement it?

9. SQL vs. OPNQRYF--The Battle Continues

Here's one man's perspective.

10. The Death of OPNQRYF

Did the title of this article get your attention? I hope so. It certainly grabbed my attention as the subject of an email I received from Howard Arner back in early October. He forwarded a clipping to me from an IBM press release in case I hadn’

11. Customer Profiling: Benefit or Intrusion?

The ability to track customers in an e-business world presents some interesting dilemmas.

12. The Evolution of Programming: Darwin, Genetics, and Mutant Programs

Natural science and computer science merge to solve seemingly intractable problems.

13. Business Intelligence: A Necessity for Business Success

Check out this road map to the many methods for turning your data into business savvy.

14. Focus on Business Intelligence and Knowledge Management

Recent developments in the structural model of IT have started to emphasize intelligence and knowledge rather than the sheer volume of information contained in huge databases. Both business intelligence (BI) and knowledge management (KM) entail the u

15. How to Count and Keep Your Midrange Knowledge Capital

Learn how to find, catalog, and retain the business knowledge you already have in the brains of your midrange computing enterprise.

16. KM 101: What Is Knowledge Management, and Am I Already Doing It?

Knowledge management is a hot buzzword in management circles, and it?s coming to a knowledge store near you.

17. A Case of Rotten OPNQRYF Performance

One of the biggest challenges of writing programs that use the Open Query File (OPNQRYF) command is creating the query select (QRYSLT) statement.

18. Flexible Date Selection with OPNQRYF

The data processing staff of a certain AS/400 installation had an extra-strength headache. Every time they ran many of the daily, weekly, monthly, quarterly, semi-annual, and yearly queries and Open Query File (OPNQRYF) CL programs, they had to chang

19. OPNQRYF Demystified

One of the strengths of OS/400 is its integrated relational database. Although the database has been given a name in V3R1 (DB2/400 or DB2 for OS/400), it has been part of the operating system since the days of the S/38. Just as the database is part o

20. Advanced Join Techniques Using OPNQRYF

Normalized databases contain many files, many of them with multiple key fields. Rarely can you retrieve all the information you need for a job from just one of them. Whether you need data from 2 files or 20, OPN-QRYF's powerful joining capabilities l

21. Using OPNQRYF to Join Files

Joining is combining data from two files into one record format. Relational databases join files so that applications have all the information they need. There's more than one way to join files on the AS/400. You can create permanent join logical fi

22. Dynamic Sequencing with OPNQRYF

Logical files are excellent for interactive processing that requires data file access paths that are always current. However, if you have ever created a logical file solely for the purpose of creating a new data path for a report program, you will be

23. Did OPNQRYF Select any Records?

In various situations, it is important to know if at least one record was selected after running the Open Query File (OPNQRYF) command. If no records were selected, you would want to take an appropriate action. I have created a technique that allows

24. Eliminate OPNQRYF Divide by Zero Errors

When using the MAPFLD parameter in the Open Query File (OPNQRYF) command to assign the result of a division to a field, a "division by zero" error may occur. This will happen whenever the field or expression used as a divisor has a value of zero for

25. OPNQRYF Error on QRYSLT

Q: I'm having a problem with the Open Query File (OPNQRYF) command. I have a display file that lets the user fill in a field called CSDATE. I use this field in a CL program to select certain records from the purchase order item (POITEM) file. When I

26. Open Query File

Q: I'm new to the AS/400 from the S/36. I'm trying to use the OPNQRYF command in a CL program to select records that do not contain an asterisk (*) anywhere within the order number field. I tried to build the select statement using *NE with the wildc

27. Using %VALUES and %RANGE with OPNQRYF

From: Matthew Ferris To: Ted Holt Can someone help with the syntax of the Open Query File (OPNQRYF) command? I have two questions: 1. Is the following the proper way to code the %VALUES parameter? QRYSLT('RESPT *EQ %VALUES( + "A7" "A8" "A9

28. OPNQRYF vs. RPG

Q: Is it faster to use the Open Query File (OPNQRYF) command to read a file and select a number of records, or to read the file in an RPG program and select the records there? I get the impression that if you use OPNQRYF, you are essentially processi

29. Flexible Character String Search with OPNQRYF

Putting OPNQRYF's wild card function to work. Brief: There are numerous ways you can scan character fields in an AS/400 database to find a pattern. The method presented here, although not the most conventional, may be one you should consider. When

30. Flexible Reporting with Open Query File

OPNQRYF can help you adapt reports to the needs of many users. by Ted Holt It's very common around my shop for a user to call the data processing department and say something along the lines of, "I really like the report Joe Smith gets. I'd like t

31. A #GSORT User's Primer to Open Query File

A #GSORT User's Primer to Open Query File by Ted Holt Meet #GSORT's Replacement on the AS/400. The fact that you are reading this article indicates that you probably know your way around #GSORT. Perhaps you've been coding sort specs since the days