Newsletters Subscriptions Forums Store Career Media Kit About Us Contact Search Home


 

Four Hundred Guru


Four Hundred Guru, provides tech tips, programming how-to, free code, and systems administration advice for OS/400 techies. This newsletter is the merger of our Midrange Guru, OS/400 Edition, and Midrange Programmer, OS/400 Edition newsletters. Four Hundred Guru is edited by Howard Arner, Joe Hertvik, Ted Holt, Shannon O'Donnell, and Kevin Vandever as its editors and has Raymond Everhart, G. Wayne Hawks, Marc Logemann, David Morris, and many others as contributing editors. Their motto is: "You Have Questions.  We Have Answers."

(The index for prior Midrange Guru issues is on the top of this list, while the index for the prior Midrange Programmer issues is at the bottom of this list.)

Current Issue: September 15, 2004

Using the SQL Features in Operations Navigator, by Joel Cochran

XML Validation with Regular Expressions, by David Morris

Admin Alert: Three Ways to Tighten OS/400 Security, by Joe Hertvik

September 8, 2004

Sifting Through the Java Quagmire, by Kevin Vandever

Define Compile-Time Array Data in D-Specs, by Ted Holt

CRTDUPOBJ and Logical Files, by Ted Holt

September 1, 2004

Reusing HTML and Form Filling with RPG CGI, by Shannon O'Donnell

Using DRDA to Execute SQL Statements on Another iSeries, by Michael Sansoterra

Admin Alert: Finding More Elusive OS/400 Commands, by Joe Hertvik

August 18, 2004

Use Named Constants to Write Clearer Code, by Ted Holt

Securely Resetting Disabled User Profiles, by Wayne O. Evans

Admin Alert: Searching for Elusive OS/400 Green-Screen Commands, by Joe Hertvik

August 11, 2004

Listing Spool Files, by Bruce Guetzkow

Optional Parameters and CL Procedures, by Ted Holt

Control Break Programs, Version 3, by Ted Holt

August 4, 2004

Create Your Own Compile Commands in WDSC, by Bruce Guetzkow and Kushal Munir

Use Your PDM Options with RSE, by Ted Holt

Admin Alert: Shutting Down OS/400 User Profiles with Activation Entries, by Joe Hertvik

July 28, 2004

Backup and Recovery Just Got Easier with BRMS V5R3, by Debbie Saugen

Control Break Programs, Version 2, by Ted Holt

Auditing Users with All-Object Authority, by Wayne O. Evans

July 21, 2004

Encapsulating File Access in a Service Program, by Joel Cochran

Adding New Parameters to RPG Programs, by Ted Holt

Admin Alert: Four Cool Things You Can Do with PC5250, by Joe Hertvik

July 14, 2004

More V5R3 SQL Enhancements, by Michael Sansoterra

Using Member Filters in Remote Systems Explorer, by Ted Holt

Admin Alert: Decommissioning Group Profiles, by Joe Hertvik

June 30, 2004

V5R3 SQL Enhancements, by Michael Sansoterra

Secure Spool File Management, by Wayne O. Evans

Eliminate Unnecessary Access Paths, by Ted Holt

June 23, 2004

IBM Enhances iSeries Access Family with Lots of Goodies, by Joe Hertvik

Printing Barcodes Without an IPDS Printer, by Michael Sansoterra

Updating Through an SQL Cursor, by Ted Holt

Admin Alert: Changing the Limits on OS/400 Job Spool Files, by Joe Hertvik

June 16, 2004

V5R3 Advances DB2 UDB for iSeries, by David Morris

Effective Messaging, IBM's Way, by Ted Holt

Vincent's Standards, by Ted Holt

June 2, 2004

Pooling Your DataSources, by Marc Logemann

Don't Let Overrides Deceive You, by Cletus the Codeslinger

Query/400 and Multiple Detail Lines, by Ted Holt

Admin Alert: Checking Your iSeries Batteries, by Joe Hertvik

OS/400 Alert: Windows XP Service Pack 2 Beta, by Shannon O'Donnell

May 26, 2004

Creating Dynamic Queries, by Bruce Guetzkow

Security and DDM Files, by Wayne O. Evans

Calculate Ages with Query/400, by Ted Holt

OS/400 Alert: V5R3 Has Many New Admin and Operations Features, by Shannon O'Donnell

May 19, 2004

Date Handling in RPG IV, by Joel Cochran

A Solution to the Numeric Parameter Problem, by Ted Holt

Read a Data Area As a One-Row Table with SQL, by Ted Holt

Admin Alert: A Lotus Notes Adjustment for Fighting Spam, by Joe Hertvik

May 12, 2004

Tomcat 5 and DB2 for iSeries, by Marc Logemann

Writing Control Break Programs, by Ted Holt

Changing Prototypes and Dual Prototyping, by Joel Cochran

Sending E-Mail from RPG, by David Morris

OS/400 Alert: i5, or iHype? by Shannon O'Donnell

May 5, 2004

Using RPG As Your ASP Language, Part 2, by Howard F. Arner Jr. and Holley Davis

Proper CL Error-Handling, by Ted Holt

Closing Files in ILE Service Programs, by Ted Holt

Admin Alert: Hitting the Limits of the QNTC File System, by Joe Hertvik

OS/400 Alert: Fix Central Is Now Firewall-Enabled, by Shannon O'Donnell

April 28, 2004

Cross-Reference Your Procedures, by Bruce Guetzkow

Using RPG As Your ASP Language, Part 1, by Howard F. Arner Jr. and Holley Davis

Keep Your Users Informed, by Ted Holt

Find Database Records with Invalid Dates, by Ted Holt

OS/400 Alert: Googlize Your Enterprise, by Shannon O'Donnell

April 21, 2004

Smooth the Java Journey with Struts, by David Morris

Programming with Assertions, by Cletus the Codeslinger

Make a CL Program or Module Retrieve Its Name, by Ted Holt

Admin Alert: When Management Central Server Won't Start, by Joe Hertvik

OS/400 Alert: Microsoft Extends the Life of JVM, by Shannon O'Donnell

April 14, 2004

Stop Hard-Coding Before It Stops You, by Kevin Vandever

An Alternative to Externally Described Printer Files, by Cletus the Codeslinger

Performing Numeric Bitwise Comparisons in SQL and RPG, by Michael Sansoterra

V5R2 Security System Value Lock, by Wayne O. Evans

OS/400 Alert: iSeries Movies, Tools, and More, by Shannon O'Donnell

April 7, 2004

ILE in Practice, by Joel Cochran

Using Exception Breakpoints in WDSc, by David Morris

Using Filters in the Remote Systems LPEX Editor, by Ted Holt

Admin Alert: The Joys of Creating User Profile Information Files, by Joe Hertvik

OS/400 Alert: Microsoft Previews Windows XP Service Pack 2, by Shannon O'Donnell

March 31, 2004

Step by Step: RPG IV and Interactive Web Pages, by Shannon O'Donnell

Determine Elapsed Days, Weekdays, and Workdays, by Ted Holt

Thinking in Sets, by Howard F. Arner, Jr.

Admin Alert: Moving ASCII Data Between IFS and Windows, by Joe Hertvik

OS/400 Alert: Virus Programming for the Novice, by Shannon O'Donnell

March 24, 2004

V5R3 CL Programming Enhancements, Part 2, by Ted Holt

Better Data Transfers, by Bruce Guetzkow

Delimited List Processing in SQL, by Michael Sansoterra

OS/400 Alert: Microsoft Closes the Doors on JVM, by Shannon O'Donnell

March 17, 2004

V5R3 CL Programming Enhancements, Part 1, by Ted Holt

Using 'New' SQL Data Types in RPG, by Raymond Everhart

Why Use the Magic Number in Qshell Scripts? by Ted Holt

Admin Alert: The Absolute Coolness of the QNTC File System, by Joe Hertvik

OS/400 Alert: Major Outlook 2002 Vulnerability Discovered, by Shannon O'Donnell

March 3, 2004

Sleep Soundly with Hibernate, David Morris

Practical Use of a Translation Table, by Michael Sansoterra

Different Record Formats Without Level Checks, by Ted Holt

Admin Alert: Five Quick PC5250 Tricks for Administrators, by Joe Hertvik

OS/400 Alert: Have You Been Snarfed? by Shannon O'Donnell

February 25, 2004

iSeries Navigator: Application Administration, by Shannon O'Donnell

Get Rid of the SNADS Headache with Auto-FTP, by Wendy White

Is Your File Transfer Still Active? by Doug Mewmaw

A Chicken-and-Egg Trigger Problem, by Ted Holt

OS/400 Alert: Security Starts At Home, by Shannon O'Donnell

February 18, 2004

iSeries Navigator: A World of Wizards, by Shannon O'Donnell

A Super Way to Display a Date, by Ted Holt

Short Circuit Evaluation, by Ted Holt

Admin Alert: Creating a Private Subsystem, by Joe Hertvik

OS/400 Alert: Virus Targets AIM, by Shannon O'Donnell

February 11, 2004

What You Should Know About Activation Groups, by Joel Cochran

Soft-Coded Report Distribution, by Bruce Guetzkow

Dealing with Divided Date Fields, by Ted Holt

The Better Way to Delete Physical Files, by Ted Holt

OS/400 Alert: SSL Certificates, by Shannon O'Donnell

February 4, 2004

Setting up an OS/400 HTTP Firewall Using Reverse Proxy, by Shannon O'Donnell

How Many Records Did SQL Delete? by Ted Holt

Recovering from WDSc Errors, by David Morris

Admin Alert: Alternate Ways to Ensure a Subsystem Ends, by Joe Hertvik

OS/400 Alert: alphaWorks and Homeland Security, by Shannon O'Donnell

January 28, 2004

Application and Data Integration Between Linux and OS/400, by Erwin Earley and David Boutcher

To Commit or not to Commit, by Randy Adamski

Simplify Complex Conditions, by Ted Holt

Retrieve the System Name, by Ted Holt

OS/400 Alert: Trials and Betas, by Shannon O'Donnell

January 14, 2004

Why SQL? Why Now? by Raymond Everhart

Deleting with a Generic File Name, by Ted Holt

Functions Can Modify Parameters, Too, by Ted Holt

Admin Alert: Three Common Mistakes in CL Administration, by Joe Hertvik

OS/400 Alert: Spoofing and Demonstrations, by Shannon O'Donnell

December 17, 2003

Returning Result Sets and Parameters Using ADO, by Howard F. Arner Jr.

Odds and Ends, by Ted Holt

Reader Feedback and Insights: Thanks for DST Password Tip

December 12, 2003

Case-Insensitive Comparisons and Sorts in RPG and Database Files, by Michael Sansoterra

Updating Two or More Fields Through a Join, by Ted Holt

Reader Feedback and Insights: Reader Appreciates the Basics

December 10, 2003

Save Those Keystrokes! by Ted Holt

FTP to Printer Files, by Ted Holt

Reader Feedback and Insights: What the Hey?

December 5, 2003

Using .NET to Call iSeries Stored Procedures, by Howard Arner

Query and Date Durations, by Ted Holt

Reader Feedback and Insights: Appreciation for COBOL Code

December 3, 2003

Do We Still Need FMTDTA? by Ted Holt

How Many JVMs Does One Need? by Ted Holt

Reader Feedback and Insights: Why Not REXX?

November 21, 2003

Views for Query/400! by Howard Arner

Alternate Methods for Returning Data Structures from Subprocedures, by Steven Gray

Reader Feedback and Insights: Why People Ask Basic Questions

November 19, 2003

Querying the System Catalog Like DSPFD, by Howard Arner

Exchange Data the Easy Way with Windows File Shares, by Michael Sansoterra

Reader Feedback and Insights: Don't Do Things On-the-Fly

November 14, 2003

Case-Insensitive Sorting and Record Selection in SQL/400, by Ted Holt

Locked Out of System Service Tools, by Ted Holt

Reader Feedback and Insights: Free Utility to Retrieve Command Source

November 12, 2003

Returning a Pointer to a Data Structure from a Function, by Steven Gray

Get with the Times, by Ted Holt

Reader Feedback and Insights: Reader Prefers DDS

November 7, 2003

Pesky Date Conversions with a UDF, by Howard Arner

Customizing the WDSc JVM, by David Morris

Reader Feedback and Insights: Library List Management

November 5, 2003

Display Two Subfiles At Once, by Ted Holt

Am I Debugging You? by Ted Holt

Reader Feedback and Insights: Why Online Forums Suffer

October 29, 2003

Miscellaneous Query Tips, by Ted Holt

Determining Current Windows User, OpsNav Prompting; by Howard Arner

Reader Feedback and Insights: Database Design Tools

October 24, 2003

Embedding Markup in XML, by David Morris

Query/400 Determines the Day of Week, by Ted Holt

Reader Feedback and Insights: He Likes Common Table Expressions

October 22, 2003

How to Call a Stored Procedure from Excel, Part 2; by Howard Arner

Where Is My Source Code? by Ted Holt

Reader Feedback and Insights: Appalled by Lack of Basic Knowledge

October 15, 2003

Alternate SQL Row-Selection Criteria, Take 2; by Ted Holt

Alternate Names for Indicators, by Ted Holt

Reader Feedback and Insights: Green-Screen SQL Alternatives

October 10, 2003

Converting XML Attributes to Elements, by David Morris

Executing Qshell Commands Dynamically, by Ted Holt

Reader Feedback and Insights: Unix Is Not All Bad

October 8, 2003

Display QCDRCMDD XML Output Using XSLT Stylesheet, by Steven Gray

More Conversion of Query/400 to SQL, by Ted Holt

Reader Feedback and Insights: Spool Files and SQL

October 3, 2003

More Query/400 and Date Selection Techniques, by Ted Holt

Updating through a Join with SQL, by Ted Holt

Reader Feedback and Insights: What's a Korn Shell?

October 1, 2003

Leveraging ThreadLocal Variables in Java, by David Morris

For Members Only, by Ted Holt

Reader Feedback and Insights: Unix Shell Script Is as Good as CL

September 26, 2003

External Stored Procedures and Client/Server Error Messages, by Michael Sansoterra

Installing CODE on Small PCs, by Ted Holt

Reader Feedback and Insights: COBOL Tip Appreciated

September 24, 2003

Date and Time Formats and Query/400, by Ted Holt

FTP Directory Listing Options, by Ted Holt

Reader Feedback and Insights: Here Comes Another One-Row, One-Column Table

September 19, 2003

Same Name, Different Function, by Ted Holt

Qshell's Black Hole, by Ted Holt

Reader Feedback and Insights: Unix Link Appreciated

September 17, 2003

Alternate SQL Row-Selection Criteria, by Ted Holt

SQL DayOfWeek Functions for Non-Date Data, by Ted Holt

Reader Feedback and Insights: Identity Columns and Performance

September 12, 2003

Adjust Default Query Optimizer Settings with QAQQINI

Alternate Names for Indicators

Reader Feedback and Insights: ADDLIBGRP and QUSRTOOL

September 10, 2003

More on XML Schema Validation with RPG

Alternatives to Published Tips

Reader Feedback and Insights: May I Have a Sample of That Report?

September 5, 2003

Not All Outer Joins Are Equal

Retrieve Command Source

Reader Feedback and Insights: No Field Reference File, No Problem

September 3, 2003

Query/400 and Record Selection by Date

Object Authorities and Stored Procedure Calls

Reader Feedback and Insights: He Uses SQL to Define Databases

August 27, 2003

Mimic Green-Screen Interactive SQL Without Development Kit

Calling a Java Main Method from RPG

Reader Feedback and Insights: He Learned Java

August 22, 2003

More Library List Management Techniques

Stay on the Same Subfile Page

Reader Feedback and Insights: Ted's Too Easy on Unix

August 20, 2003

Retrieve Current Date, Time, and Day of Week

Restoring Procedures to a Development Machine

Reader Feedback and Insights: Converting Date to Numeric in Free-Format RPG

August 15, 2003

Deciphering Audit Journal Codes

How to Call a Stored Procedure from Excel

August 13, 2003

Understanding the Unix Mindset

Finding a Certain Day of the Week

August 8, 2003

Calling CL Programs as Stored Procedures

Guarantee Unique Key Values

Reader Feedback and Insights: Soft-Coded Library Lists

August 6, 2003

Two-Dimensional Compile-Time Arrays in RPG

Redirecting Java's Standard Output, Take 2

Reader Feedback and Insights: COBOL API Resources

August 1, 2003

Query Time Limits and ADO: the Devil's in the Details

Retrieve a Representative of a Group

Reader Feedback and Insights: Qshell and User Spaces

July 30, 2003

Bypassing a Locked Record

View Overprinting from a Green-Screen Session

Reader Feedback and Insights: Another One-Row, One-Column Table

July 25, 2003

Printing to Specialized Printers on the iSeries

Odds and Ends

Reader Feedback and Insights: COBOL API Resources

July 23, 2003

Mismatched Java Versions

Hard-Coded Library List Woes

Reader Feedback and Insights: Resolving Field Names at Runtime, Part 4

July 18, 2003

Use Workstation Customizing Objects to Control Printing

Extract Reports from Disk Files

Reader Feedback and Insights: More About Strings

July 16, 2003

