Tips

Tips

Integrated File System (IFS)

• Securing the integrated file system on IBM System i

  Securing the nested directory files within the integrated file system (IFS) on the AS/400 requires a different strategy than the more familiar native file system. The IFS includes the familar native file system (QSYS.LIB) as well as the QDLS file ...  Continue Reading

• An automated CL method of moving a query from AS/400 to Excel

  If a daily task of your AS/400 is to print a report from a query a CL program can be written to automate the task and make it easy to open the results in Excel. This CL program copies an existing query to QTEMP and runs the query. Then it converts ...  Continue Reading

• Display documents on your iSeries -- quick and easy

  Somewhere along the line, the DLO (i.e. Document Library Objects) system became somewhat reliant on OfficeVision. Sure, you can navigate around the DLO system with i5/OS DLO commands, but you are pretty much limited to displaying just the names of ...  Continue Reading

• Cleaning up unused or temporary IFS files – Part II

  In a previous tip, "Cleaning up unused or temporary IFS files -- Part 1" Ron Turull introduced you to the code for the DELIFSFILE utility. In part II, Ron discusses the code in detail, including customizing the command, things to watch out for and ...  Continue Reading

• Cleaning up unused or temporary IFS files -- Part 1

  Deleting object in the IFS is a simple process. However, there is no mechanism on the iSeries that allows you to selectively delete IFS files based on certain criteria, such as the file type or the number of days the file has been unused. What do ...  Continue Reading

• Create Excel column headings from DDS column or text headings

  Learn an easy way to send the DDS column headings along with the data when creating a CSV file on the iSeries.  Continue Reading

• Proper IFS security setting

  How do you set the IFS security so a manager can access the IFS files from her PC applications but none of the clerks can? Security expert Carol Woodbury has a suggestion.  Continue Reading

• Things to watch out for when auditing IFS objects

  What do you do if you need to audit an object in the IFS? iSeries security expert Carol Woodbury shows you.  Continue Reading

• Deleting PC files on the iSeries

  An ITKnowledge Exchange(ITKE) recently member had a question about deleting PC files on the iSeries, and fellow techies jumped in on the conversation and helped out.  Continue Reading

• Security Tools can help manage your system security

  You don't need to look far for tools to manage your system's security. Included in your iSeries is a generous set of utilities that can help you.  Continue Reading

• Identify files used in all queries

  Identify files used in all queries in a library, library list or ALLUSR.  Continue Reading

• Client Access Express password cache

  Stop that darn pop-up window from appearing when you're trying to connect to Client Access.  Continue Reading

• Check constraint allows database admins to sleep a bit better at night

  You can easily prevent errant programs from writing invalid data to a field with a simple constraint.  Continue Reading

• Tips for i5 eServer Hardware Management Console (HMC)

  Allyn Walsh answers user's questions regarding Hardware Management Console (HMC).  Continue Reading

• Avoid locking issues

  Avoid locking issues due to users not signing off  Continue Reading