Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
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 …
Christmas has just finished – how do I slim down my IBM i System? I like to look in all the nooks and crannies for data that has been left behind, or simply accumulating and never being consumed. Data Queues are small and fast. The downside is that loading data queues over long periods of …
AS400, IBM i, iSeries, Programming, SQL
Join me on a mission to connect to a SQL Server database from IBM i This will be a growing blog… I’m going to use this to record a diary of sorts, chronicling my adventures in accessing and reading a Microsoft SQL Database direct from an IBM i application. Apparently, if the bods at Microsoft …
What is an IBM i Job Description? An IBM-i job description (JOBD) defines runtime information about the Job that is submitted using it. It’s been this way since the AS400 and iSeries machines of years gone by. A JOBD contains information covering things like: Job queue to be used by the Job, scheduling priority, routing …
SQLRPGLE Shorts – How to Call QCMDEXC with IBM i SQL Surely every RPG programmer is familiar with the QCMDEXC *API for exciting any IBM i Command from within any HLL (High Level Language) program. What is QCMDEXC? The Execute Command (QCMDEXC) API runs a single command. It is used to run a command from …
How to Download IBM i SQL Results As CSV I had to run a rather interesting SQL statement to download journal information: What does this do? Essentially, this SQL snippet retrieves journal entry information for the given journal and the file that is journaled. Running this in the IBM i ACS SQL script explorer gives …
How to get a JBA Supplier History by Country I was asked to build a spreadsheet showing “All purchase totals for all suppliers by year and include the supplier country code” A simple request – so I thought I would blog the process for those new programers out there or for anyone wanting to understand …
Count with SQLRPGLE Variable File Name Been having fun with SQL and RPG ILE this afternoon… the question was “How do I find out if and how many policies exist in one of the reservation files for a given customer code?” Obviously, we could write a little piece of RPGLE doing a READ LOOP and …
AS400, IBM i, iSeries, Programming, SQL
How to Substring a Packed numeric in a Logical File So – you have a Physical file and you want to create a logical with substrings of file data or maybe concatenation of the same data. “That’s easy” I can hear you think… but… but… what if you need to do this with a substring …
IBM i, IFS, Programming, SQL
How to delete first few rows from a file with IBM i SQL This morning I was working with a flatfile import from IFS into a DB2 database file. This should have been straight forward but the flat file contained several rows of crappy data at the start of the file. *ugh* Since I am …
Using CPYFRMIMPF to use flat text files in the IFS The Copy from Import File (CPYFRMIMPF) command can be used to copy data from any IFS file into an IBM i (DB2) Table. It handles very simple delimited file conversions like CSV files and also straight flat text files. The Copy to Import File (CPYTOIMPF) …
