Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
Who’s Got the Keys to the IBM i Kingdom? Come with me on a hunt for *ALLOBJ Profiles Picture this: you’re the sheriff of your IBM i system, tasked with guarding the kingdom from rogue profiles wielding the ultimate power… that super *ALLOBJ special authority. This is the kind of power that lets someone rearrange …
How can we Lockdown SQL Access for IBM i Users? Administrators often want to limit what SQL statements a user is allowed to run because how powerful SQL can be. What’s Different about SQL? SQL is a separate interface to the data and runtime SQL is part of the basic operating system. SQL uses the …
AI is getting clever. I’m honestly not too sure that AI is a good thing. We all watched the Terminator movies, right? But that being said, I like to use the Microsoft’s COPILOT AI, because it makes collating answers to questions so very simple. It certainly makes researching answers to quick questions just about a …
