List all files in an IFS Folder with QSHELL

To list all files in an IFS (Integrated File System) folder using QSHELL on an IBM i system, you can use the “ls” command. Here’s a simple example:

1. Open QSHELL:

QSH

2. Navigate to the desired directory:

cd /path/to/your/IFS/folder

3. List all files:

ls -a

If you want to list files with specific details or in a sorted manner, you can modify the command. For example, to list all files including hidden ones and sort them, you can use:

ls -al | sort

This command will list all files (-a), provide detailed information (-l), and sort the output.

...

IBM i, Modernization, SQL

Converting an old PF to a shiny modern SQL TABLE

Converting an old Physical File (PF) to a modern SQL table can significantly enhance your database’s functionality and performance. Here are the general steps to achieve this: Here’s a simple example of how you might convert a PF to an SQL table: Creating SQL TABLES is easy – so How do we convert old DDS …

IBM i, SQL

Adding UP with IBM i SQL

Playing with SQL on the IBM i System: IBM-i Aggregate Functions In the world of data management, SQL (Structured Query Language) stands out as a powerful tool for querying and manipulating databases. Among its many features, aggregate functions are some of the most valuable yet often underutilized capabilities. These functions allow you to perform calculations …

IBM i, IFS, SQL

How can I find the largest IFS Folders on my IBM i System? #FATFOLDERS

Or — Two cool techniques to find the largest IBM i IFS Folders But first, what is the IFS? The IBM i Integrated File System (IFS) is a component of the IBM i operating system. It provides a unified interface for accessing and managing different types of file systems, similar to those found in personal …

IBM i

IBM i ACS and its weird AUTO UPDATE function!?

IBM Access Client Solutions (ACS) has a feature to check for updates automatically. You can enable this feature by selecting the “Check for Updates” option under the Help menu of the ACS Main User Interface. Alternatively, you can go to Edit -> Preferences and select “Notify when update is available”. So, you run the update …

Expanding Size RPGLE Subfile

...

Load All RPGLE Subfile

...

Single Page RPGLE Subfile

...

A Strangers (Dodgy) Sample Subfile Program

...

Programming – Everything You Wanted To Know About Subfiles But Were Afraid To Ask

Let’s talk about SUBFILE programming in RPG.

If you have grown up through the world of AS400 a few decades ago, or through the wonderful ISERIES machines of the early 2000’s then you *maybe* are using the current IBM i POWER SYSTEMS that replaced those old boxes.

If that’s the case, in most places you are using subfiles to display information on those smelly old green screen terminals. Writing a SUBFILE PROGRAM means knowing how to code them, ranging from simple full load, to expanding, to page at a time. Each type of Subfile has different programming styles… so let’s dive in and have a play with SUBFILES in RPG Programming.

What is a subfile? A programming technique to display data on the screen in a multi-page format.

What types of subfile? We can code full load, expanding and single page subfiles

Come with me while we look at all the different types of subfiles and go through some RPG and SQL RPG examples from cradle to grave. All modules will look at a range of subfiles from brand new simple examples to modifying someone elses code.

...

IBM i, SQL

What is the Maximum Size of Objects in the IBM i System

The AS400, iSeries and IBM i Power Systems are famous for their resilience and ability to handle really large files sizes and thousands of users at the same time. Database files (aka TABLES) can be massive or even set to SIZE(NOMAX). I was just in an interesting meeting where the question was “What if application …

Example Expanding Size Subfile

An expandable subfile is one in which ideally one page of records are loaded at a time. Subsequent pages are added to the subfile as per the user demand.

...

Looking for Something?