Grep and Database Files

Redirecting Java's Standard Output

Reader Feedback and Insights: SQL Versus DDS

July 11, 2003

Uses for USER

More Free-Format RPG Date-Conversion Solutions

Reader Feedback and Insights: More "Why Java?"

July 9, 2003

User Spaces Are Like IFS Files

Transylvania 65535

Reader Feedback and Insights: What's That Name Again?

June 27, 2003

Build Better Forms by Drawing Dynamic Boxes

SQL Field Reference File

Reader Feedback and Insights: Impressive Coverage

June 25, 2003

Debugging External User-Defined Functions

Running Client Commands under FTP

Reader Feedback and Insights: Pondering the Meaning of 'Contiguous'

June 18, 2003

Use Soft-Coded Library Lists When Submitting Scheduled Jobs

Fixing Damaged Data Queues

Reader Feedback and Insights: COBOL Help Wanted

June 13, 2003

Retrieving the Host Name from an IP Address

Variable-Length Character Data

Reader Feedback and Insights: Frightened by the Midrange Guru

June 11, 2003

Duplicate Workstation Name Entries Can Cause Interactive Headaches

Resolving Field Names at Runtime, Part 3

Reader Feedback and Insights: Another Response to "Why Java?"

June 4, 2003

Deprecating and Renaming Java Classes

Joining on Incompatible Fields in Query/400

Reader Feedback and Insights: The Top 10 Reasons to Learn Java

May 28, 2003

How Dynamic Is OPNQRYF?

Returning Qshell Data to OS/400

Reader Feedback and Insights: DDS Column Headings

May 23, 2003

Automatically Logging Off Inactive Workstations

Resolving Field Names at Runtime, Part 2

Reader Feedback and Insights: Another Use for Surrogate Keys

May 28, 2003

How Dynamic Is OPNQRYF?

Returning Qshell Data to OS/400

Reader Feedback and Insights: DDS Column Headings

May 21, 2003

Working with Varying-Length Database Fields

When a 10-Digit Variable Won't Hold a 10-Digit Number

Reader Feedback and Insights: COBOL and APIs

May 14, 2003

Managing SQL Procedures

Function Signatures and Parameter Matching

Reader Feedback and Insights: Too Many Duane's

May 9, 2003

Sending AS/400 Spool Files

Resolving Field Names at Runtime

Reader Feedback and Insights: COBOL Examples Wanted

May 7, 2003

Random Decisions in Java

Free-Format RPG and Date Conversions

Reader Feedback and Insights: Tips We Can All Relate To

April 30, 2003

Time for a Common Table Expression, Part 2

Printing Qshell Output, Part 2

Reader Feedback and Insights: There's No Java Conspiracy

April 25, 2003

Printing Qshell Output

Telnet Access in a Pinch

Reader Feedback and Insights: Left in the Dust

April 23, 2003

Select Subfile Records by Position

Retrieve Java Source

Reader Feedback and Insights: More Advantages of Surrogate Keys

April 18, 2003

Comparing Objects in Java

Creating a Custom Setup Program for New OS/400 Software

Reader Feedback and Insights: Another Advantage of Surrogate Keys

April 16, 2003

Securing File Overrides

Compiling a Program that Uses an Outfile

Reader Feedback and Insights: More Feedback on 'Why Java?'

April 11, 2003

Copying OS/400 User Profiles to a New System

Time for a Common Table Expression!

Reader Feedback and Insights: More on V5 and Trigger Programs

April 9, 2003

Retrieve Qshell Exit Status in CL Programs, Take 3

Sort on an Unprinted Field in Query/400

Reader Feedback and Insights: Free-Format RPG

April 4, 2003

Pros and Cons of Surrogate Keys

Odds and Ends

Reader Feedback and Insights: Left in the Dust

April 2, 2003

Subprocedures and the Default Activation Group

Deciphering Qshell Error Codes

Reader Feedback and Insights: Who's Out of Touch with Reality?

March 28, 2003

Connecting to the iSeries Through a Firewall

What Is Library QSYSDIR?

Reader Feedback and Insights: More Letters About "Why Java?"

March 26, 2003

Uploading a Fixed-Length Record File

Recovering Client Access Sessions Quickly

Reader Feedback and Insights: More on "Why Java?"

March 19, 2003

Recover Client Access Sessions More Quickly

Query/400 and the Library List

Reader Feedback and Insights: IBM Is Out of Touch with Customers

