fhg

Current Issue: September 24, 2014

Testing The Ruby Waters

A Bevy Of BIFs: %ScanRpl (Scan And Replace)

Admin Alert: What's The Danger Zone For IBM i Disk Utilization?

September 17, 2014

Bash Is Not A Shell Game

Share And Share Alike With RSE

Restoring Passwords & Private Authorities When Using RSTUSRPRF

September 10, 2014

The Nearly Forgotten DSPLY Operation

DB2 for i 7.2 Features and Fun: Part 3

Admin Alert: Importing IBM i Spooled Files Into Excel

August 27, 2014

Creating A GUID In DB2 For i

Use SQL To Read IFS Directories

Automatically Detecting And Re-Enabling Disabled NetServer Profiles

August 13, 2014

The Geezer's Guide to Free-Form RPG, Part 5: File Definitions

Do It Now!

Admin Alert: More On Porting User Profiles Between IBM i Partitions

July 30, 2014

Decisions, Decisions: Templates Or Snippets?

How Do I De-Edit? Let Me Count The Ways

When IBM i RGZPFM Doesn't Want To Rebuild Access Paths

July 23, 2014

DB2 for i 7.2 Features And Fun: Part 2

Beefing Up The Job Log

Porting A User Profile From One IBM i Machine To Another

July 9, 2014

The Geezer's Guide To Free-Form RPG, Part 4: Prototypes and Procedure Interfaces

Advantageous Options

Admin Alerts: Old IBM i Backups, New Tricks

June 25, 2014

DB2 for i 7.2 Features and Fun, Part 1

Here's More Help For A Huge Hardship

Admin Alert: Reorganizing IBM i Files To Improve Disk Performance, Part 2

June 11, 2014

Custom Perspectives In RSE

Surmounting Identity Column Challenges

Admin Alert: Reorganizing IBM i Files To Improve Disk Performance, Part 1

May 28, 2014

The Geezer's Guide to Free-Form RPG, Part 3: Data Structures and More Data Definitions

DB2 for i 7.2 Functions, Functions, Functions

The IBM i Journal Cache Sweeper Knob

May 14, 2014

Using Built-In Global Variables In DB2 For i 7.2

Interpreting Stream File Timestamps

Admin Alert: When Journaling Slows Down Your System, And What To Do About It

April 30, 2014

Emulate sp_Help In DB2 For i

PDF = Pretty Darn Fine!

Where Do I Find These IBM i Licensed Products?

April 16, 2014

The Geezer's Guide to Free-Form RPG, Part 2: Data Structures and More

Here's Help For A Huge Hardship

Admin Alert: Elements Of An IBM i Incident Management Plan, Part 2

April 2, 2014

Embedded SQL Exception/Error Handling

Search Source Members For Two Or More Strings

Admin Alert: Elements Of An IBM i Incident Management Plan, Part 1

March 19, 2014

DB2 For i Table Function Performance Considerations

Quick And Handy RPG Input

Graphically Setting Up TCP/IP Host Routes With System i Navigator

March 12, 2014

Who Needs Custom Perspectives In RSE?

Quick And Handy RPG Output

What Should I Monitor For On My IBM i Partition?

March 5, 2014

DB2 For i Scalar Function Performance Considerations

Use Wireshark To Diagnose IBM i Communications Problems

Admin Alert: Setting Up IBM i TCP/IP Host Routes

February 26, 2014

The Case Of The IBM Systems Director And RBAC

The ADO Client Side Of Default Parameters And Named Arguments In DB2 For i

Auto-Answering Record Lock Errors And More On Returning An IBM i Box

February 12, 2014

Four Reasons RPG Geezers Should Care About The New Free-Form RPG

DB2 For i Odds And Ends

Admin Alert: Saying Goodbye To An Old Power i

January 29, 2014

The Case Of The Late Night FSM Explorer

DB2 For i, Java, And Regular Expressions

Admin Alert: Four Ways To Move An IBM i Partition, Part 3

January 15, 2014

Where Did My Faulting Guidelines Go?

Dynamic Compound Statements In DB2 For i

Admin Alert: Four Ways To Move An IBM i Partition, Part 2

December 4, 2013

End-Of-Year Feedback

Three Powerful SQL Words

Admin Alert: Four Ways To Move An IBM i Partition, Part 1

