Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
Welcome back to another dieting adventure in IBM-i land. Ever wondered why your IBM i disk space is disappearing faster than expected? Those fat libraries are usually the culprits. Follow my Fat Stuff Blogs on how to use SQL to find the large objects on our IBM-i systems. Here is a quick and practical lesson …
If you are working with stored procedures on your IBM i system, you know they are handy for encapsulating business logic and making your SQL calls more efficient. But what happens when you need to back them up or restore them after a hiccup? Today, I am walking you through the process in a straightforward …
IBM i SQL Stored Procedures are the King of the IBM i Database Jungle Welcome to a deep dive into the world of database management! Today, we’re focusing on a powerful tool that can transform how you handle data: stored procedures. Whether you’re working with IBM i, SQL Server, or another database system, stored procedures …
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 …
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 …
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 …
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 …
What are Spool Files? Spooled files on an IBM i System (AS400/iSERIES) are a way to manage output data for printing or processing. They can contain basic text layouts of printed pages, or complex PDF style data streams. Here’s how they work: So, IBM i Spooled Files are virtual printouts, helping you manage input and output …
How to find IBM i File Record Locks with pure OS Commands To find file record locks on IBM i using the DSPRCDLCK (Display Record Locks) command, follow these steps: In this example: How to find IBM i File Record Locks using SQL In the IBM i environment, you can use SQL to check for …
More SQL Basics from the AI Archives How to initialize a timestamp variable using ibm i sql To initialize a timestamp in IBM i SQL, you can use the CURRENT TIMESTAMP special register which specifies a timestamp based on the reading of the time-of-day clock when the SQL statement is executed. If you need a …
IBM i, IFS, Programming, SQL
Not dying users, you big silly! Are your IBM i Users Passwords Expiring? Every IBM i User Profile can be created with an automatic expiration date set against it. This forces regular password changes. Pretty standard stuff right? This is rarely a problem for interactive users – who will see the change password screen: But, …
IBM i User Information is easy with SQL USER_INFO If you’re working with IBM i and need to retrieve information about user profiles, you can use the USER_INFO view. This view provides details about various aspects of user profiles. Here are some key columns from the USER_INFO view: You can query this view using SQL …