March 14, 2003

Using SQL to Find Duplicate Records

Responsive Rooms with a View

Reader Feedback and Insights: Results of System/36 Tips Poll

March 12, 2003

ILE Strategies

Miscellaneous Tips from Readers

Reader Feedback and Insights: Free-Format MOVE Operations

March 7, 2003

Generating a Validation String in Java

Query Management and Outer Joins

Reader Feedback and Insights: Why Java?

March 5, 2003

Another Room with a View

Job Scheduler's Other Defaults

Reader Feedback and Insights: More on Trigger Problems with Restored Library

February 28, 2003

Batch FTP Under ILE

A Room with a View

Reader Feedback and Insights: Converting Zeros to Nulls

February 26, 2003

Odds and Ends

Qshell's Default Path

Reader Feedback and Insights: Viewing RPG BIFs after I/O Operations

February 21, 2003

Using CSS to Selectively Print HTML

Send Query/400 to Its Own Job Queue

Reader Feedback and Insights: Trigger Problem with Restored Library

February 19, 2003

Relative Record Number Sequence and SQL

Copy a Physical File to a Save File

Reader Feedback and Insights: Omitting Parameters in RPG Programs and Modules

February 14, 2003

Easy Encryption with Exclusive Or

Commenting FTP Scripts

February 12, 2003

Extract Packed Decimal Numbers from Character Strings

Odds and Ends

Reader Feedback and Insights: Unix Shells for Windows

February 7, 2003

Odds and Ends

V5 and Trigger Programs

Reader Feedback and Insights: Character to Numeric

February 5, 2003

Real Date to JD Edwards Date as a UDF

Alpha to Numeric with Query/400

Reader Feedback and Insights: SBMJOB's RQSDTA Parameter

January 29, 2003

Converting Alpha to Numeric

Retrieve Qshell Exit Status in CL Programs

Reader Feedback and Insights: Effective Communication

January 24, 2003

Effective Communication, Part II

Type2 IFS Directories and Domino

Reader Feedback and Insights: Native Awk

January 22, 2003

Effective Communication, Part I

More About Qshell's db2 Command

Reader Feedback and Insights: Calling RPG Subprocedures from CL

January 17, 2003

A More Perfect Union

Which Commands Can Build Outfiles?

Reader Feedback and Insights: Faster Grep

January 15, 2003

Dropping Procedures

Running Awk

Reader Feedback and Insights: More about Dumping IFS Files

January 10, 2003

Call RPG Subprocedures from CL

Predicting Bad Query Performance

Reader Feedback and Insights: Another Vote for ISDB

December 18, 2002

Debugging Java Script

Make Qshell Clean Up After Itself

Reader Feedback and Insights: Your System/36 Information is Very Helpful

December 13, 2002

Ensuring Valid XML Content

Spacing between Concatenated Strings

Reader Feedback and Insights: RPG Compiler Directives and V4

December 11, 2002

Subfile Positioning

Readers Prefer ISDB

Reader Feedback and Insights: SBMJOB's RQSDTA Parameter

December 6, 2002

Get Rid of Old IFS Files, Take Two

Performance of the SQL LIKE Predicate

Reader Feedback and Insights: One-Row Table Still Needed

December 4, 2002

Protecting HTML Page Elements with JavaScript and CSS

LIKE is Like, Confusing, Man!

Reader Feedback and Insights: RPG II

November 20, 2002

V5R1 Storage Model Mismatch

Get Rid of Old IFS Files

Reader Feedback and Insights: Thanks for Qshell Tips

November 15, 2002

Access the Database from Qshell

Data Structure Parameters in RPG Prototypes

Reader Feedback and Insights: Indicators in RPG II Programs

November 13, 2002

Using Grep to Search Source Physical Files

Compiler Directives for RPG Programs and Modules

Reader Feedback and Insights: Modernizing RPG II Programs

November 8, 2002

Odds and Ends

Omitting Parameters in RPG Programs and Modules

Reader Feedback and Insights: Overlooking the Obvious

November 6, 2002

Going From a True Date to a JDE Date

Use the Full-Screen Debugger with OPM Programs

Reader Feedback and Insights: We Want More RPG

November 1, 2002

Help with RPG II Programs

You Can't Get There From Here

Reader Feedback and Insights: Not All Hex Dumps Are Created Equal

October 30, 2002

Get a Hex Dump of Any File

SQL's One-Row, One-Column Table

