Newsletters Subscriptions Media Kit About Us Contact Search Home

MGO
OS/400 Edition
Volume 3, Number 61 -- September 12, 2003

   In This Issue

You Have Questions. The Gurus at Guild Companies Have Answers.

Sponsored By
ADVANCED SYSTEMS CONCEPTS

Quoted from an experienced programmer
new to the iSeries (AS/400):
"The best thing about working on the AS/400 is using ASC's SEQUEL product."

If you're tired of the limitations imposed by Query/400 or ODBC-based query and reporting tools, you need SEQUEL. Discover how thousands of sites around the world have improved access to iSeries data using SEQUEL's Windows- and Web-interfaces. It's the one tool you can rely on for virtually all your iSeries data access needs.
FREE trial available.
Read More about SEQUEL

Sponsored By
WORKSRIGHT SOFTWARE

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?

We can HELP! We have affordable AS/400 software and data to do all of the above. Call us for 30 days FREE.

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com

Adjust Default Query Optimizer Settings with QAQQINI

by Michael Sansoterra

If you're looking to resolve user-defined function (UDF) timeouts, or want to squeak by with slightly quicker dynamic query performance, look no further than the QAQQINI file. QAQQINI is known as the query options file, because it controls many of the settings the query optimizer uses when executing queries.

READ MORE >

Alternate Names for Indicators

Hey, Ted:

We have a lot of old, large RPG programs that are chock full of indicators. We have converted them to RPG IV, and the mixture of code styles looks like the patchwork quilts I slept under at my grandmother's house when I was a kid. I would like to use indicator variables, but going back through a source member and replacing all references to an indicator is impractical. For one thing, an indicator might be changed within a display file and also within the program itself. Here's an easy way to gradually rename indicators in old, monolithic programs.

READ MORE >



Reader Feedback and Insights: ADDLIBGRP and QUSRTOOL

Hey, Ted:

In "Reader Feedback and Insights: Soft-Coded Library Lists," you wrote, "I don't know if the ADDLIBGRP utility was part of the [TAATOOL] package back in the old days."

READ MORE >


Editors: Howard Arner, Joe Hertvik, Ted Holt, David Morris,
Shannon O'Donnell
Managing Editor: Shannon Pastore
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Subscription Information:
To unsubscribe, change your email address, or sign up for any of Guild Companies' free e-newsletters, visit http://www.itjungle.com/sub/subscribe.html.

THIS ISSUE
SPONSORED BY:

Advanced Systems Concepts
WorksRight Software


BACK ISSUES

TABLE OF
CONTENTS

Adjust Default Query Optimizer Settings with QAQQINI

Alternate Names for Indicators

Reader Feedback and Insights: ADDLIBGRP and QUSRTOOL



Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.