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

Checking the Call Stack

Odds and Ends

Reader Feedback and Insights: Refreshing STRCPYSCN

April 10, 2002

Avoiding a Sign-On with Java

CLRPFM for the IFS

Reader Feedback and Insights: Ad-Hoc SQL and Linux

April 5, 2002

One Way to Ease Conversion of RPG II Programs

Odds and Ends

Reader Feedback and Insights: Query Management and MBROPT(*UPDADD)

April 3, 2002

Dynamic Result Field in Query/400

It Looks Bad, but V5R1 Express Error is Harmless

Reader Feedback and Insights: Quotation Marks Work in Pairs

March 29, 2002

More Qshell Output in ASCII

Odds and Ends

Reader Feedback and Insights: Remote Software

March 27, 2002

Query Management and File Updates

Does This Date Fit IBM's Window?

Reader Feedback and Insights: Passive FTP and Data Area QTMFTPPASV

March 22, 2002

Client Access Transfers Linefeed-Terminated Data

Wanted: Qshell Output in ASCII

Reader Feedback and Insights: You Don't Have to Roll Your Own

March 20, 2002

OPNQRYF and Quotation Marks

Getting to the Information Center URLs

Reader Feedback and Insights: Checking for a Mounted Tape

March 15, 2002

The V5R1 Client Access Licensing Configuration People Miss

Remote Control of a Terminal Session

Reader Feedback and Insights: We Like Odds and Ends!

March 13, 2002

Native Graphics, VNC, and Perl

Keep Trailing Blanks on FTP Transfer From PC Client

Reader Feedback and Insights: Passive Mode and OS/400 FTP?

March 8, 2002

Edit Code X Converts Numeric to Alpha

Odds and Ends

Reader Feedback and Insights: Page 1 of  X

March 6, 2002

Global Substitution in OS/400 IFS Files

Display Break Messages on the Bottom Line

Reader Feedback and Insights: We Don't Like Ops Console

March 1, 2002

Extracting Packed Decimal Data From a List

Send Large E-mails in One Piece

Reader Feedback and Insights: CPF9897 and CPF9898

February 27, 2002

More than One Way to Skin a Cat

Page 1 of  X

Reader Feedback and Insights: Status Messages May Degrade Performance

February 22, 2002

find and grep Performance Issues

FTP and Numeric Data

Reader Feedback and Insights: Returning a Value From a Prototyped Call

February 20, 2002

Setting Up Views Optimized for Crystal Reports

Why Doesn't iSeries Ops Console Work?

Reader Feedback and Insights: Remote Sign-On Problem -- A Look at Another Solution

February 15, 2002

Compiling Multiple Java Programs

Finding Your Libraries and Tables with Crystal Reports

Reader Feedback and Insights: Another Solution to the Remote Sign-On Problem

February 13, 2002

A JavaScript Version of /COPY

SQL and Multi-Member Files

Reader Feedback and Insights: Keeping Users Informed

February 8, 2002

Boosting Java Performance

Visual Basic and S/36 Files

Reader Feedback and Insights: Journaling Data Areas and Data Queues

February 6, 2002

Start QINTER Remotely

Keeping Users Informed

Reader Feedback and Insights: More Information about CWBLM0020

February 1, 2002

Getting Past *ALLOBJ Authority

It's Hard to Find Hard Links

Reader Feedback and Insights: Journaling Changed Bytes Only

January 30, 2002

Journaling Changed Bytes Only

Retrieve a Spool File Number

Reader Feedback and Insights: RPG Prototypes and /COPY Members

January 25, 2002

Debugging an SQL User-defined Function

Where's My PC5250 Sign-On?

Reader Feedback and Insights: Appreciation for Crystal Reports Solution

January 23, 2002

SQL Replace Function, Take Two

A CPYF Idiosyncrasy

Reader Feedback and Insights: Choosing a Linux Distribution

January 18, 2002

Determine WebSphere Service Pack Level

Avoiding Record Locks in RPG

Reader Feedback and Insights: Appreciation for Perl Information

January 16, 2002

Retrieve Subtotals and Detail Data at the Same Time

Somebody's Got My Report!

January 11, 2002

Grepping It Up

SQL Package Problems Cause ODBC Troubles

Reader Feedback and Insights: Appreciation for SQL Tip

January 9, 2002

Looking for Strings in the IFS

RPG Compiler Directives and SQL

Reader Feedback and Insights: Appreciation for HTML Tip

December 14, 2001

How Do You Say Midnight in RPG?

Fun with SQL Date Math

Reader Feedback and Insights: Clarification of "Looking Forward to Monday" Tip