Reader Feedback and Insights: Thanks for the Information

October 25, 2002

Another Way to Dump an IFS File

Johnny Can't Read and RPG Can't Do Math

Reader Feedback and Insights: SQL to the Rescue!

October 23, 2002

A Simple Guide to jar

Type2 IFS Directories

Reader Feedback and Insights: Extending the Network

October 18, 2002

Reading Spool Files in RPG

Hex Dump of an IFS File

Reader Feedback and Insights: Another Compression Utility

October 16, 2002

Sorting Lists in Java

Extending the Network

Reader Feedback and Insights: Dynamic Result Field in Query/400

October 11, 2002

Odds and Ends

Client Access Hotspots

Reader Feedback and Insights: Dynamic Result Field in Query/400

October 9, 2002

FTP and Save Files, Yet Again!

Using API's to Send Impromptu Messages

Reader Feedback and Insights: QTEMP and the Library List

October 4, 2002

Find the Cursor Position in a CL Program

David's Choice for Java Error Logging

Reader Feedback and Insights: A Timely OPNQRYF Tip

October 2, 2002

FTP and Save Files

When Good Batch FTP Users Go Bad

Reader Feedback and Insights: Displaying Menu Options

September 27, 2002

Loading a Tilde-Delimited File into the Database

Find the Cursor Position in a CL Program

Reader Feedback and Insights: Midrange Guru Articles Helpful

September 25, 2002

FTP'ing a Library

OPNQRYF Date Arithmetic

Reader Feedback and Insights: Displaying Menu Options

September 20, 2002

Comparing Lists of Numbers to a Value

JD Edwards Dates, Revisited

Reader Feedback and Insights: Thanks for the Tips

September 18, 2002

Odds and Ends

Is It a Different 'Hello World' in OS/400 V5R1?

Reader Feedback and Insights: More Binder Language

September 13, 2002

Put Users On the Fast Track

Properly Sorting Numeric Arrays

Reader Feedback and Insights: Binder Language

September 11, 2002

Excuse Me...Can You Hold this Secondary Partition While I Upgrade the Primary?

Adding Subprocedures to a Service Program, Revisited

Reader Feedback and Insights: Security Flaws

September 6, 2002

Convert J.D. Edwards Dates to Other Formats

Edit with Parentheses in Query/400, Take Two

Reader Feedback and Insights: Copying Records in RPG

September 4, 2002

Starting the Host Database Server Daemon After an OS/400 V5R1 Upgrade

Parameterized RUNSQLSTM with Two or More Substitutions

Reader Feedback and Insights: Odds and Ends Always Popular

August 30, 2002

Adding Subprocedures to a Service Program

A Fuzzy Search Algorithm

Reader Feedback and Insights: Splitting a Qshell Variable

August 28, 2002

A CPYF Idiosyncrasy Revisited

Edit with Parentheses in Query/400

Reader Feedback and Insights: Timestamps and V5R1 RPG

August 23, 2002

Use Monitor to Trap QCMDEXC Errors

Odds and Ends

Reader Feedback and Insights: More on TCP/IP Printing

August 21, 2002

Debugging Java in Eclipse

Validating a User Password

Reader Feedback and Insights: OPNQRYF Bug

August 16, 2002

Calling a Program From a UDF

Creating HTML Subfiles

Reader Feedback and Insights: Confirm File Deletions in Qshell

August 14, 2002

Make an SQL UDF Return Null

SQL Functions for Mashing Characters

Reader Feedback and Insights: Using Timestamps as Unique Keys

August 9, 2002

Default Connection for CAE Users

Date and Time Functions in V5R1 RPG

Reader Feedback and Insights: TCP/IP Printing Problem

August 7, 2002

Splitting a Qshell Variable

Tell PC5250 to Stop Bugging Me about My Password

Reader Feedback and Insights: Valuable Newsletters

August 2, 2002

Looking for Number Two

Confirm File Deletions in Qshell

Reader Feedback and Insights: Free Software From Kisco

July 31, 2002

SQL Understands Microseconds

Changing Languages on a 5250 Screen

Reader Feedback and Insights: Retrieving Query Definitions

July 26, 2002

Restore a Single IFS Directory

Sending Escape Messages From RPG

Reader Feedback and Insights: Generating a Unique Identifier

July 24, 2002

Three Ways to Direct OS/400 Output Queues to TCP/IP Printers

Did OPNQRYF Retrieve Records?

