AutoInc SQL function
A little help when you need it
Easy way to comment out a block of code
Add useful company information to your signon display each day
Look what SQL Between can do
History log tips
Display a scrolling message in your RPG application
Job submitted from which Jobq
More on sending message to a screen
WRKJOB with System Request
Group Job menu
Batch FTP commands
Print/Display indicators used in source members
Debugging connection problems
Additional comment on "Little-known end job command provides big help"
Slow inserts in DB2
Lists real connected ODBC users
CL command prompt from menu
Optimize for one row
Finding tablespaces not copied in n days
Convert spooled files to HTML (CVTSPLHTM)
Quickly find changes in SEU
PDM & SEU professional programmer options
Ending the correct TCP/IP connection
Throw-back to S36 days and "POP"
How to delete the information on the local topology database
Need to configure AS/400's network attributes?
Splitting spool files using a user-controlled print file
Find file in query
How to add confirmation to critic commands
Find duplicate records quick and easy with SQL
Additional comments on QSYSOPR MSGQ
Bypass the configuration wizard with CA Express
Take a break from your work and increase your productivity
Locating a User Profile--alternative method
Shortcut for tape drive -- SAV command
Notifying the operators of any error message even if they are not SIGNED ON
More on retrieving query source
Sign-on to the same system using different profiles!
Using the iSeries as an e-mail clearing house
Login access when QINTER subsystem is down
Use SQL to change files
Where did my output print?
DB2 system parameters
Send messages that get attention
Locating a user profile
Use the EDTF command to delete Directories
Power-charged spool file utility
Re: Retrieving query specifications programmatically for search capabilities
SCANQRY command to scan query programs
Create your own shortcuts for often-used commands
User-defined commands to the rescue
SQL to select last day of month
DB2 SQL to return name of the day of the week
Use QShell to delete a folder including subfolders and files
Adding new code
Suppress the output to a printer file via job switches
Phoenix rises; Las Vegas soars
Finding a database field
Changing SEU length to 112
IBM's changing information on the sign-on screen without recompiling
Easy way to e-mail spool files
Random number generator -- and calling C functions from RPG
Pop-up command line window
Why write these long command names?
Morning check for the system
Easy way to save ALL spool files
Query supports date arithmetic
Retrieving query specifications programmatically for search capabilities on file specs, etc.
Save and rerun SQL statements
Use security audit for your applications
AS/400 response time is slow
Increase productivity using REXX
Commands ---an even easier way
Run a PC command from the AS/400
More on CHGPF command
Compile physical file without any data Loss
Command-Line with sys-request
Calculating dates by query
Commands -- An easier way!
Backups and monitoring help ensure system uptime
Work with job schedule entries?
What is hogging our system?
Object management -- Take 2
No SEU? Use SQL!
ISeries 400 objects -- An easier way
Additional tips on FTP
How to substitute Purchase for 'P' and 'Manufacturing' for 'M' .
Copy multiple spool files at one time using Operations Navigator
Dynamically reorganizing DB2 files -- Take 2
Display messages almost anywhere
Run remote command exit program
Highlight source program
Figuring out the metrics of 'five-nines'