Create a Web Service on IBM i When the platform was referred to as system i, i/Series, I somehow found myself creating Web Services that processed orders into a Green Screen ERP system any way but back then using Microsoft BizTalk as the middleware. If you have done something like that, this will be very […]
Read More
You can do a lot more with Variables these days: In ILE Static variables get stored in static storage/memory opposed to automatic. This means unless you intentionally clear them when exiting a procedure, the procedure will retain those values. Eg you’re running through Invoices sequenced by Customer so your little procedure goes off and gets […]
Read More
I see many jobs listed with similar requirements for RPG, something like: To be considered for this position, applicants need to meet the qualifications listed in this posting. Requirements: 5+ years of development on IBM i (iSeries, AS/400) using all of the following: RPG-ILE, RPG-Free, SQL and CL 3+ years’ experience with SQL and the […]
Read More
JBA System21 Developer I am an IBM i Software Developer specialising on the Infor System21 ERP system. System 21 is an Enterprise Resource Planning solution. It was originally released by the firm JBA [1], then went to Geac Computer Corporation with Geac’s acquisition of JBA. In 2007 Geac was acquired by Golden Gate Capital for […]
Read More
iSeries Navigator Previously (Ops Navigator) Do not be put off by the word “Operations.” iSeries Navigator is the GUI interface for the OS. Many of the new system functions are only being implemented in Navigator, i.e. there are no corresponding green screen commands. Your main interest will be in the File Systems and Databases options, […]
Read More
Some places are still avoiding SQL If you’re one of these, you need to start looking seriously at SQL. SQL is playing a bigger role in both the definition and manipulation of the database. It is now very common to see embedded SQL. Have a look at the Run SQL Scripts feature of the Database […]
Read More
Procedures are what it’s all about these days. When you start using RPG IV, you will soon come across subprocedures. They are a big change to RPG. Think of it as the ability to execute a subroutine stored outside of the program that requires it in another program (Service Program). As a Procedure is stored […]
Read More
DB2/400 and DB2 UDB for iSeries are essentially the same thing. iSeries(AS/400) was able to adopt the IBM DB2 UDB branding when it delivered a lot of new database functionality in V4R4 of OS/400, so the database was renamed fromDB2/400 to DB2 UDB for iSeries in that release. Get up to date with triggers and […]
Read More
Do not expect any useful future mods to DDS It will never be enhanced for database or display files. The Databases function in iSeries Navigator is the new GUI interface for maintaining your database and a fairly nifty way to ease yourself into the Data Definition Language of SQL. This is where you learn about […]
Read More
IFS is the File system to talk to your business network. According to IBM “The IFS integrated file system is a part of the IBM® i operating system that supports stream input/output and storage management similar to personal computer and UNIX operating systems, while providing you with an integrating structure over all information stored in the system.” […]
Read More