Reader Feedback and Insights: Scheduling a Job to Run More than Once a Day

July 19, 2002

Odds and Ends

Populating JavaBeans From Database Values

Reader Feedback and Insights: Deleting a Badly Named IFS File

July 17, 2002

SQL and System/36 File Names

Using Timestamps as Unique Keys

Reader Feedback and Insights: Dealing with Record Locks

July 12, 2002

Setting TCP/IP Server Autostart Parameters as a Group

Scheduling a Job to Run More than Once a Day

Reader Feedback and Insights: Service Program Catch-22 Simplified

July 10, 2002

Use Query/400 to Find IFS Files in BRMS

Delete Badly Named OS/400 IFS Files, Take Two

Reader Feedback and Insights: Avoiding Object Locks

June 28, 2002

Easy Subfile Windowing

Distinct File and Record Names with SQL

Reader Feedback and Insights: Determining Whether a User Is Already Signed On, Take Three

June 26, 2002

Connection Pooling with Tomcat

Service Program Catch-22

Reader Feedback and Insights: Searching Message Text

June 21, 2002

Determining Whether a User Is Already Signed On, Take Two

Parameterized RUNSQLSTM

Reader Feedback and Insights: RPG II

June 19, 2002

Tracing a Qshell Variable

LAYOUT: An Improved DSPFFD

Reader Feedback and Insights: String Parameters of Various Lengths

June 14, 2002

String Parameters of Various Lengths, Take Three

Determining Whether a User Is Already Signed On, Take Three

Reader Feedback and Insights: Group Job Limitation

June 12, 2002

String Parameters of Various Lengths, Take Two

Build SQL to Define Your Existing Files, Revisited

Reader Feedback and Insights: Printing Leading Zeros in Query/400, Another Look

June 7, 2002

How Does OS/400 FTP Determine Working Directories?

Searching the Information Center

Reader Feedback and Insights: Printing Leading Zeros with Query/400

June 5, 2002

Build SQL to Define Your Existing Files

Making PC5250 Look like a Dumb Terminal

Reader Feedback and Insights: Proper Use of QTEMP

May 31, 2002

Odds and Ends

Using Library Lists for JDBC File Access

Reader Feedback and Insights: A Better Way to Get Query/400 Definitions?

May 29, 2002

String Parameters of Various Lengths

Prevent Someone Else From Peeking at Your Windows 2000/XP System

Reader Feedback and Insights: Suggestions for a Temporary Library

May 24, 2002

Creating a User-Defined Function to Convert Legacy Dates

CRTDUPOBJ and the Library List

Reader Feedback and Insights: Repetitive Compiler Options

May 22, 2002

Print Query Definitions From a Batch Job

You Can Re-IPL an AS/400 into Restricted State

Reader Feedback and Insights: I Didn't Know You Could Do That

May 17, 2002

Avoiding Split of a File Name Containing Blanks

Odds and Ends

Reader Feedback and Insights: OV/400 Data Text Merge

May 15, 2002

Client Access and Windows Compatibility

Delete Badly Named OS/400 IFS Files

Reader Feedback and Insights: Converting OV/400 Documents to Microsoft Word

May 10, 2002

Table-Driven Programming

Automatically Hold Large Reports

Reader Feedback and Insights: CSV and SQL Utilities From a Reader

May 8, 2002

EDTF Sizes Up OS/400 IFS Directories

Convert OV/400 Documents to MS Word for Free

Reader Feedback and Insights: Another Way to Check the Call Stack

May 3, 2002

Enter the Vector, Victor!

Stupid Parameter Tricks

Reader Feedback and Insights: Spend Money to Save Money

May 1, 2002

Changing Link Styles with CSS

Legacy Dates to SQL Dates

Reader Feedback and Insights: Old Is Not Bad

April 26, 2002

Common Table Expressions Make Summarizing Data Easy

Windows Power Settings Might Disconnect Ops Console

Reader Feedback and Insights: Book Recommendation

April 24, 2002

Looking at another Job's Temporary Objects

Handling Break Messages Revisited

Reader Feedback and Insights: Get with the Times

April 19, 2002

Reducing Sign-On Screen Clutter

Qshell vs. DOS

Reader Feedback and Insights: Good Content

April 17, 2002

Installing the 1.3 Java Development Kit

Show Current Directory in Qshell Prompt

Reader Feedback and Insights: We Still Use the 'Old' Stuff

April 12, 2002