November 20, 2013

Allow Repeated Change With SQL Triggers

Alan's Easy Method For Building A CSV File From A Report

Minimizing IPL Surprises With The IPL Startup Kit

November 6, 2013

Allow Repeated Change With Before Triggers

Digging Out Data Duplication

Admin Alert: The 4 GB Access Path Size Time Bomb

October 23, 2013

Responsive Web Design

Make Your DB2 For i Apps Environment Aware

Admin Alert: A Primer For Setting Up PC5250 SSL Connectivity, Part 2

October 9, 2013

Open Access Handles The Queue

Anita's SQL Tips

Admin Alert: A Primer For Setting Up PC5250 SSL Connectivity, Part 1

September 25, 2013

Create A Generic Auditing Trigger With SQL

CPYFRMIMPF And Fixed Data

Cleaning Up Excessive Job Logs On Your IBM i System

September 11, 2013

Retrieve The Call Stack In DB2 For i

Thinking In Pointers

Admin Alert: Six Tips For Managing IBM i Spooled File Storage

August 21, 2013

Override Default Data Types In The SQL Descriptor

Join The Queue With Open Access

Which Job Is Filling Up My System Storage?

August 7, 2013

IFSPOP--Another (And A Better) IFS Interface

SQL and Invalid Decimal Data

Admin Alert: Budgeting For Your Next Power Systems Upgrade

July 24, 2013

Control The Flow Of Stored Procedure Result Sets

Value An Expression? *YES!

Automatically Answering IBM i Unable To Allocate Record Messages

July 10, 2013

Presenting Vertical Data Horizontally

First Normal Form On The Fly

Admin Alert: Major And Minor IBM i Power System Upgrades

June 19, 2013

Creating And Using i Project

Away With The SQL Slash Separator

Removing Members From And Deleting An i OS Group Profile

June 5, 2013

When Is A Source Member Not A Source Member?

Conditional SQL I/O

Admin Alert: Renewing A Default *System Certificate

May 15, 2013

Search SQL Source Using System Catalogs

Bind By Slash-Copy

Adding A Job Queue To A Batch Subsystem

May 1, 2013

Copy Source Members Between Systems Without FTP

Odds and Ends

Admin Alert: Six Things To Do Before Switching Production Processing To Your CBU

April 17, 2013

Encoding XML (Or HTML) From Within RPG

Extract Zoned And Packed-Decimal Values From Character Fields, Take Two

How Do I Load This Digital Certificate On My IBM i Machine?

April 3, 2013

Bringing Home The Data

Updating Through A Join With SQL, Take Three

Admin Alert: A Checklist For Monitoring Your IBM i Environment

March 20, 2013

Tips For Using RDP's DDS Designer

Using SQL Joins With Tree Structures

Using Incremental IFS Backup To Speed Up Backup Time

March 6, 2013

Journal Forensics 101

When Who Did What

Admin Alert: A Checklist For Moving Power i Partitions To A Different Location

February 20, 2013

Stored Procedure Parameter Defaults And Named Arguments In DB2 For i

New CL String-Handling Functions

Getting Short-Term Maintenance For Your Power i Machine

February 6, 2013

What's That Name, Again?

Don't Clone That Printer File!

Admin Alert: When Was The Last Time That Library Got Backed Up And More

January 23, 2013

Dealing With Library Lists In RSE/RDP

Easily Create Help Text For Commands

Stopping Unauthorized Users From FTPing To Your IBM i

January 9, 2013

What's New With CPYFRMIMPF And CPYTOIMPF?

Tracing Routines Explain Why The Computer Did What It Did

Admin Alert: Four Things To Do For Your IBM i In 2013

December 12, 2012

End-Of-Year Odds And Ends

BASS: Build A Spreadsheet

Admin Alert: Auditing Your IBM i Software Maintenance Bills

November 28, 2012

Write Your Own SCANRPL Built-In Function

Glenn Wants To Know More Facts About Special Values

Admin Alert: Strategically Using Power Systems' Processor Trial Capacity On Demand

November 14, 2012

Converting CASE in CL

Use SQL To Update A Sequence Number

Admin Alert: A Checklist For Performing IBM i Planned Maintenance

October 31, 2012

Running IBM i Access 7.1 and Windows 8