December 12, 2001

Removing and Replacing Characters Using SQL

Here's the Code

Reader Feedback and Insights: RPG Prototypes and SQL

December 7, 2001

Looking Forward to Monday

CL Date Arithmetic

Reader Feedback and Insights: Query/400 and User-defined SQL Functions

December 5, 2001

Using Case to Segregate Data

Force Queries to Run in Batch

Reader Feedback and Insights: Debugging and /COPY

November 30, 2001

More on Prototyping *Entry Parameters

DSPATR(PC) for CGI Programs

Reader Feedback and Insights: Defining Entry Parameters in D Specs

November 28, 2001

Remote Sign-On Problem

Client Access Toolbar Customization

Reader Feedback and Insights: Entry Parameters and D Specs

November 21, 2001

Prototyping *ENTRY Parameters, Part II

Properly Ordering Grouped SQL Queries

Reader Feedback and Insights: Discarding the Output of RUNSQLSTM

November 16, 2001

Prototyping *ENTRY Parameters, Part I

Where's the Key?

Reader Feedback and Insights: Don't Ignore C

November 14, 2001

Active and Passive FTP Mode

Still More Personal Communications Keyboard Mapping

Reader Feedback and Insights: Automatic Reply to Inquiry Messages

November 9, 2001

Directing SQL Output to a Database File

More Personal Communications Keyboard Mapping

November 7, 2001

Rules Of Thumb On Program Optimization

Dynamic Spool File Names

November 2, 2001

Frustrated By Field Minus Keys

Run CL Commands From Interactive SQL (Revisited)

October 31, 2001

Creating Flexible Join Files

Customizing Keyboards In Personal Communications

October 26, 2001

How Many Modules Should Be in a Service Program?

Changing IPL Default For Applying PTFs

October 24, 2001

Timing Out Sockets Programs

The Case Of The Missing Indexes

October 19, 2001

Extracting Packed Data From A Character Field

Running Perl On The AS/400 and iSeries

October 17, 2001

Automatically Reply To Inquiry Messages

Trapping An Eval Error

October 12, 2001

With SQL, Sometimes Less Is More

Run CL Commands From Interactive SQL

October 5, 2001

Avoiding Output From RUNSQLSTM

Linux Desktop Environment for iSeries

October 3, 2001

Finding FIXNBR

Editing in RPG III

September 28, 2001

Removing A Character From A Character Field

Which CL Messages Should I Monitor?

September 21, 2001

Trapping A Canceled RUNQRY Command

DSN-Less Connections Using ActiveX Data Object

August 30, 2001

Removing A Damaged PTF

Solving A Crystal Report SQL5001 Error


FORMER MIDRANGE PROGRAMMER

December 4, 2003

Customizing Your Development with Extensible RPG, by Joel Cochran

Persist Java Objects on DB2 for iSeries with JDO, by Marc Logemann

Back to Basics: Get That Code Out of Your RPG, by Kevin Vandever

OS/400 Alert: Microsoft Exposes IE to Hackers, by Shannon O'Donnell

November 20, 2003

Easy-to-Use User Indexes, by Bruce Guetzkow

Back to Basics: Data Entry Subfiles, by Kevin Vandever

How to Get New Shoes with Work-Flow-Oriented Menus, G. Wayne Hawks

OS/400 Alert: Native OS/400 Security Tools, by Shannon O'Donnell

November 6, 2003

JUnit Automates Java Testing, by David Morris

Back to Basics: Modifying a Subfile, by Kevin Vandever

Admin Alert: Hidden Secrets of the SBMJOB Command, by Joe Hertvik

OS/400 Alert: Filtering SMTP Server, by Shannon O'Donnell

October 23, 2003

Staggering SQL String Handling with Regular Expressions, by Michael Sansoterra

Binder Source: The Little Language That Could, by Joel Cochran

Control Access Path Rebuilding, by Kevin Vandever

OS/400 Alert: OS/400 Passwords Can Be Seen, by Shannon O'Donnell

October 9, 2003

Empower SQL with Java User-Defined Functions, by Michael Sansoterra

OS/400 Alert: All About HTTP Server, by Shannon O'Donnell

September 25, 2003

Putting User Spaces in Your Toolbox, by Bruce Guetzkow

Service Programs with a Smile, by Joel R. Cochran

Back to Basics: The Copy Screen Feature, by Kevin Vandever

OS/400 Alert: Security Is More Than Staying Current, by Shannon O'Donnell

September 11, 2003

iSeries Access for Web

Data Normalization, Part 3

Cast Your Data Conversion Troubles Away

