Current Issue: June 25, 2008
Keeping Time with NTP
What Happened to My Key?
Stopping Your System i from Starting Up
From the IT Jungle Forums
June 18, 2008
Creating an RPG-based Web Service Using WDSC, Part 1
SQL May Be Catching Up with DDS
Admin Alert: Redundancy is Good, Redundancy is Good, Re…
From the IT Jungle Forums
June 11, 2008
Keeping 5250 Alive
Seeking Advice on REXX
Admin Alert: All About the System i Attention Light
From the IT Jungle Forums
June 4, 2008
Exploring the DB2 for i5/OS Extensions to the PHP Language
Use Parameter Markers in SQL Persistent Stored Modules
Admin Alert: Quick Audits for i5/OS Backups
From the IT Jungle Forums
May 21, 2008
Use PCOMM Scripts to Dynamically Build a Spreadsheet, Part 2
Use SQL to Strip Out Tab Characters
Admin Alert: Monitoring the Monitors
From the IT Jungle Forums
May 14, 2008
Writing Secure PHP Applications
Use PCOMM Scripts to Execute Remote PC Commands
Admin Alert: Things to Do When Adding Drives to a System
From the IT Jungle Forums
May 7, 2008
Accurate Program References
Replace the Contents of a Physical File That Has Triggers
Admin Alert: How to Recreate/Restore a System Distribution Directory
From the IT Jungle Forums
April 30, 2008
Multiformat SQL Data Sets
Build Pivot Tables over DB2 Data
Solve a Client Access Mystery, Win a No Prize
From the IT Jungle Forums
April 23, 2008
A Recycle Bin for the IFS (Sort Of)
Performance Advice from a Mysterious Friend, Part 6
What is INZSYS, and Why Should I Care?
From the IT Jungle Forums
April 16, 2008
More about SQL and Logical Files
Performance Advice from a Mysterious Friend, Part 5
Admin Alert: V6R1 Changes for the i5/OS Administrator, Part 2
From the IT Jungle Forums
April 9, 2008
SQL Doesn't Like Logical Files
Performance Advice from a Mysterious Friend, Part 4
Admin Alert: V6R1 Changes for the i5/OS Administrator, Part 1
From the IT Jungle Forums
April 2, 2008
An Alternative to Externally Described Printer Files, Take 2
Performance Advice from a Mysterious Friend, Part 3
Admin Alert: How System i Boxes Impersonate Each Other, Part 2
From the IT Jungle Forums
March 26, 2008
One Save File from More than One Library
Performance Advice from a Mysterious Friend, Part 2
Admin Alert: How System i Boxes Impersonate Each Other, Part 1
From the IT Jungle Forums
March 19, 2008
Grouping a Union
Remember the Allocation
Stopping User from Using the System Request Menu
From the IT Jungle Forums
March 12, 2008
Detect Host OS and Client Version Levels within Client Software
More About SQL Correlation Names
Admin Alert: A Much Quicker Way to Move System i Objects Between Partitions
From the IT Jungle Forums
March 5, 2008
Performance Advice from a Mysterious Friend
Don't Let SQL Name Your Baby, Take 2
Admin Alert: When System i Ethernet Cards Stop Broadcasting
From the IT Jungle Forums
February 27, 2008
XAMPP: The PHP Developer's Dream
Programmatically Retrieve Defined System i Names
Admin Alert: Five Minutes to Moving System i Objects Between Partitions
From the IT Jungle Forums
February 20, 2008
Getting MySQL Working With PHP
LPEX Edit in Hex Mode
Configuring Messaging Software for Overnight Monitoring
From the IT Jungle Forums
February 13, 2008
IBM Apache Servers Needed by PHP
Microsoft .NET 2.0 for System i Developers: Building Windows Forms Using the DataGridview Control
Admin Alert: Printing and Emailing a System i Rack Config
From the IT Jungle Forums
February 6, 2008
Setting Up A PHP/Web Environment On System i: Where Do I Start?
Don't Let SQL Name Your Baby
A Checklist For Moving System i Boxes
From the IT Jungle Forums
January 30, 2008
Saving and Restoring External SQL Routine Definitions
Create Multiple Directory Levels in One Swell Foop
User Storage Limits and Application Processing
From the IT Jungle Forums
January 23, 2008
A Database Union is Not a Join
More About Blocking
Admin Alert: Before You Buy That New System i, Part 2
From the IT Jungle Forums
January 16, 2008
Bringing i5/OS Resources to the Web
Another Way to Sort a File
Admin Alert: Before You Buy That New System i, Part 1
From the IT Jungle Forums
January 9, 2008
Scrubbing Your Web Data with Elbow Grease and AJAX
Odds and Ends
Admin Alert: Making Educated Guesses on CPU Utilization
From the IT Jungle Forums
December 12, 2007
Use SQL User-Defined Functions to Avoid Data Repetition Problems
Stuff I Didn't Publish This Year
Admin Alert: Getting Started with Trial Capacity on Demand, Part 2
From the IT Jungle Forums
December 5, 2007
Create Multiple Directory Levels in One Swell Foop
Update Only One of Duplicate Records
Admin Alert: Getting Started with Trial Capacity on Demand, Part 1
From the IT Jungle Forums
November 28, 2007
System i Developers and .NET 2.0, Part 2: Web Development Using ASP.NET AJAX
ON vs. ON
Admin Alert: Basic Tools for the System i Admin Tool Chest
From the IT Jungle Forums
November 14, 2007
ON vs. WHERE
Odds and Ends
Admin Alert: How Big is My IFS?
From the IT Jungle Forums
November 7, 2007
V6R1 CL Enhancements
Copy Message Descriptions
Admin Alert: Five Benefits of a High-Availability System
From the IT Jungle Forums
October 31, 2007
Use PHP to Bring i5/OS Resources to the Web
Wrapping Free Form Text
Admin Alert: Limiting System i User Sign-ons the Smart Way
From the IT Jungle Forums
October 24, 2007
Good Reasons to Use Unrequired Correlation Names
Externally Described Database IO through Data Structures
Admin Alert: The System i High Availability Roadmap
From the IT Jungle Forums
October 17, 2007
Controlling System i Shutdown Activities Using An Intelligent Power-Handling Program, Part II
Converting LF to CRLF in IFS Files
Reader Feedback: More on Vendor Names and Changing System Names
From the IT Jungle Forums
October 10, 2007
Controlling System i Shutdown Activities Using an Intelligent Power-Handling Program, Part I
Programmatically Import Excel Worksheets Using IBM's ActiveX Object Library
Admin Alert: Remotely Accessing an HMC System Console, Part 2
From the IT Jungle Forums
October 3, 2007
IFS Commands Give You Generic Access
APIs Sometimes Fail (But Programmers Don't Have To)
Admin Alert: Remotely Accessing an HMC System Console, Part 1
From the IT Jungle Forums
September 26, 2007
Weird SQL UNION Results
A Snippet Above the Rest
Admin Alert: What Vendors Want to Know (and How to Get It)
From the IT Jungle Forums
September 19, 2007
System i Developers and .NET 2.0: ASP.NET and the Declarative Programming Model
Don't Disable Blocking
Admin Alert: When APPN Prevents You from Changing Network Attributes
From the IT Jungle Forums
September 12, 2007
Reuse Deleted Records? *YES!
Accessing File Member Timestamps from a .NET C# Program
Admin Alert: A Primer for Changing Your i5/OS Startup Program
From the IT Jungle Forums
August 29, 2007
PHP: An Easy Yet Powerful Language Syntax
I Want My F15 Back!
Admin Alert: Magical & Mysterious iSeries Access CWB Programs
From the IT Jungle Forums
August 22, 2007
If the Compiler Can't Find the Mistake, Maybe You Can
Commands with Generic Parameters
Troubleshooting NetServer File Copy Errors
From the IT Jungle Forums
August 8, 2007
Let WDSc Help You Format Your Source Code
Which One Is the Culprit?
Admin Alert: Eliminating Easy-to-Guess User Passwords
From the IT Jungle Forums
August 1, 2007
Use WDSc to Develop XSL Transformations
Have Your Cake and Eat It, Too
Admin Alert: Getting Around System i Default Passwords, Part 2
From the IT Jungle Forums
July 25, 2007
Avoid Large Local Variables in Modules
Memory Management: It's Your Fault, Now Fix It
Admin Alert: Getting Around System i Default Passwords, Part 1
From the IT Jungle Forums
July 18, 2007
Bring Back My Qshell Output
Customize the PC5250 Popup Keypad
Admin Alert: FTPing Save Files from Windows to i5/OS
From the IT Jungle Forums
July 11, 2007
Comment Your Binder Language
Load a Spreadsheet from a DB2/400 Database: Part 2
Admin Alert: More Info on SAVSYSINF, Green-Screen Printing, Performance PTFs, and Batteries
From the IT Jungle Forums
June 27, 2007
PHP on i5/OS: A Whole New Stack
Performance of Function Subprocedures
Admin Alert: Meditations on Full System Backups
From the IT Jungle Forums
June 20, 2007
Parameter Passing and Performance
Conditional Counting with Open Query File
What Is SMIOSTCPGT and Why Is It Eating My System?
From the IT Jungle Forums
June 13, 2007
Fix Decimal Data Errors
Joining on Mismatched Values
Admin Alert: Alternative Ways to Print PC5250 Screens
From the IT Jungle Forums
June 6, 2007
Special Files Can Do It All, Part 2
Load a Spreadsheet from a DB2/400 Database
Admin Alert: Weird i5 User Profile Sign-On Secrets
From the IT Jungle Forums
May 23, 2007
Send a Spool File from AS/400 with a Specific Subject Line and Message Body
Searching for Wildcard Characters
Admin Alert: i5 IPL Pre-Planning and Post-Planning Checklists
From the IT Jungle Forums
May 16, 2007
Groovy: A Powerful Scripting Language for Java Developers on System i
Old Programs Can Learn to Behave Themselves
Another Way to Retrieve i5 System Storage Space
From the IT Jungle Forums
May 9, 2007
WHERE Versus HAVING
Error-Checking Email Addresses, for Intelligent People
Admin Alert: The i5 Battery Checking Process
From the IT Jungle Forums
May 2, 2007
Monitor for Specific Messages in RPG
Overcome the Page Control Limitations of iSeries Access Printer Emulation Sessions
Admin Alert: Dealing with i5 Critical Storage Errors, Part 2
From the IT Jungle Forums
April 25, 2007
What Can I Select When I Group?
To Shift or Not to Shift: That Is in the Fourth Parameter
Admin Alert: Dealing with i5 Critical Storage Errors, Part 1
From the IT Jungle Forums
April 18, 2007
Calling SQL Functions Directly From a High Level Language Program
My Favorite Keyboard Shortcuts for RSE
Two Ways to Audit Your Backup Strategy
From the IT Jungle Forums
April 11, 2007
Missing In Action: The Full Outer Join
Reader Feedback on One-Man System i Shops
Admin Alert: The Process and Pitfalls of Duplicating Libraries
From the IT Jungle Forums
April 4, 2007
FTP Means 'First Try Pinging'
Improving Upon WDSC's Table View
Admin Alert: Graphically Moving i5/OS Objects with OpsNav
From the IT Jungle Forums
March 28, 2007
Two Views on the WDSc Snippets View, Part 1
The Case of the Missing Outline (View)
Admin Alert: Five Things that Kill Backups (and What to Do About Them)
From the IT Jungle Forums
March 21, 2007
iSeries Navigator Job Monitor
Reader Feedback on Using the SQL SET OPTION Statement
Changing ODBC Sign-On Pop Up Values
From the IT Jungle Forums
March 14, 2007
Release That Record Lock!
Giving RSE a Split Personality
Admin Alert: The Better Way to Send Break Messages to Active Users in i5/OS
From the IT Jungle Forums
March 7, 2007
Multiple Display Files in One Program
Three Little Words That Simplify Debugging
Admin Alert: Better Subsystem Throughput Via Multiple Job Queues, Part Two
From the IT Jungle Forums
February 28, 2007
Determining the Value of Built-in I/O Functions
Customize the Tab Key in WDSc
Admin Alert: Better Subsystem Throughput Via Multiple Job Queues, Part One
From the IT Jungle Forums
February 21, 2007
Get Connected with Remote Systems Explorer
A Handy Tip for Testing Batch Job Streams
Admin Alert: Automatically Moving Printed Spooled Files Between Output Queues
From the IT Jungle Forums
February 14, 2007
Be Content with Content Assist
The Long and Short of Setting Up Level 40 Security
What Happened to My Backup?
From the IT Jungle Forums
February 7, 2007
Opportunities, Not Problems!
SQL Cross Platform Interoperability: The Proper Function
Admin Alert: Selectively Sending Break Messages to Active Users
From the IT Jungle Forums
January 31, 2007
Finding the Last Transaction for a Customer
Sorting Arrays and Subfiles with a User Index
When Fix Central Won't Let You Download PTFs
From the IT Jungle Forums
January 24, 2007
Using the SQL SET OPTION Statement
Legible PATH and CLASSPATH
Admin Alert: Updating Your System i5 for Daylight Saving Time Changes
From the IT Jungle Forums
January 17, 2007
Using APIs to Send Impromptu Messages, Take Two
Gotcha Lurking in Datalink File Manager for DB2/400
Admin Alert: Ending Subsystems Properly
From the IT Jungle Forums
January 10, 2007
Exporting DB2/400 Dates to Excel
Resetting Your QSECOFR Service Tools Password
Admin Alert: Combating Cross-Server Failures for the i5 Manager
From the IT Jungle Forums
December 13, 2006
Stuff I Didn't Publish This Year, by Ted Holt
The System i and Office 2007, by Michael Sansoterra
Admin Alert: More Information on Fixed Storage and WRKSYSACT, by Joe Hertvik
December 6, 2006
Easily Calculating Statistical Functions, by Ted Holt
More About Commands and Variable-Length Parameters, by Ted Holt
Admin Alert: Quick and Dirty Ways to Find Job Gone Wild, by Joe Hertvik
November 29, 2006
Powerful Stuff: Creating Commands with Variable-Length Parameters!, by Ted Holt
Harnessing Your ODBC Users with Exit Programs, by Bob Butcher
Using Different ODBC DSN Types for i5 Access, by Joe Hertvik
November 15, 2006
Create Database Files from SQL Queries, by Ted Holt
Stream Files and End-of-Line Delimiters, Take Three, by Ted Holt
Admin Alert: Three Steps to Mapping iSeries Data to a Windows Network Drive, by Joe Hertvik
November 8, 2006
Get Creative Using the SQL Database Exit Point, by Michael Sansoterra
Finding Large IFS Directories, by Ted Holt
Admin Alert: The Rule of Fours for i5 Test Environments, by Joe Hertvik
November 1, 2006
Using i5/OS Performance Adjuster to Better Manage Memory, by Doug Mewmaw
The RUN Utility: Call a Program with Correctly Formatted Parameters, by Ted Holt
Admin Alert: Using Remote OUTQs to Cover for Broken Printers, by Joe Hertvik
October 25, 2006
Using Parameter Markers with SQL Functions, by Michael Sansoterra
Stuffing Five Digits Into Four, Take 2, by Ted Holt
Admin Alert: The Pitfalls of Duplicating Data to a Test Library, by Joe Hertvik
October 18, 2006
The SPACE Function Takes Up a Lot of Space, by Ted Holt
Declare the BINARY Data Type Using DDS, by Michael Sansoterra
Using FTP to Transfer Multiple Files Between Windows and the i5, by Joe Hertvik
October 11, 2006
CL Odds and Ends, by Ted Holt
Use SQL to Remove Extra Spaces, by Ted Holt
Admin Alert: The Ins and Outs of Loading Licensed Program Products, by Joe Hertvik
October 4, 2006
Kevin Juenemann's Quick Query Utility, by Ted Holt
Remove Blank Lines from a Stream File, by Ted Holt
Admin Alert: Changing Physical File Characteristics on the Fly, by Joe Hertvik
September 27, 2006
Copy a Subset of Records from One System to Another, by Ted Holt
Stuffing Five Digits Into Four, by Ted Holt
Admin Alert: Setting the Record Straight on iSeries Access and ODBC Freeware, by Joe Hertvik
September 20, 2006
Redirecting a List of Qshell Commands, by Ted Holt
Include Comments in Query/400 Queries, by Ted Holt
Admin Alert: Dissecting the Unusual QLGPGCMA.LOCALE Error, by Joe Hertvik
September 13, 2006
Developers Don't Despair: Virtualize Your PC, by Michael Sansoterra
Unusual But Logical SQL Sorting, by Ted Holt
Admin Alert: One Common Cure for SQL0901 Package Errors, by Joe Hertvik
August 30, 2006
Undocumented Debugger Function, by Ted Holt
EDTF and End-of-Line Delimiters, Take Two, by Ted Holt
Admin Alert: Four iSeries Access Tips for Windows Professionals, by Joe Hertvik
August 23, 2006
Quick Query Over a Database File, by Ted Holt
iSeries Navigator Performance Advisor, At Your Service, by Jeff Waldbillig
Joblogapalooza, Its Possible Causes, and a Call for Input, by Joe Hertvik
August 9, 2006
Mystifying OS/400 and i5/OS Mathematics, by Howard Arner
Append to Stream Files, by Ted Holt
Admin Alert: Running Green-Screen Commands from OpsNav, Part 2, by Joe Hertvik
August 2, 2006
Print PC Documents to iSeries Printers, by Ted Holt
Find Messages That Contain a Text String, by Ted Holt
Admin Alert: Running Green-Screen Commands from OpsNav, Part 1, by Joe Hertvik
July 26, 2006
EDTF and End-of-Line Delimiters, by Ted Holt
Another Super-Easy Way to Copy a Spooled File from One Machine to Another, by Ted Holt
Admin Alert: Automatic Ways to Assign Group Authorities to an Object, by Joe Hertvik
July 19, 2006
Don't Depend on Arrival Sequence, by Ted Holt
A Super-Easy Way to Copy a Spooled File from One Machine to Another, by Ted Holt
Admin Alert: PC5250 Session Files--Where to Find Them, Where to Store Them, by Joe Hertvik
July 12, 2006
Unix Calls from OCL, by Ted Holt
Recursive Queries on the iSeries and System i, by Michael Sansoterra
Admin Alert: Moving a Subsystem into its Own Shared Pool, by Joe Hertvik
June 28, 2006
Query/400 Handles Zero Dates (Sort Of), by Ted Holt
No Automatic Casting for Char, by Howard Arner
Admin Alert: Creating More Distinctive PC5250 Window Titles, by Joe Hertvik
June 21, 2006
Guru Readers Contribute Their Favorite SEU Tips, by Ted Holt
Autostarting WAS 6.0 on the System i, by Brian Kelly
Reader Feedback on Setting Library Lists, by Joe Hertvik
June 14, 2006
New in V5R4: OLAP Ranking Specifications, by Michael Sansoterra
Avoid Locked Display Files/Resetting Page Numbers, by Ted Holt
Admin Alert: How to Set i5 Library Lists for 5250 and Batch Jobs, by Joe Hertvik
June 7, 2006
Database Output from CL, by Ted Holt
V5R4 Security: Rochester Rests Not on Its Laurels, Part 2, by Steve Martinson
Admin Alert: Preparing Your i5 Shop for a Pandemic, by Joe Hertvik
May 24, 2006
Thinking in Sets, by Ted Holt
Present Timestamps in the Local Time Zone, by Michael Sansoterra
Admin Alert: Setting Up Unattended i5 Server IPLs, by Joe Hertvik
May 17, 2006
Debugging iSeries Java Applications Remotely, by Mike Brown
Common Sense Comparisons, by Ted Holt
STRCPYSCN: The Poor Man's 5250 Remote Control Program, by Joe Hertvik
May 10, 2006
V5R4 Security: Rochester Rests Not on Its Laurels, Part 1, by Steve Martinson
Dynamically Sized Arrays, by Ted Holt
Admin Alert: The Case of the Mysterious CPI0999 Storage Error, by Joe Hertvik
May 3, 2006
SQL Goodies in DB2 for i5/OS V5R4, Part 2, by Michael Sansoterra
V5R4 Improvements to the i5/OS OLE DB Providers, by Michael Sansoterra
Admin Alert: Building a Better Experimental Automatic Deletion Technique, by Joe Hertvik
April 26, 2006
Converting Unconvertible Dates Using SQL, by Ted Holt
Auditing of Sensitive Users and Objects, by Steve Martinson
Allowing User Profiles Without Passwords to Sign On, by Joe Hertvik
April 19, 2006
Where's the Other MBROPT Option?, by Ted Holt
CL's Null Value, by Ted Holt
Admin Alert: An Experimental Technique for Automatically Deleting User Profiles, by Joe Hertvik
Job Posting Areas Created on the IT Jungle Forums
April 12, 2006
SQL Goodies in DB2 for i5/OS V5R4, Part 1, by Michael Sansoterra
Lesser-Known SEU Commands, by Ted Holt
Admin Alert: Another Way to Move Devices Between Systems, by Joe Hertvik
April 5, 2006
Avoiding the Green Screen of Death in RPG Programs, by Ted Holt
Change a Substring with SQL, by Ted Holt
Admin Alert: Protecting Your System from Critical Storage Errors, by Joe Hertvik
March 29, 2006
What's New in V5R4 COBOL?, by Ted Holt
How Many Rows Did SQL Fetch?, by Ted Holt
Setting Up User Profiles Without Passwords, by Joe Hertvik
March 22, 2006
The ARCHIVE Utility, by Ted Holt
A Java Developer's First Deployment on the iSeries, by Mike Brown
Admin Alert: Moving Printer Devices and Remote Outqs Between Systems, by Joe Hertvik
March 15, 2006
How to Cancel a Job, by Ted Holt
iSeries Security Journal Receiver Management, Part 2, by Steve Martinson
Admin Alert: Two Tricks for Better Printer Control, by Joe Hertvik
March 8, 2006
Perform the Impossible: Update a Multi-Table View using INSTEAD OF Triggers, by Michael Sansoterra
Installing WebSphere and the Update Installer, by Brian Kelly
Stopping i5 UPS Usage Before Something Ugly Happens, Part 2, by Joe Hertvik
March 1, 2006
A (Relatively) Easy Way to Process Parameters as an Array, by Ted Holt
Omit Commas from Numeric Dates, by Ted Holt
Admin Alert: Moving Libraries Between i5/OS Partitions, Part 2, by Joe Hertvik
February 22, 2006
V5R4 RPG Enhancements, by Ted Holt
Readers Write about the INCR and RRN Functions, by Ted Holt
Admin Alert: Moving Libraries Between i5/OS Partitions, Part 1, by Joe Hertvik
February 15, 2006
RPG Looks into the Future, by Ted Holt
Work Fields and SQL, by Ted Holt
When Users Need to Create Duplicate Objects, by Joe Hertvik
February 8, 2006
V5R4 CL Enhancements, Revealed and Detailed, by Ted Holt
iSeries Security Journal Receiver Management, Part 1, by Steven Martinson
Admin Alert: Creating an i5/OS User Profile Architecture, by Joe Hertvik
February 1, 2006
A FUNction to Align Text, by Ted Holt
Alternatives to Clear Physical File Member, by Ted Holt
Admin Alert: Six Simple Rules for OS/400 Group Profiles, by Joe Hertvik
January 25, 2006
Today's Special: Data Area Surprise!, by Ted Holt
Use SQL to Run PDM Options?, by David Morris
Admin Alert Feedback: Quicker Ways to Change Library Object Ownership, by Joe Hertvik
January 18, 2006
Handling Oversized Character Values Gracefully, by Ted Holt
WDSc's Outline View is Handy, by Ted Holt
Changing Object Authorities and Ownership for an Entire Library, by Joe Hertvik
January 11, 2006
Alternate SQL Row-Selection Criteria, Take 3, by Ted Holt
Indicate Negative Numbers with Parentheses, by Ted Holt
Admin Alert: Limiting *PUBLIC Access to i5/OS Objects, Part 2, by Joe Hertvik
January 4, 2006
Properly Placed Procedures, by Ted Holt
V5R3 SQL Insert Improvement, by Ted Holt
Admin Alert: Limiting *PUBLIC Access to i5/OS Objects, Part 1, by Joe Hertvik
December 14, 2005
Numbering Rows in an SQL Result Set, by Ted Holt
List Signed On Users From a Web Page, by Shannon O'Donnell
Admin Alert: The Great i5/OS Job Hunt, by Joe Hertvik
December 7, 2005
Find the Length of a Character String in CL, Take Two, by Ted Holt
Installing WebSphere Application Server 6.0, by Brian Kelly
Admin Alert: Backing Up i5/OS Partitions to Disk, by Joe Hertvik
November 30, 2005
Everything You Ever Wanted to Know About Converting Dates, by Bruce Guetzkow
Editing Numbers in CL, Take Two, by Ted Holt
Selectively Deleting OS/400 Spool Files, by Joe Hertvik
November 16, 2005
API Corner: Backup APIs, by Shannon O'Donnell
Two Handy Programs, by Ted Holt
Admin Alert: Darn Good FTP Commands You've Probably Never Heard Of, by Joe Hertvik
November 9, 2005
A Handy RPG FUNction, by Ted Holt
Edit Spooled Files with SEU, by Ted Holt
Admin Alert: Use Remote Output Queues to Share Printers Between Partitions, by Joe Hertvik
November 2, 2005
Be Sure Qshell Accesses the Right IFS Data, by Ted Holt
Restricted Access to SST, by Wayne O Evans
Admin Alert: Hidden Secrets of the i5/OS Save Commands, by Joe Hertvik
October 26, 2005
How to Count with SQL, by Ted Holt
Those Stupid Quotation Marks!, by Ted Holt
Admin Alert: New TCP/IP Functions to Check Out When Upgrading to i5/OS V5, by Joe Hertvik
Correction: Bugged by the Bugged by Interactive Debugger Tip, by Brian Kelly and Joey Maniskas
October 19, 2005
Find the Length of a Character String in CL, by Ted Holt
Bugged by the Interactive Debugger, by Brian Kelly and Joey Maniskas
Admin Alert: How to Change OS/400 Command Default Parameters, by Joe Hertvik
October 12, 2005
Absolute Versus Relative Paths, by Ted Holt
Get to Know Some Powerful CL Commands, by Bruce Guetzkow
Admin Alert: Reader Feedback on Limiting Users with *ALLOBJ Authority, by Joe Hertvik
October 5, 2005
REXX Can Talk to Other Languages, by Bruce Guetzkow
The Dangers of Dynamic SQL, by Ted Holt
Shutting Down WRKSBMJOB Options, by Joe Hertvik
September 28, 2005
API Corner: Database APIs, by Shannon O'Donnell
SQL Record Selection with Dynamic Lists, by Ted Holt
Admin Alert: Limiting the Long Reach of OS/400 Security Officers, by Joe Hertvik
September 21, 2005
When There's No Room for Special Values, by Ted Holt
Odd Ways to Round Numbers, by Ted Holt
Admin Alert: A Checklist for Creating OS/400 User Profiles, Part II, by Joe Hertvik
September 14, 2005
Much Ado about Nothing: Interesting Facts about Null, by Ted Holt
Great Minds Agree: It's Good to Save Access Paths, by Ted Holt
Admin Alert: A Checklist for Creating OS/400 User Profiles, Part I, by Joe Hertvik
August 31, 2005
Let's See Those Command Parameters, by Ted Holt
Submit a Prompted Command to Batch, by Ted Holt
Admin Alert: Changing Your Mind When Loading Group PTFs, by Joe Hertvik
August 24, 2005
Embedding SQL in RPG IV--Episode II, by Joel Cochran
A Speedier CHGPF, by Ted Holt
Admin Alert: Common Things to Do When Installing Third Party Products, by Joe Hertvik
August 10, 2005
Embedding SQL in RPG IV--Episode I, by Joel Cochran
Editing Numbers in CL, by Ted Holt
Five Ways to Access IFS Data from a Windows PC without FTP, by Joe Hertvik
August 3, 2005
API Corner: List Spooled Files From an Application, by Shannon O'Donnell
Avoid Changed Default Values, by Ted Holt
Admin Alert: Making OS/400 Automatically FTP to Windows, by Joe Hertvik
July 27, 2005
Of Middle-Tested Loops, by Ted Holt
Use SQL to Easily Update Multi-Key Files, by Ted Holt
Admin Alert: To Each Its Own in Spooled File Management, by Joe Hertvik
July 20, 2005
API Corner: Using the User Profile Exit Programs, by Shannon O'Donnell
Case-Insensitive Sorting and Record Selection with Query/400, Take Two, by Ted Holt
Admin Alert: Three Keys to Better ODBC Library List Management, by Joe Hertvik
July 13, 2005
CHGPF Quirk, by Ted Holt
What Program Uses That File?, by Ted Holt
Admin Alert: Turning Off ODBC Query Timeout Limits, by Joe Hertvik
June 29, 2005
API Corner: TCP/IP List Network Interfaces to a Browser, by Shannon O'Donnell
Remove Misleading Messages from Job Logs, Take Two, by Ted Holt
Admin Alert: Three iSeries Access Data Transfer Download Tricks, by Joe Hertvik
June 22, 2005
Execute SQL Statements on DB2 UDB for Windows from the iSeries, by Michael Sansoterra
Case-Insensitive Sorting and Record Selection with Query/400, by Ted Holt
Turning Off ODBC Journaling Is Not a Good Idea, by Joe Hertvik
June 15, 2005
Query Active Directory from the iSeries, by Michael Sansoterra
Fetch a Variable Number of Records with SQL, by Ted Holt
Admin Alert: A Quick Audit of Your IPL Parameters, by Joe Hertvik
June 8, 2005
Error Checking and Embedded SQL, by Ted Holt
Query/400 Does Exponentiation, Sort Of, by Ted Holt and Bob Ellsworth
Admin Alert: A Better Technique for Detecting Invalid Log-In Attempts, by Joe Hertvik
May 25, 2005
Creating Pivot Tables on the iSeries, by Bruce Guetzkow
File Members and the Library List, by Dominic Lefevre
Admin Alert: Configuring Windows Desktops to Use SSO, by Joe Hertvik
May 18, 2005
Prevent Access to System Request Menu, by Shannon O'Donnell
Use SQL to Send Database Files via FTP, by David Morris
Admin Alert: Configuring an i5/OS-based EIM Table for Single Sign-On, by Joe Hertvik
May 11, 2005
Use Field Names for Column Headings, by Ted Holt
Viewing and Printing the Euro Symbol, by Dale Downing
Scanning QSYSOPR for Selected System Messages, by Joe Hertvik
May 4, 2005
Use Special Files to Access the IFS, by Ted Holt
Take Two: Where Did I Come From?, by Ted Holt
Admin Alert: Configuring i5/OS and a Windows Network Server for SSO, by Joe Hertvik
April 27, 2005
A Simple Encryption/Decryption Algorithm for Numbers, by Victor Pisman
Suppress Runtime Display When Qshell Cancels, by Ted Holt
Admin Alert: Getting Ready for Single Sign-On, by Joe Hertvik
Jungle Chatter--Forum Discussions
April 20, 2005
Integrating iSeries Host Applications into Portals, by Marc Logemann
Increase the System Inquiry Reply Line Size in WebFacing, by Michael Sansoterra
Bullet-Proofing OS/400 User Profiles from Automatic Disablement, Expiration, by Joe Hertvik
April 13, 2005
Special Files Can Do It All, by Ted Holt
Not Wanted: That Kind of Native RPG Browser Support
Admin Alert: The Joys and Pains of Automatically Disabling User Profiles, by Joe Hertvik
April 6, 2005
Using FTP to Poll for File, by David Morris
Yet Another Way to Build a Tab-Delimited File, by Ted Holt
Admin Alert: Using OS/400 Prestart Jobs for Repetitious Server Processing, by Joe Hertvik
March 30, 2005
Transferring Save Files, by Bruce Guetzkow
Is My Job Finished? by Ted Holt
Readers, Vendors Weigh In on Native Browser Support
March 23, 2005
Existence Tests and Left Exception Joins, by Ted Holt
Where Did I Come From? by Ted Holt
Wanted: Native RPG and COBOL Support for Browsers, by Brian Kelly
March 16, 2005
Rounding Over a Set of Rows, by Michael Sansoterra
More About the SAVRSTxxx Commands, by Ted Holt
Admin Alert: Using OS/400 Autostart Jobs for Repetitious Server Processing, by Joe Hertvik
March 9, 2005
Recursion and the Alternatives, by Ted Holt
PC5250 and the Print Key, by Ted Holt
Admin Alert: Creating a Save Changed Objects Backup Tape, by Joe Hertvik
March 2, 2005
Embedding SQL in /free, by Joel Cochran
Much Ado About an Override, by Ted Holt
Admin Alert: IBM Has Changed the +/- One Release Rule for V5R1 Upgrades, by Joe Hertvik
February 23, 2005
CPYSPLF and AFPDS, by Ted Holt
SQL Can Return One or a Few Records, by Ted Holt
Admin Alert: Configuring Output Queues to Print Multi-Copy Spooled Files on Remote Printers, by Joe Hertvik
February 16, 2005
OPNQRYF and ILE, by Ted Holt
Remove Misleading Messages from Job Logs, by Ted Holt
Admin Alert: Making a Remote Output Queue Look Like a Printer Device, by Joe Hertvik
February 9, 2005
The Integrated File System for Intelligent People, by Ted Holt
Limiting All-Object Authority, by Wayne O. Evans
Running Query Without Adopted Authority, by Ted Holt
February 2, 2005
Repeated Characters in SQL, by Ted Holt
Yet Another Way to Build CSV Files, by Ted Holt
Admin Alert: Things to Check After Upgrading OS/400 V5R1 to V5R3, by Joe Hertvik
January 26, 2005
An Introduction to WDSc Table Views, by Bruce Guetzkow
Another Reason to Use P-Fields, by Ted Holt
The Save-Restore Commands, by Ted Holt
January 19, 2005
Date-Handling in CL Procedures, by Ted Holt
Extracting Zoned and Packed Decimal Values from Character Fields, by Ted Holt
Admin Alert: More on Preparing for OS/400 V5R1 to V5R3 Upgrades, by Joe Hertvik
January 12, 2005
More on RPG Encapsulation, by Joel Cochran
Advanced Pattern Matching in RPG, by Michael Sansoterra
The Dangers of Temporarily Changing User Profiles, by Ted Holt
January 5, 2005
Get Organized with the WDSc Tasks View, by Bruce Guetzkow
How to Use the *NOPASS and *OMIT Parameter Options, by Joel Cochran
Admin Alert: Preparing for an OS/400 V5R1 to V5R3 Upgrade, by Joe Hertvik
December 8, 2004
RPG IV Comment Blocks, by Ted Holt
Controlling PC Access, by Wayne O. Evans
Admin Alert: Use Fix Central to Order iSeries PTFs on CD-ROM, by Joe Hertvik
December 1, 2004
Submit Job Schedule Entries Immediately, by Ted Holt
V5R3 CL Enhancements on V5R2, by Ted Holt
Admin Alert: Tips for Dealing with Deleted Records in AS/400 Files, by Joe Hertvik
November 17, 2004
Discover the DBVisualizer, by Kevin Vandever
Creating Effective Passwords, by Wayne O. Evans
Admin Alert: More on Safely Deleting User Profiles, by Joe Hertvik
November 10, 2004
Executing Dynamic Calculations with Embedded SQL, by Michael Sansoterra
Let Me Out of Here! by Ted Holt
More Conditional Sorting with SQL, by Ted Holt
November 3, 2004
A Different Perspective on WDSc, by Bruce Guetzkow
Qshell Logout Script, by Ted Holt
Admin Alert: Safely Deleting a User Profile, by Joe Hertvik
October 27, 2004
Sending E-Mail from RPG, Take Two, by David Morris
Spool Control Authority Is a Security Risk, by Wayne O. Evans
Monitoring for System Request Menu Option 2, by Ted Holt
October 20, 2004
Prolong the FTP Experience, by Ted Holt
Presenting the CHGATR Command, by Ted Holt
Admin Alert: Cracking the Obscure CWBLM0029 PC5250 Error, by Joe Hertvik
October 13, 2004
Anatomy of a P-Field, by Dominic Lefevre
Use System Naming Convention and Library List with .NET Managed Provider, by Michael Sansoterra
Handling Oversized Numbers Gracefully, by Ted Holt
October 6, 2004
A Generic Command Choice Validity, by Bruce Guetzkow
Conditional Sorting with SQL, by Ted Holt
Admin Alert: Make User Profiles Go Cross-Partition with OpsNav, by Joe Hertvik
September 22, 2004
A Generic Command Choice Program, by Bruce Guetzkow
Command Authority and LOGCMD, by Wayne O. Evans
Optional Parameters and CL Procedures: Valuable Info from IBM
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, b