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 …
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, …
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 …
Restore and Rescope Logical Files When you restore a logical file, the system uses the description for the logical file to establish its relationship with the based-on files. For example, database views or indexes are logical files. You can restore a logical file to a library different than the library for the associated physical file. …
A simple guide to SQL for AS400 Dummies You can spot my brethren fairly easily, the rare old-school AS400 developer can be found lumbering around your IT department. The trade mark style of these rare IBM Beasts is graying hair, a low-tech phone, typing with 2 fingers while muttering swear words under their breath. Counting …
Do you want to Create Different Subsystems for Web Services? There are a lot of positive reasons for us to create separate subsystems for each out our sets of applications. But if you read this blog entry then you already know that. So, assuming you want to do it — let’s stop blathering and dive …
Ever wanted to find your IBM i OS Version using SQL? Following on from this blog about how to find the OS version from an RPG Program, a nice chap called Tomas Petris left a comment showing a slick way of pulling the IBM i Version with one SQL statement: The SQL statement is simple …
IBM i, Programming, RPG, SQL
Let’s look at a quick little example RPG email validation program – SQLRPGLE ILE There are lots of code snippets, example programs, and long waffling discussions in internet land filled with pointy-headed AS400, Series, and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know …
IBM i SQL Stored Procedure : Check if Rows exist in Table To check if there are rows in a table within an IBM i SQL stored procedure, you can use the EXISTS or NOT EXISTS condition in an IF statement. Here’s an example of how you might structure your stored procedure to perform this …