OS/400 Alert: Nasty Little Viruses

August 28, 2003

Database Normalization, Part 2

The NULL Nemesis

Linux on iSeries Network Alternatives

OS/400 Alert: A New Feature for Midrange Programmer

August 14, 2003

Improved XML Validation with Schemas

CODE/400 Command Shell

July 31, 2003

BLOB Your Data for the Web

Debug iSeries Programs with the iSeries Distributed Debugger

Database Normalization, Part 1

Program Cloning to Prevent Overtime

July 17, 2003

Building Applications with Ant

Swapping AS/400 User Profiles

IBM's Toolbox for Java Is Getting Better Every Day

More on Edit Words

June 19, 2003

Making HTML as Functional as a Green Screen

Data Entry Robots

Dr. Programmer, Private Eye

Back To Basics: Edit Words

June 5, 2003

The Valuable NULL

Measuring Performance from the Java Side

Reading an IFS File from RPG

Become the Master of Your Subfile Domain

May 22, 2003

A Few More Pointers on Pointers

ADO/JDBC Performance Using Parameters

The iSeries: A Flexible and Integrated Environment for Linux

Back to Basics: Self-Extending Subfiles

May 8, 2003

WebSphere Development Studio Client for iSeries 5.0: Worth the Wait

iSeries Wireless Access with JDBC

Display AS/400 Data on a PDA

Back to Basics: Introduction to Subfiles

April 24, 2003

JAXB takes XML to Java

Scribble on SQL's Scratchpad

Using Pointer-Based Variables in RPG IV

Calling Java from RPG: A Refresher

April 10, 2003

Calling Java from RPG: Beyond the Basics

Just Push a Button to Get AS/400 Query Results in Excel

Distributing iSeries Java Applications with Web Start

An Alternative Method of Serving Web Pages from AS/400

March 27, 2003

Pivot Data with SQL/400

We're Off to See the Wizard of WebFacing

Creating and Consuming an AS/400 Web Service

The Java-Based iSeries System Debugger

March 13, 2003

iSeriesMonitorME: A Real-World Wireless iSeries Application

Implementing Check Constraints in Referential Integrity

Creating a Better iSeries Interactive Environment

Back to Basics: Pointers in RPG

February 27, 2003

iSeriesMonitorME: Set Up a Wireless Development Environment

Configuring Applications with XML

Web Services and the AS/400

The New CHAIN Operation: This Is Not Your Father's CHAIN Op Code

February 13, 2003

iSeries Web Services Revolve on Free Axis

Implementing Referential Constraints in Referential Integrity

Printing from Qshell

Prompting iSeries Commands: A Closer Look

January 30, 2003

Prompting iSeries Commands in Java

iSeriesMonitorME: An Intro to Wireless Programming with iSeries ToolboxME

Tired of Resetting Terminals on the AS/400? Let Somebody Else Do It, Part 2

Working with Visual Basic's Printer Object

January 16, 2003

Back To Basics: The Date Data Type

Supercharge Your Search and Replace Tasks

Tired of Resetting Terminals on the AS/400? Let Somebody Else Do It

Extending the Windows Shell with VBScript

December 5, 2002

Merging DB2/400 Data with a Microsoft Word Document

Where Are My Stored Procedures?

Climbing Mount WebFace: An Exploration of WebSphere Development Studio Client

Effective Object-Oriented Design with Design Patterns

November 21, 2002

AS/400 Reports On The Fly, From Any Database

Data Is Served: A VARPG Data Server

RPG Programs for Qshell

Back to Basics: Homegrown OS/400 Commands

November 7, 2002

Display Operations Navigator from a 5250 Green Screen

Add Oomph to Your Commands with Validity Checking Programs

Pack on the Calories with ListView Pudding

Batch Jobs Can Talk Back

Database Triggers: Add Consistency and Integrity to Business Logic

Use WebSphere Studio for Building Web Pages

October 24, 2002

Add a Safety Net with Journalized Data Queues

Creating Editable Web Pages

Using Data Queues in VARPG

Sprinkle GUI on your Green Screen Salad

Back To Basics: Windowed Subfiles

Easy Display File Printing

October 10, 2002

Performing Surgery on the Windows Registry

Back to Basics: Side-by-Side Subfiles

Referential Integrity: Ensuring Your Database Contains Only Valid Data

Qshell String Manipulation

Exploring Data-Type Acronyms

The Client Access Express Toolkit

September 26, 2002

Introduction to Win32 API Programming with VARPG

Accessing External Data Using DB2 UDB DataLinks

Qshell Functions