Data Structures Make Good Status Parameters

Changing Sub Tree Authorities In An IFS Folder

October 17, 2012

What's That Name?

Non-Equal (Theta) Joins

Admin Alert: One Year Out--Preparing For Your Next IBM i Upgrade, Part 2

October 3, 2012

Debugging Server Jobs In Green Screen

Alternatives To SQL Literals

Admin Alert: Seven Things You Should Be Monitoring On Your System

September 19, 2012

The New Basics: Indicators

OSHA Changes To IBM Battery Handling Affect Cache Battery Replacement

Admin Alert: Eternal Users: A Common Problem With IBM i Batch Jobs

September 5, 2012

Future Coding

Checking IBM i OS and PTF Level Status for Sarbanes-Oxley Documentation

Admin Alert: Two Useful PC5250 Parameters In IBM i Access For Windows 7.1

August 22, 2012

Composing An XML Document From Relational Data: Part 2

Where's The Module?

Admin Alert: Copying User Profiles Between Systems

August 8, 2012

Accessing Multiple DB2 Relational Databases In A Single Query

Composing An XML Document From Relational Data, Part 1

Admin Alert: The Right Way To Delete User Profiles, Part 2

July 25, 2012

Is An RPGOA-like Standard For HTML5 On The Horizon?

Copy Data From A Remote DB2 Database Using DB2 For i 7.1

Admin Alert: The Right Way To Delete User Profiles, Part 1

July 11, 2012

DB2 For i XMLTABLE, Part 2: Using Namespaces And IFS XML Files

RPG Subprocedure Error-Handling with APIs

Admin Alert: Making Run the Same Run the Same On IBM i Access 7.1 On Windows 7

June 27, 2012

Protect Your Intellectual Property: Obfuscate DB2 For i Source Code

Another Way To Skin A Generic Cat

Admin Alert: Finding TCP/IP Interface History And More On The NetServer GO

June 13, 2012

The New Basics

DB2 For i XMLTABLE, Part 1: Convert XML to Tabular Data

Admin Alert: Of Course, Everything I Know About NetServer Could Change

May 30, 2012

Preparing To Install IBM's RUNSQL Command

Eliminate The Legitimate Use Of GOTO

Three Ways To Fix NetServer Access Problems

May 16, 2012

Boolean Variables: Underused and Unappreciated

Generic Processing, Continued

Preventing Your System from Restarting After a Full System Backup

May 9, 2012

OLAP Is Simple, Once You Understand It

The Proper Way To Deallocate A Pointer

Admin Alert: Prepping For And Responding To An Unheard Of IBM i #FAIL

May 2, 2012

CL Error-Handling With APIs

How Do I Format Date Literals? Let Me Count The Ways

Admin Alert: Secrets Of The IBM i IPL Parameters

April 25, 2012

NOMAX? No Way!

Specify SQL Table-creation Library at Runtime

Getting PC5250 F1-F24 Keys to Work Correctly on HP Laptops

April 18, 2012

A Philosophically Engineered Approach to the Processing of Parameters

Have Your Cake and Eat It, Too

Admin Alert: Planning An i 6.1 Upgrade

April 11, 2012

Index Advisor, Part 2

Interpreted CL Members, Take 2

What Happened to My QFileSvr.400 Connection?

April 4, 2012

Index Advisor, Part 1

Cut the Gordian Knot

Admin Alert: Readers Check in on Four Simple Rules for PTFs

March 28, 2012

A Couple of RSE Quickies

Down with Dependence!

Just When Do IBM i PTFs Get Applied, Anyway?

March 21, 2012

Sharing In V6

*NOMAX Does Not Mean Infinite Capacity

Four Simple Rules For IBM i PTF Management

March 7, 2012

Commenting Interactive Code

Interpreted CL Members

Admin Alert: Getting Started With An i 6.1 Upgrade

February 22, 2012

bsearch: Partial Key Searches and More

Prompt Control Controls Parsimonious Command Prompting

Why Can't I Access My Remote System's AS/400 IFS?

February 8, 2012

bsearch: A Better %LOOKUP

Using JSON and RPG To Create Interactive Web 2.0 Applications

Admin Alert: QSECOFR Security Problems I Have Known

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




Senior Technical Editor: Ted Holt
Technical Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.






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

Privacy Statement