Tips
Tips
-
Monitoring document sizes in QDLS
Make it easier on your administrator when it comes to tracing files. Continue Reading
-
Monitor your job
Site expert John Kohan provides a way to determine when a batch job is in a "MSGW" (Message Wait) status in QBATCH. Continue Reading
-
Clear data queues -- easily
Take the pain out of clearing a large data queue. Continue Reading
-
Rebuild Access Path after hard crash
Hard crash drive on your iSeries? Try this command. Continue Reading
-
How to set up a system resource accounting system -- Part 1
Need to determine which users or departments are doing what? The iSeries is set up to provide such information through a system resource accounting system. Continue Reading
-
Use function keys without response indicators
Cut down on the number of indicators used in your program. Continue Reading
-
Using "exception join" in SQL
SQL's "exception join" syntax is rarely understood and even more rarely used. Continue Reading
-
Display Log (QHST) -- revisited
Displaying the history log for the previous day. Continue Reading
-
RPG data structure arrays improvement over multiple-occurrence data structures
Ron Turull compares data structure arrarys and multiple-occurrence data structures. His opinion: Data structure arrays prevail. Continue Reading
-
Debug batch job with STRISDB
Learn how to use the interactive source debugger to debug RPG programs submitted in batch jobs. Continue Reading
-
Read all the records in the subfile
Search400.com expert John Kohan shows you how to read the subfile by employing the "CHAIN" opcode using the RRN. Continue Reading
-
DSPLOG QHST for a specific time
Alleviate the task of having to check the save operation on multiple machines. Continue Reading
-
Complete cleanup for your iSeries system
Reducing the ASP utilization percentage. Continue Reading
-
How to map the entire IFS to a PC drive
Information in the previous administrator tip about mapping an IFS to a PC drive had some users scratching their heads. Ron Turull goes back and shows you the various ways. Continue Reading
-
Commands to display/change the ASP threshold
Display/change the ASP Threshold -- without using 'STRSS. Continue Reading
-
The ins and outs of *INLR
How you can use the last record indicator to your advantage. Continue Reading
-
Check object existence using IFS API
This solution uses one of the IFS Unix-type APIs that gives direct feedback on the existence of any object. Continue Reading
-
WDSC: How to build a Java Web application calling RPG
Learn how to take an existing RPG and CL program you've created and Web-enable them with the Web Interaction wizard in WDSC. Continue Reading
-
Understand all your trace options, including the latest one -- STRTRC
Find out the advantages and the disadvantages of the new trace facility, STRTRC. Continue Reading
-
Add notes/comments to FTP output logs
Easily add notes or comments to FTP output logs with command FTPNOTE and program FTPNOTER. Continue Reading
-
Easy IFS object/directory size report
Here's an easy and FREE method of getting a report showing the folder size and links for the IFS on your system. Continue Reading
-
DB2 regular expressions for the SQL-challenged
A short (and wacky) introduction to regular expressions in DB2. Continue Reading
-
Understanding and taking advantage of the IFS
You need a comprehensive understanding of the IFS to perform routines saves and restores. Continue Reading
-
Ten things to remember when using the IFS
Using the IFS can be a little tricky. Ron Turull gives you 10 things to keep in mind. Continue Reading
-
The iSeries & AS/400 Programmer's Guide to Cool Things
In this chapter they examine how to make the most of this functionality to help to integrate your 400 with PCs and LANs. Continue Reading
-
Working with APIs and user spaces
Several IBM system-supplied APIs use user spaces, so it's important to know what they are and how they work. Continue Reading
-
Restarting QINTER over network
Locked out a system because QINTER was down? If you have the correct authority within the system, FTP may provide a solution to this problem. Continue Reading
-
Working with triggers
A trigger in DB2 is a set of actions that will be executed when a defined event occurs. Here's a brief introduction. Continue Reading
-
How to update iSeries databases using JDBC, SQL
The techniques detailed here will help you develop more efficient Java database applications. Continue Reading
-
Is the file empty? Use NBRCURRCD to check
Downloading empty files to the server can cause errors. Check to see is files are empty first. Continue Reading
-
Create native excel files (XLS) on the iSeries using Java
Here a way to create native Excel files on the iSeries that will give you programming control over the cells formatting. Continue Reading
-
Easily handle multi-line parameters when parsing custom commands
Here's a tip to work with multi-line parameters when parsing custom commands. Continue Reading
-
Running the Domino console without default settings
This tip describes how to run the Domino console without the default settings. Continue Reading
-
Read a message queue like a physical file
Learn how to read a message queue like a physical file in this tip. Continue Reading
-
Utility helps you trace RPGLE programs
Need to trace an RPGLE program? Forget F10=Setup. Try this utility instead. Continue Reading
-
Convert cases in CLP
This is a quick sample CL program that uses QLGCNVCS to convert upper and lower cases. Continue Reading
-
Working with menus, pull downs, push buttons and scroll bars
Here's an example of a menu system used for the user(s) attention key program. Continue Reading
-
Global variables with EXPORT and IMPORT keywords
Here's a way to share the information between two programs that you may not be aware of. Continue Reading
-
STRHOSTSVR *ALL...NOT!
If you ever get the advice to STRHOSTSVR *ALL but it doesn't help, this might be why. Continue Reading
-
Display messages, screens in a different language
Using the MSGCON keyword, you can easily display messages in different languages. Continue Reading
-
Export all the tables in a given schema
This ksh script will log into the database, find all tables in the given schema, create the export script and run it. Continue Reading
-
Little-known feature of the CPYFRMIMPF command
Learn how to better use CPYFRMIMPF to ease the aggravation when importing delimited data from other systems. Continue Reading
-
Access a PF member data without using OVRDBF command
Learn an easier way to access a PF member data without using OVRDBF command. Continue Reading
-
Who is locking those file records?
Eliminate the frustration of struggling to find out who locked the file records. Continue Reading
-
Build data structures from any screen or database file
This code will build a set of "DS" D-Specs for each record format based on DSPFFD of the display or database file. Continue Reading
-
Similar 'group by', but horizontal in SQL
With this technique you can totalize in columns with a unique SQL instruction. Continue Reading
-
Subfile 'More...' made easy
Get a subfile to display the "More..." or "Bottom" automatically. Continue Reading
-
Sort your TCP/IP host table entries by host name
View or print your entries in your TCP/IP host table easier when they are sorted by the host name. Continue Reading
-
Create a clustered index on primary key
Here's a way to create a table with a clustered index on a composite primary key. Continue Reading
-
Put dynamic text on your iSeries sign-on screen
This sign-on screen layout will help you to inform your users about system downtime or any other important information. Continue Reading
-
Automatically rebuild logical files
Automatically rebuild logical files after changing a physical file. Continue Reading
-
Better tests for function keys in RPG
Use INFDS in the WORKSTN device to test for the ENTER key. Continue Reading
-
Copy a file to CSV, with column headings
This command will copy any DB2/400 file into a CSV file in the IFS. Continue Reading
-
Take command of your commands
User-defined commands help simplify your programs. Continue Reading
-
Use SQL to SELECT data directly to a CSV file
This command will direct the results of any valid SQL SELECT statement directly into a CSV file in the IFS . Continue Reading
-
Add column headings to a CSV file
Command ZFFDTOCSV uses information from a file's field descriptions to create a "heading" row in a CSV file. Continue Reading
-
Avoid having to create a new version file
Learn how to avoid create new version File (xxxx0001)or Member(xxxx0001) on RSTOBJ, RSTLIB commands? Continue Reading
-
Reorg and runstats in a ksh script
You can reorg and runstats in a single ksh script. Continue Reading
-
Abbreviated commands save precious time
Abbreviate often-used commands and save time as well as reduce input errors. Continue Reading
-
Better way to compare source codes
Alternative to the CMPPFM command. Continue Reading
-
Ping a server/machine in a batch job
Here's another method that uses the 400 ping command and allows you to account for sometime hic-ups in system response Continue Reading
-
Can't ESCAPE from SQL?
ESCAPE from SQL with this detailed tip. Continue Reading
-
FTP tips you might not know about
Here's a collection of FTP tips that address such subjects as the batch FTP process and logging FTP results to a file. Continue Reading
-
A security no-brainer: Analyze default passwords
Run or view the Default Password report each week to prevent security soft spots. Continue Reading
-
Check your licensed programs
This program notifies you if there's a problem with your system. Continue Reading
-
A primer to writing TCP/IP exit point programs
Learn how to use a TCP/IP exit point program and create log to record log-ins. Continue Reading
-
Access MS SQL server from iSeries using JDBC
A sample Java code is presented to demonstrate how to start a Microsoft SQL server job from the iSeries. Continue Reading
-
Insert, delete, and update files from CL
Manipulate file contents from CLP. Continue Reading
-
String compression on iSeries using zLib
The public domian zLib product is an excellent tool for compressing and uncompressing data files. Continue Reading
-
Convert BLOB to CLOB
This Java code helps convert BLOB data in a column into CLOB. Continue Reading
-
Printing techniques: Enhance reports with highlighted or underlined text
Learn how to highlight or underline fields using RPG specs or printer files. Continue Reading
-
Display program information with API QCLRPGMI
Find out which programs are running under the owner authority instead of user authority. Continue Reading
-
List the contents of the IFS directory
List the contents of the IFS directory without using the C function. Continue Reading
-
WebSphere Commerce Suite: Enabling SSL for the IBM HTTP Server and WebSphere Payment Manager
Follow these steps to enable the SSL protocol for the IBM HTTP Server for iSeries. Continue Reading
-
Logical files in different library than physical files
Here's a simple way to list logical files in a different library rather than its associated physical file. Continue Reading
-
Override files with out using the OVRDBF command
Learn how to override files with out using the OVRDBF command. There's no need to open and close each file in succession. Continue Reading
-
Message handling in RPG
This tip provides advice on message handling in RPG to help you avoid terminating a program or job. Continue Reading
-
Three ways to configure remote outque to LAN printers
Here are three ways to configure a remote outque to a LAN printer. Continue Reading
-
The new AS/400-to-PC transfer request
The data transfer component of Client Access has come a long way. Continue Reading
-
Delete PTF Save Files and save space
A common problem that iSeries shops face is how to save space. Learn how to save space by deleting PTF Save Files. Continue Reading
-
Finding version information in DB2 UDB for Windows and Unix
Use this tip to find version information in DB2 UDB for Windows and Unix. Continue Reading
-
Transform XML into iSeries readable form, easily
This tips helps in the tedious task of writing RPGLE code to parse XML documents. Continue Reading
-
Inserting CLOB data into DB2
This tip helps solve the problem of inserting CLOB data into DB2 on OS/390. Continue Reading
-
Quickest way to get PF to save file, and back
In this tip you'll learn a simple way to extract data from a save file into a database file. Continue Reading
-
Shortcut keys for cut and paste
Customize your Client Access keyboard setup. Continue Reading
-
Auto refresh screen - Data queue style
Here's a different technique to auto refresh a screen. Continue Reading
-
AS/400: System, Utilities, Database, and Programming
This chapter provides an overview of the AS/400 models. Continue Reading
-
Use group profiles for easier security admin
How to set up and manage group profiles. Continue Reading
-
Add some colors to your sources
Learn how to add color to your sources to have them really stand out. Continue Reading
-
Convert spool file to image file
There has always been a need to convert spool file into PC supported file for many reasons. Continue Reading
-
Date manipulation in SQL
Work with date manipulation within SQL. Continue Reading
-
Who said you can't write to file from CL?
Here you'll learn how to write to a specified Physical File from within CL. Continue Reading
-
Six quick tips for working with DDS
Here are a few DDS tips when working with logical files, including resizing a field and renaming a function. Continue Reading
-
Use CPU utilization guideline values to monitor high-priority (interactive) jobs
Monitor CPU utilization for critical apps and get performance warnings in advance. Continue Reading
-
Limit access to workstations
How to limit access to workstations. Continue Reading
-
Main storage (RAM) -- How much do you have?
Determine how much main storage (RAM) you have. Continue Reading
-
Convert spooled files to PDF using Java
The iSeries command SPLTOPDF is presented which converts spooled files to PDF files. Continue Reading
-
User-defined options make it easier to work with source objects
Learn more about 'User Defined Options' call utility programs in this member submitted tip. Continue Reading
-
Save time and aggravation -- automate FTP data transfers
Automate the transfer of libraries from one iSeries to another using batch files and your PC as an immediate host. Continue Reading
-
Close cursors when SQL is embedded
This tip shows you how to close any open cursors in your program. Continue Reading