Sed, the Stream Editor

Back to Basics: Multiple Subfiles on One Screen

Create an Animated Chicken with VARPG

September 12, 2002

Java by Example with WebSphere Development Studio Client

DB2 Library Contents in Operations Navigator

Processing Command-Line Arguments in Qshell Scripts

How to Create Custom JSP Tags

Calling PC Commands from RPG

A Telnet Exit Program Tells You Who's Knocking At Your Door

August 29, 2002

Back To Basics: Message Subfiles

The 5250 Word Wrap Utility

Cool Things in CODE/400: A Bag Full of Tips

The Opportunity of a Lifetime

Security Made Easy with Operations Navigator

More on XLE and XML File Creation

August 15, 2002

VARPG Game Programming

Automate XML File Creation with XLE

Cool Things in CODE/400: Changing Your Library List

Using Tomcat Connection Pooling with Commons-DBCP

Forget To Handle Errors? Use an ILE Condition Handler

Back to Basics: Self-Updating Display File

July 18, 2002

Plug into Sockets

Access Windows Control Panel Using VBScript

Cool Things in CODE/400: Keyboard Shortcuts

How to Interact Directly with JavaBeans from JSPs

FTP Basics: Batch Processing

The Random Number Generator API

June 20, 2002

How to Convert HTML into a JPEG

Back to Basics: Designing iSeries Menus

A Poor Man's Data Query

iSeries Java Threading Considerations

June 6, 2002

How Do I Set My CLASSPATH? Let Me Count the Ways

VARPG and iSeries Databases

Create WAR Files with Sun's Free DeployTool

Qshell Pattern Matching

VARPG Subfiles: An Introduction

iSeries Toolbox for Java: Running an iSeries Command

May 23, 2002

JavaScript and the SHELL Command

Data Queue Basics

Simplify Java Web App Deployment with WAR Files

The Art of Globbing

Keyed Data Queues: The Key to Flexible Subfiles

Work with Active Jobs from Operations Navigator

May 9, 2002

Creating a VARPG Appointment Calendar

Dynamic Selection with Embedded SQL

Validating XML with a Document Type Definition

The Ins and Outs of Qshell

The iSeries Toolbox for Java: GUI-izing Program Calls

Exploring iSeries Navigator Application Administration

April 25, 2002

Empower Users with Embedded SQL

Fun with VARPG Radio Buttons

Simplify JSP Applications with JavaBeans, Part 2

Stream I/O in Qshell

The iSeries Toolbox for Java Does Service Programs

Learning Java by Example

April 11, 2002

VisualAge for RPG: Who Knew It Was So Much Fun?

Run SQL Scripts Using Operations Navigator

Success or Failure in Qshell Scripts

Simplify JSP Applications with JavaBeans, Part 1

JavaScript: Back to Basics

Tools from iSeries Java Toolbox: Pinging iSeries Services

March 28, 2002

Form Up to Learn About HTML Forms

Recursive Calls Using Subprocedures

Getting Started with XML

Working with Parameters and Variables in Qshell Scripts

Test Data Queue Applications Using Java

CODE/400's Code/Editor: Tips and Tricks

March 14, 2002

Displaying Static HTML Pages from the iSeries

ILE Static Binding

JSP Server-Side Error Handling, Part 2

Getting Started with Qshell Scripts

Introduction to Communications Console and CODE/400's Code/Editor

Call iSeries Programs Using SQL

February 28, 2002

The Basics of ILE Service Programs

Basic HTML: Headers, Bodies, and Flying Text

Getting Acquainted with Grep

JSP Server-Side Error Handling, Part 1

How Does Your Browser Find a Web Page?

Calling RPG Native Methods from Java

February 14, 2002

CL-Like Error Handling in RPG

Installing and Configuring Tomcat on iSeries

Learning Basic HTML Tags

Java Concepts for iSeries Programmers

Build Dynamic Web Apps With iSeries Tomcat

Five More Cool Things You Can Do With OpsNav

January 31, 2002

The Midrange Programmer Philosophy

Prototyping and Calling Java Methods from RPG

Coding SQL Functions in OS/400 V5R1

Subprocedures: Better than Subroutines

Five Cool Things You Can Do with OpsNav

Let Your Hair Down With Free-Formed C-Specs

January 17, 2002

Welcome to Midrange Programmer, OS/400 Edition

Determining a PC's IP Address

I Lost My License Key!

Calling a Program Using the iSeries Toolbox for Java

RPG Prototyping

JavaServer Pages 101





Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, 50 Park Terrace East, Suite 8F, New York, NY 10034
Privacy Statement