Email Alerts
-
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 sys... Tip
-
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 th... Tip
-
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 th... Tip
-
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 mo... Tip
-
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 you... Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip