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
