-
SQL Updates with functions
How to code an SQL UPDATE on AS/400 with mathematical functions is explained by Kent Milligan.
-
Killing option 21 backup midsave
Is it a backup sin to kill or end the process once an AS/400 system is in the midst of an option 21 backup? The good news is that doing this doesn't destroy files on your disk, but it does make the...
-
Getting modules to adopt authorities from the main program
Using an AS/400 program with modules that do user profile maintenance? What if all the modules don't adopt the same authority, and thus abend? Ken Graap provides an elegant solution: set your modul...
-
SQL statement history storage
Hitting the wrong button in iSeries can cause a serious headache. If you have exited an STRSQL session without saving and want to retrieve your lost information, you may be out of luck. But Scott I...
-
Setting up an automatic reply in the system reply list
AS/400 systems can use the system reply list to automatically reply, but only if the inquiry message reply attribute is specified as INQMSGRPY(*SYSRPYL).
-
Clearing physical member file records
If you are trying to clear a physical member file, but get a message that says: FILE *** in LIBRARY *** is in use, what do you do? Scott Ingvaldson provides a quick fix.
-
Drive space management commands
Helpful commands to manage drive space and view disk status.
-
Group PTFs
Do you want to know what group PTFs are? Better yet, do you want to know which ones may be installed on your AS/400? Scott Ingvaldson explains what they are and why they exist, and best of all, whe...
-
Space offset X'0015FF00' or X'0000000000000000' is outside current limit for object QIGC2424C
When AS/400 running STOP gives the error message 'Space offset X'0015FF00' or X'0000000000000000' is outside current limit for object QIGC2424C', the value being given to the space pointer is great...
-
iSeries application display subfiles with other program windows
In iSeries, the display file for programs may need to be set to DFRWRT(*NO) to display other program windows when using multiple programs jointly. DFRWRT(*YES) tells the workstation controller to '...
-
Searching fields for values
In AS/400, if you need to find database fields that contain a specific value, in ILE RBG the field to use is D1FIND. The trick is that you have to add code to turn all search terms into uppercase, ...
-
Searching part of a name or address in AS/400
In ILE RPG code can be written to conduct the search on part of a name or address using the field D#SFLN.
-
Transferring data via FTP on AS/400 systems
Using the iSeries' built in FTP server to transfer data between two AS/400 systems is explained, with step-by-step instructions.
-
Ensuring sufficient iSeries system backup for data protection
Ken Graap explains how an option 21 save (full system save) once a month is not sufficient to protect system disk information if only a daily data backup is conducted.
-
Finding initialization information for LTO tapes in AS/400
How to find the initialization information for LTO tapes in AS/400 may not be possible without the job log of the job that performed the INZTAP command.
-
Alternatives to ODBC
If ODBC seems to be slow, it may be because of the SQL server. But alternatives exist, such as the ado.net
-
How to combine multiple spooled files into a PDF
Chip Milosch responds to a reader question about combining multiple spool files into a single bookmarked PDF using SpoolFlex.
-
Remote *LAN printer configuration: Not printing full documents
Configuring a remote *LAN printer to print full documents, ensuring that the *DEVD uses proper port values is key to avoiding time out or contention issues.
-
Cleaning up overlayed documents
Chip Milosch answers a question on cleaning up scanned images used as an overlay in AFP Workbench Viewer before printing using the AS/400.
-
How to view AFP print spools remotely
In this ATE response, Chip Milosch explains how to user iSeries Navigator to view AFP spool files.
-
Running AS/400 query to find records based on date
Learn about a quick way of running an AS/400 query to select records based on current sysdate.
-
Consolidation across multiple LPARs using BRMS
The BRMS Network feature allows a BRMS system to connect to other BRMS systems via a network, and enables a user to consolidate media such as backu...
-
Options other than RCLSTG to enable file journaling?
The only option to correct damage preventing file journaling is to use the RCLSTG command.
Submit a question to our experts