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