How do you distribute your IBM i objects? Are you instructing your friends and customers to use FTP to transfer savefiles containing your software and/or fixes? Continue reading
Author Archives: Jesper Wachs
At last! Useable data from IBM i using FTP
There are quite many ways to get data from the IBM i to a PC. FTP is a relative simple method to use, however if the file contains packed or binary fields you end up having a PC file containing strange characters. You have to find another, and typically more complicated, method to do it.
Today this changes as I will show you a Windows Command file, that will transfer a physical or logical file from the IBM i and create a PC file in CSV format, where packed and binary fields are converted to a readable format and columns having headers 🙂
Searching for files and objects in the IFS
Reply
The code examples in this article is based on the first version of the FindFiles() procedure. The FindFiles() procedure has been updated to Totally Free RPG and a bug have been fixed. You will find the source code, example and build script here.
I am working on a utility and I wanted to add the ability to search for files in the IFS. That is, I wanted my utility to search the entire or relevant parts of the tree structure (including sub-directories) seen from the IFS’s point of view. Had it just been a search for objects in the libraries, a DSPOBJD command could do the job. But my ambition was that the search should work anywhere in the IFS and, of cause, only find objects matching a name mask that I would provide. Sounds like a reasonable requirement, don’t you think?
ILE RPG function to split a filename into name and extension
This function splits a filename (must be without path name) into the name and the extension 🙂
If the filename has more than one dot, the name and extension is split at the last dot.
ILE RPG function to search the IFS for files
An updated version of these procedures can be found here.
This function searches the IFS for files and directories having a name that matches the mask 🙂
When a matching file is found, a ‘File Found’ function/procedure is called. The ‘File Found’ function/procedure is one that you supply. An example is supplied.
ILE RPG function to convert a string to upper/lower case
» Please note, that this article has been superseded by this one: ILE RPG function to convert a string to upper/lower case – fast. If you convert many fields/records in one go, these procedures are way faster that doing it using SQL 😉
The two functions, contained in this module, converts a string to upper and lower case. The advantage of these two ILE RPG functions is, that the conversion includes national characters 🙂 For us Danes, the letters ‘æøåáé’ will be converted to ‘ÆØÅÁÉ’.
Releasing Jesper’s ToolBox for IBM i V1.30
Jesper’s ToolBox for IBM i is a collection of some of my IBM i tools, all wrapped up in a nice installation program, easy to install 🙂
Jesper’s ToolBox for IBM i V1.30 contains these tools:
- Change Owner by Object.
- Create Development Library.
- Display Source Status.
- Export Source to Folder.
- Make.
- Move Unused Objects.
- Program Reference.
- Selection Window.
- Set Library List from Job Description.
- Soft Size.
Read more about these tools, and download, them from here.
Note that the tools are wrapped up in an installation package made by iInstall Reborn that will be available soon 🙂 An appetizer is available here.
Releasing Jesper’s ToolBox for IBM i V1.20
Jesper’s ToolBox for IBM i is a collection of some of my IBM i tools, all wrapped up in a nice installation program, easy to install 🙂
Jesper’s ToolBox for IBM i V1.20 contains these tools:
- Change Owner by Object.
- Create Development Library.
- Display Source Status.
- Export Source to Folder.
- Make.
- Program Reference.
- Selection Window.
- Set Library List from Job Description.
- Soft Size.
Read more about these tools, and download, them from here.
Note that the tools are wrapped up in an installation package made by iInstall Reborn that will be available soon 🙂 An appetizer is available here.
It is time for Aprils Fool
So, 1st of April is coming up and it is time to make a little fun with your co-workers.
I have collected two Aprils Fool programs that you can use on your iSeries in order to make a little joke with your co-workers 🙂
Select the program you want to use, and make sure that the program is being called in the users login program. If you do not use a login program, you can define one of the Aprils Fool program directly on the users profile as login program.