Current Issue: January 25, 2012
Limited Capabilities Workaround
qsort: A Better SORTA
How Do I Export an iSeries Certificate File?
January 11, 2012
New in DB2 for i 7.1: Use Global Variables to Track Environment Settings
IBM i and Zip Files
Admin Alert: Is It a Performance Issue or a Throughput Issue?
December 14, 2011
I Was Just Wondering. . .
End-of-Year Odds and Ends
Admin Alert: Hidden Parameters of the Submit Job Command
December 7, 2011
Juggling With jQuery
SQL Finds a Delta
Admin Alert: More Information on Semi-Restricted State, Vendor Profiles, and Storage Pools
November 30, 2011
Read Once, Update Many
Another IFS Interface
Why Are My Batch Jobs Running at Priority 20?
November 16, 2011
NULL and NOT IN
Wow! I Could Have Had Long Column Names!
Putting Your i System in Semi-Restricted State
November 9, 2011
Add Powerful Generic Processing to Your Applications
Meet JSON
Admin Alert: When You Can't Answer Record Lock Errors
November 2, 2011
Debugging Authority Failures, Part 3
Adaptable Data Areas
Admin Alert: What To Do with Vendor Profiles During an Audit, PLUS Two Other Great Features
October 26, 2011
10 Facts You Should Know about Special Values
VALUES: A Truly Useless DDS Keyword
Limiting How Much Memory a Storage Pool Can Allocate
October 19, 2011
Return a User Profile Listing to a .NET Client
Dealing with Faulty Logic
Admin Alert: Adding Redundancy to Power i SMS Monitoring
October 12, 2011
Adobe Flash Builder for the iSeries Programmer, Part 3
Add Outfile Support to Your Applications
Skipping Robot/SCHEDULE Runs on AS/400-Class Machines
October 5, 2011
Call Again and Again and Again...
Another Way to Pass Parms to SBMJOB
Admin Alert: How to Retrieve Password Parameters for Auditors
September 28, 2011
Data Needed to Debug Authority Failures, Part 2
A Better Way To Read a Job Log
Checking Cache Battery Status Without STRSST
September 21, 2011
Call-backs Simplify File IO
A Better Way to Display Quick 5250 Messages in RPG
Running Down Cache Battery Rumors and More on Damaged Objects
September 14, 2011
Learn To Debug Authority Failures, Part 1
Now Where Did I Leave That Source Member?
Admin Alert: Three Common Problems with CBUs
September 7, 2011
Adobe Flash Builder for the iSeries Programmer, Part 2
Dynamically Invoke SQL UDFs From RPG Code
Admin Alert: Starting Multiple PC5250 Sessions in a Batch File
August 24, 2011
An Indicator By Any Other Name
Add a Record to Any File
Admin Alert: Two PC5250 Configuration Secrets
August 10, 2011
Adobe Flash Builder for the iSeries Programmer, Part 1
ILE: Decisions, Decisions, Part 2
Admin Alert: An Alternate Way to Port Image Catalogs Between Systems: QFileSrv.400
July 27, 2011
REPLACE to Replace Characters in a String
Solving iSeries Access Data Transfer Problems and Detecting Disk Damage
Admin Alert: A Starter Program to Find Damaged Objects in i OS 6.1.1
July 20, 2011
INSERT to Overlay Positions in a Character String
Emulate RPG's Pessimistic Locking in SQL
Admin Alert: Porting an Image Catalog Between Power i Boxes using FTP
July 13, 2011
Running Totals in an SQL Query, Take 2
The DB2 DBA: Identifying Indexes with Shared Access Paths
How Do I Email a PC5250 Screen Shot?
June 22, 2011
SQL Implicit Cast of Character Strings and Numeric Values
Forcing Keyword Parameters
Admin Alert: Things to Think About in a Power i Development Environment
June 8, 2011
ILE: Decisions, Decisions, Part 1
Write PDM Scans to Database Files
Admin Alert: Things I Learned from My Latest Power i Upgrade
May 25, 2011
Finding Duplicate Rows in a Name and Address Table
Asserting the Ostensibly Unassertable
Admin Alert: Other Options for a Post-Upgrade Backup
May 18, 2011
An Introduction to Python on IBM i, Part 3
The Case of the Missing Logical File
Admin Alert: Running System i Cleanup Manually
May 11, 2011
Retrieve Column Descriptions in your ADO Client/Server Applications
Sharing Simplifies Source Code
Admin Alert: Critical Information That Every i Administrator Should Have Handy
April 27, 2011
DDS Design with RD Power
Updating Through a Join with SQL, Take Two
Why is my i/OS Email Coming Back Undeliverable?
April 20, 2011
Installing a PHP/MySQL Open Source Application on i
Stuff I Neglected to Mention on February 16, 2011
Best Options for Post-i 6.1.1 Upgrade Backups
April 13, 2011
A View of a View of a View
SQL Bar Charts
Admin Alert: The Four Faces of Software Vendors During a Hardware Upgrade
April 6, 2011
Taking RSE to Task
Today's Horoscope
Admin Alert: Must Your Rack Be IBM Black?
March 23, 2011
Duplicating an Entire Table or a Subset of a Table Using SQL
No Truncate Table? No Problem!
Automatically Deleting Spooled Files through Expiration Dates
March 16, 2011
Duplicating CPYF Function Using SQL
Circumventing Integer Division
Admin Alert: Corralling i/OS Storage Hogs, Part 2
March 2, 2011
Running Totals in an SQL Query
Odds and Ends: The Reader is the Guru
Admin Alert: Corralling i/OS Storage Hogs, Part 1
February 23, 2011
Secure DB2 for i Database Server Access by IP Address
Avoid Division by Zero in Query/400
Image Catalogs: Another Timesaving Method for Upgrade or Installs
February 16, 2011
Commands: Underused and Unappreciated
OUTQ vs. PRTDEV
Admin Alert: Six Techniques to Prevent Power i Upgrades from Slowing Down
February 2, 2011
Synchronize Your Outlook Calendar with DB2 for i ERP Data
Another Reason Why Function Subprocedures Should Not Modify Their Parameters
Admin Alert: QPWDRULES Rules!!! Opening Up User Password Options with i 6.1
January 26, 2011
A Reusable Routine for Doubly-Linked Lists, Part 2
Don't Let Users Wreck Their Joins
Why Can't I Move System Memory Between Partition?
January 19, 2011
A Reusable Routine for Doubly-Linked Lists, Part 1
Cleaning Up RSE Detritus
Solving PC5250 Printing Problems and Tweets About i/OS Error Messages
January 12, 2011
Implementing Binary Trees in RPG
Closing the Gaps
Admin Alert: Basic i/OS Error Monitoring and Response, Part 2
January 5, 2011
Implementing Linked Lists in RPG
How To Rename Your Local Database
Admin Alert: Basic i/OS Error Monitoring and Response, Part 1
December 15, 2010
Make SQL Edit the Way You Want It To
End of Year Miscellanea
Discovering Which Locked Object is Holding Up Your Job
December 8, 2010
The Top 10 IBM i Security Exposures, Part 2
Find Time and Date Durations in RPG
Admin Alert: The Nine Stages of a Power i Upgrade
December 1, 2010
The Top 10 IBM i Security Exposures, Part 1
Case-Sensitive SQL Identifiers
Admin Alert: Prototype Instructions for Running TCP/IP in i5/OS Restricted State
November 17, 2010
Large Subprocedure Return Values: V7 Brings Relief
Find Hidden IFS Files
Why Did Passphrase Activation Take Out My ODBC Connection?
November 10, 2010
Two Tips Are Better Than One
Down with Assumptions! Up with Diagnostics!
Admin Alert: Things to Think About When Changing Hardware Maintenance
November 3, 2010
An Introduction to Python on IBM i, Part 2
How To Print a Pointer Value
Admin Alert: Risk and the Power i Hardware Upgrade
October 27, 2010
DDS Design: The RD Power Way
Let One Row Represent a Group, Take 2
Printing Multiple PC5250 Screens at the Same Time
October 20, 2010
Rowing with Your OAR
Leave My Stream Files Alone, Please
How Do I Record a PC5250 Macro?
October 13, 2010
Don't Let Your RPG Just Drift, Grab an OAR!
Counterintuitive Table Creation
Admin Alert: Will i5/OS V5R4Mx Support Run Out on April 7, 2015?
October 6, 2010
Automate E-Mail Operations with Outlook and VBA
USA Time Format in Query for i, Redux
Admin Alert: Getting Started with i/OS Security Auditing, Part 2
September 29, 2010
RPG Sorting and Searching: A 7.1 Update
CASE Simplifies SQL Update
Feeding the Auditor: Taking Care of Problem User Profiles
September 22, 2010
Get Thee to the Web, Part 3
Merge Into the Synchronization Fast Lane with DB2 for i 7.1
Changing i/OS Password Expiration Settings
September 15, 2010
Get Thee to the Web, Part 2
Basing Pointer Variables in RPG: The Basics
Admin Alert: Getting Started with i/OS Security Auditing, Part 1
September 8, 2010
Get Thee to the Web, Part 1
Avoid an Unnecessary CPYF Error
Admin Alert: Placing Additional Restrictions on i/OS Passwords
August 25, 2010
An Introduction to Python on IBM i, Part 1
DB2 for i: Process Stored Procedure Result Sets as Cursors
Admin Alert: One Year Out--Preparing for Your Next Power IBM i Upgrade
August 11, 2010
Remove Trailing Blanks from Legacy Columns with the IBM OLE DB Providers
How Did I Do That?
Admin Alert: Six Things You May Not Know About i/OS Passwords
July 28, 2010
Using IBM Web Administration for i To Configure WebSphere Portal
Every Bucket Deserves a Descriptive Name
Allocating Enough System Storage to a Subsystem
July 21, 2010
AAA Secures IBM i Server
It's My (De)fault That You're a Zero
Admin Alert: The Poor Manager's 5250 Single Sign-On
July 14, 2010
Heads Up! Additional Configuration Required for Windows 7/Windows Server 2008 R2
Who's the Scoundrel That Corrupted My Database?
Admin Alert: Keep Your Data Synced Up During an HA Switch Over
June 30, 2010
Generic Database Access with .NET 2.0
Spaces, Braces, and Semicolons
High Availability Eliminates Disaster Recovery. . . Right?
June 16, 2010
Client/Server Performance, Part 1: Blocking
SQL Performance: IN vs. EXISTS
How Do I Tell These Partitions Apart?
June 9, 2010
Re-Adopt Authority Utility
Date Field Odds and Ends
Admin Alert: How To Run NetServer from the Green Screen in 10 Minutes
May 26, 2010
Five Steps To Monitoring Your Server Log on IBM i
Distinctly Speeding Up DISTINCT
Hey! What Happened To My Last Used Dates
May 19, 2010
Low Risk Authority Changes
Prompt and Submit CL Commands
Admin Alert: CBU Product License Keys Can and Will Suddenly Expire
May 12, 2010
Development Environments
Two Ways to Prevent Division by Zero in SQL
Admin Alert: Diary of a Production System Upgrade, Part 2
April 28, 2010
Files in Subprocedures
Let One Row Represent a Group
Admin Alert: Diary of a Production System Upgrade, Part 1
April 21, 2010
FAQs for MySQL and the DB2 Storage Engine
Yet Another Super-Easy Way to Copy a Spooled File from One Partition to Another
More on Whether IPLs Help System Performance
April 14, 2010
Query Control
Update One File Based on Another File
Admin Alert: Some Simple Ideas for Getting the Best System i Lease
March 31, 2010
Variable Procedure Calls in Free-Format RPG
Global Temporary Tables and Host Variables
Implementing 128-Character Passphrases in i/OS
March 24, 2010
Using UNION for Data Analysis
Include C Utilities in Your Developer Library
Internet Explorer 8 Doesn't Support HMC V7. . . or Does It?
March 17, 2010
The State of the UNION
A Good Use for Global Variables
Does An IPL Really Help Improve System Performance?
March 10, 2010
A Case for CASE
Job Descriptions: Underused and Underappreciated
Admin Alert: A Skeleton Checklist for Performing Power i Upgrades
March 3, 2010
Variable Program Calls in Free-Format RPG
How to Replace Display Files While They Are In Use
Admin Alert: Preparing Your CBU For a Real Emergency
February 24, 2010
Naming Idiosyncrasies with the DB2 Storage Engine for MySQL
How To Use the Inhibit Write Keyword?
Hunting Down Storage Hogs
February 17, 2010
Handling Constraint Violations in RPG
CPYTOIMPF Doesn't Create Column Headers, But You Can
Admin Alert: Six Things Power i Administrators Need to Know
February 3, 2010
What a Lifelong DB2 Fanatic Sees in MySQL
Read a Save File
Admin Alert: Did You Lose ECS on February 1?
January 27, 2010
Creating Yes/No Fields in SQL Queries
A Few Excel Export to CSV Tips
Admin Alert: Speeding Up i5/OS Access Path Rebuilds
January 20, 2010
Run SQL Scripts: Use Temporary JDBC Settings
Can a Function Return More Than One Value?
Admin Alert: Erasing i5/OS Disk for Fun and Compliance
January 13, 2010
Consume an IWS Web Service From a VB.NET Client
Joining Incompatible Data
FTPING i5/OS Files to a Unix Server
January 6, 2010
Let's Start Over With a New Beginning
A Helpful Tool for Dealing with Unexpected Problems
Admin Alert: Upgrading a 550 to a 520 with V5R4?
December 16, 2009
Encouraging Mere Mortals
Miscellaneous Comments from Readers
When i5/OS Backups Keep You Waiting
December 9, 2009
Prompting CL in Run SQL Scripts
Publish Result Sets Using Web Services and IWS
Admin Alert: The Ins and Outs of IBM Business Partners
December 2, 2009
Retrieving and Storing SQL Source for DB2 Database Objects
Ken Likes FMTDATE
Admin Alert: Creating a High-Priority Batch Subsystem
November 18, 2009
File Caching in RSE
Message Received, But Not Understood
More with the WDSc Tasks View
November 11, 2009
Enable Row Set Paging in a Client/Server Environment Using SQL
The Case of the Used Unused Object: A Mystery
Some Questions on Adopted Authority Programs
November 4, 2009
Enhancing CGIDEV2
A Quick-and-Easy Way to Convert Case in RPG Programs
Admin Alert: Keeping i5/OS Ethernet Lines Connected
October 28, 2009
Getting Started with RDi's Application Diagram, Part 2: Program Structure Diagram
Distinguish between Record Types without Indicators
How Much Temporary Storage Am I Using?
October 21, 2009
Getting the Message, Part 2
Passing an Entire Result Set as a Parameter, Part 2
Setting Up SNTP Time Synchronization on an i5/OS Box
October 14, 2009
Getting the Message, Part 1
How Do I Find What's Not There?
Admin Alert: Locking Down i5/OS System Security Values
October 7, 2009
Getting Started with RDi's Application Diagram, Part 1: Source Call Diagram
Passing an Entire Result Set as a Parameter: Part 1
Admin Alert: The Great CBU Survey and More
September 30, 2009
Subprocedure Return Values--Food for Thought
Mass Rename of IFS Files
When PC5250 Run the Same Doesn't Run
September 23, 2009
WDSC vs. RDi
Let's Start Over from the Beginning
The Cost of Not Backing Up
September 16, 2009
FROG: PC-based SQL for DB2 for i
Do-It-Yourself Data Types
Admin Alert: The Road to Live CBU Fail Over, Part 2
September 2, 2009
Use the Dup Key in Subfiles
An Overview of User-Defined Types in DB2 for i
Admin Alert: The Road to Live CBU Fail Over, Part 1
August 19, 2009
Validate DBCS-Open Data
Formatting Dates with SQL
Admin Alert: Correcting and Expanding the Program to Change User Passwords on the Fly
August 5, 2009
Designing DB2 for i Stored Procedures for Simulated Array Handling
Using Free-Format Calcs with Cycle Programs
Admin Alert: Changing User Passwords on the Fly
July 22, 2009
Circumventing Two Limitations of CPYTOIMPF
Comparing RPG and SQL Functionality
Admin Alert: Treating IFS Objects Like Stream File Objects
July 15, 2009
The Case of the Missing .NET Data Provider for i5/OS in Visual Studio 2008
Are MOVE and MOVEL Obsolete?
Restoring Spooled File Data After a System Restore
July 8, 2009
Microsoft Virtualization for the i Guys, Revisited
Subqueries vs. Joins
Admin Alert: Fine Tuning User Access with Application Administration
June 24, 2009
V6R1 Run SQL Scripts: Print and Save Result Sets
No More Global Variables!
Reader Input: /QOpenSys Redux, PC5250 Popup Keypads, and Even Farther Beyond Replication
Reader Feedback: Advanced DB2 for i Data Access Techniques with .NET
June 17, 2009
V6R1 Run SQL Scripts: Saving Scripts to a System i Source File
A Testing Tip
Admin Alert: A Simple Save While Active Backup Program
June 10, 2009
Configuring Run SQL Scripts for Ad Hoc Queries
Advanced DB2 for i Data Access Techniques with .NET
Taking Care of PC5250 Popup Keypad Problems
June 3, 2009
RPG Beans from VB Apps
Changing the Library List for Run SQL Scripts
Admin Alert: Beyond Replication in an i5/OS High-Availability Environment
From the IT Jungle Forums
May 20, 2009
Faster Fetching
A Bevy of BIFs: %Dec to the Rescue
Admin Alert: Four Ways to Encrypt i5/OS Backups, Part 2
From the IT Jungle Forums
May 13, 2009
A Not-Quite-As-Sleepy RPG Program
SQL's Other Fetch Options
Admin Alert: Four Ways To Encrypt i5/OS Backups, Part 1
From the IT Jungle Forums
May 6, 2009
Treasury of New DB2 6.1 (V6R1) Features, Part 6: Miscellaneous Enhancements
Having Fun with Javascript
What Happened to my i5/OS Crypto Access Provider?
From the IT Jungle Forums
April 22, 2009
Don't Ignore the View
Releasing File Member Locks With QSH
Trouble-Shooting i5/OS Printer Problems in a Warehouse Environment
From the IT Jungle Forums
April 15, 2009
A Bevy of BIFs: Dealing with a Bad Date
A Bevy of BIFs: %CHAR, %EDITC and %EDITW
Admin Alert: And /QOpenSys and /QOpenSys and /QOpenSys and. . .
Reader Feedback: Programming E-mail Notification When a Robot/SCHEDULE Job Fails
From the IT Jungle Forums
April 1, 2009
A Sleepy RPG Program
Treasury of new DB2 6.1 (V6R1) Features, Part 5
Admin Alert: Change Your Tape Drives, Change Your Tape Management Costs
From the IT Jungle Forums
March 25, 2009
Treasury of new DB2 6.1 (V6R1) Features, Part 4: Index and Data Type Enhancements
Looking for Commitment, Part 3
Catching Robot/SCHEDULE Job Failures As They Happen
From the IT Jungle Forums
March 18, 2009
Looking for Commitment, Part 2
Treasury of New DB2 6.1 (V6R1) Features, Part 3: Client Special Registers
Admin Alert: Changing your SMTP Server is Easy-ish
From the IT Jungle Forums
March 11, 2009
Looking for Commitment, Part 1
Treasury of new DB2 6.1 Features, Part 2: Grouping Sets and Super Groups
Admin Alert: Six Ways to Mess Up i5/OS User Profiles Security (And What To Do About It)
From the IT Jungle Forums
March 4, 2009
A Bevy of BIFs: %XLATE and %REPLACE
Send Messages Unto Others
Admin Alert: Things I learned About IBM Maintenance Contracts
From the IT Jungle Forums
February 25, 2009
A Bevy of BIFs: %SCAN and %CHECK
Easily Avoid a Common Data Structure Error
Admin Alert: Robot/SCHEDULE's DST Work-Around and More
From the IT Jungle Forums
February 18, 2009
A Bevy of BIFs: Getting a Date is Easy with %Date
Mismatched Record Name Formats? No Problem!
Admin Alert: Solving i5/OS Inquiry Message Whodunits
From the IT Jungle Forums
February 4, 2009
A Bevy of BIFs: Look Up to %LookUp
Treasury Of New DB2 6.1 Features, Part 1: Query Enhancements
Admin Alert: Time Gobbling Tasks for a System Upgrade
From the IT Jungle Forums
January 28, 2009
How To Read A Program
Load a Spreadsheet from a DB2/400 Database: Part 3
Admin Alert: Four Things to Beware of During a System Upgrade
From the IT Jungle Forums
January 21, 2009
Redundant Join Criteria: Good or Bad Idea?
Do Your File Specifications Lie?
Trouble-Shooting WebSM to HMC Connectivity Problems
From the IT Jungle Forums
January 14, 2009
Bypass Locked Records in SQL Queries
Data Queues vs. MQSeries
Admin Alert: Looking for i5/OS Trouble, Part II
From the IT Jungle Forums
January 7, 2009
Bypassing a Locked Record, Take Two
Be Specific When Updating With SQL Cursors
Admin Alert: Looking for i5/OS Trouble, Part I
From the IT Jungle Forums
December 17, 2008
Two A-maze-ing Programs
End-of-Year Odds and Ends
Admin Alert: Upcoming i5/OS and AnyNet End of Service Dates
From the IT Jungle Forums
December 10, 2008
Four Ways to Avoid Problems Caused by Global Data
Where's the Service Program?
Admin Alert: The Dangers of User Profiles with Privileges
From the IT Jungle Forums
December 3, 2008
There's Power in Edit Words
SQL and Conversion Strategies
Admin Alert: Tuning i5/OS Storage Pools for Performance
From the IT Jungle Forums
November 19, 2008
Getting Started With AJAX
Enable Programmatic Access to Remote DB2 Data Using DRDA
Admin Alert: When Batch Meets Interactive
From the IT Jungle Forums
November 12, 2008
What Is AJAX?
Retrieve the User ID at Run Time In a .NET Environment
Admin Alert: Readers Pimp Joe's Font, Win No-Prize
From the IT Jungle Forums
November 5, 2008
OPNQRYF Has No "If" But You Can Fake It
Embed PJL Statements in a Workstation Customizing Object
Admin Alert: Avoiding Restoration Problems with Remote Output Queues
From the IT Jungle Forums
October 29, 2008
Calculate a Fractional Number of Years Difference Between Two Dates in SQL
Meaningful Names for Null Indicators
Pimp My Font Size, Win a No-Prize
From the IT Jungle Forums
October 22, 2008
Visual Explain for Run SQL Scripts
SQL Quickly and Dirtily Extracts a Field from a CSV File
Healing Failed Windows-i5/OS FTP Transfers
From the IT Jungle Forums
October 15, 2008
Displaying Multiple Results Sets in Run SQL Scripts
A Practical Way to Add Exports to a Service Program
Admin Alert: Preventing Multiple IPs from Stopping Internet Traffic
From the IT Jungle Forums
October 8, 2008
Want a Fast and Easy Way To Sort Subfile Data?
Testing for Valid Data Representation in SQL
Admin Alert: When System Job Tables Attack, Part III
From the IT Jungle Forums
October 1, 2008
Keep Your Hands on the Keyboard with RSE
Simulate a Boolean Data Type in a Database Table
Admin Alert: When System Job Tables Attack, Part II
From the IT Jungle Forums
September 24, 2008
Variable-Length Database Fields Better Use Disk Space
Common Table Expressions Ease System Conversion
Admin Alert: When System Job Tables Attack, Part I
From the IT Jungle Forums
September 10, 2008
The Efficiency of Varying Length Character Variables
SQL Assist: Powerful Interactive SQL
Admin Alert: Getting into a i5/OS Restricted State
From the IT Jungle Forums
August 27, 2008
Automatic or Static Storage?
Jetty: An Efficient, Easy to Manage Alternative to WebSphere
Admin Alert: Giving Auditors What They Want
From the IT Jungle Forums
August 13, 2008
Serving Up Spreadsheets
V6R1 Enhancements for Run SQL Scripts
Admin Alert: Common Mistakes When Failing Over to a CBU
From the IT Jungle Forums
July 30, 2008
Tell Me About Your Exports
So That's What My Database Looks Like
Admin Alert: Moving i5/OS Resources on the Fly
From the IT Jungle Forums
July 23, 2008
Control the Library List from a SQL Server Linked Server Definition
Print Part of an IFS File
Using LTO 3 Tapes In an LTO 2 Drive
From the IT Jungle Forums
July 16, 2008
API Fun Time
Conditional Inserts with JDBC Prepared Statements
Admin Alert: A Client Access Mystery Solved. . . with No-Prizes!!!
From the IT Jungle Forums
July 9, 2008
PHP and the Zend Framework
A Handy SQL Timestamp Function
Reader Feedback: More on Preventing System Startup, Attention Lights, and Adding Drives
From the IT Jungle Forums
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, 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
