Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
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 …
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 …
Comparing Object Authorities across different libraries is easier than you think! Using the magical powers of IBM i SQL we can easily create a spreadsheet containing all the objects in any given library and showing all their authority settings. You can run this SQL statement using green screen STRSQL or from your favorite desktop SQL …
