Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
Have you been asked to add a part number as a barcode to an existing warehouse report? Does the report currently print as an old fashioned text based spool that looks like it came from the 1980’s? Is this program written in RPG? Is the Printer file defined in DDS? If the answer to these …
I’m in the final stages of a fun project writing web-services to interface INFOR System21 (on an IBM i aka AS400) with ACSIS Visitrack (on Windows Server), we are consuming (receiving) and serving (sending) all data in a standard alphameric layout But… as any RPG programmer will know… the conversion between alpha to numeric is …
Thanks to Mr Aaron Bartell for this excellent article on using GIT for controlling source code changes on IBM i. I’ve been doing this for a while on source code for PROJEX4i and have kept meaning to write a little blog about it. Aaron’s article nicely touches on the high-level concepts of GIT, it’s ease …
IBM i, Programming, RPG, SQL
Over the last year I’ve been using SQL more and more for all my RPG file access needs. The more I use it the more I like it and I’m building my own little set of reusable components and settled in with some naming standard that work for me. I thought I would enter them …
AS400, IBM i, iSeries, Programming, RPG
This is an MC Press article but I am republishing because it’s exactly what I was asked to do today “Adding GPS with RPG”. Do you realize how much your business can do with GPS coordinates? No? Well, let me tell you. All of our applications’ databases hold hundreds if not thousands of addresses—from our …
Are you still running the archaic WDSC7? So we already agree that using WDSC for IBM i software editing, for free, is pretty cool. But, adding Turnover V100 to it, so you can do everything from one place is even cooler. Once we have added the Turnover perspective to our existing WDSC7 setup then we …
IBM i, Programming, RPG, SQL, Webservice
Example RPGLE web service programHere is a quick little example RPGLE web service – it’s written in RPG, the SQLRPGLE flavor and simply reads a file (the System/21 Stockroom master file — INP20) and returns a multi-occurrence data structure (array) of the stockrooms that the user is authorized to use. #hopeithelpssomebodyWEBGETSTR – get all stockrooms for …
Read lots of rows (records) into a data structure (array) Us IBM i blokes love reading things from files. Hashtag internet fact. But sometimes we just want to read a certain number of records, or rows in SQL speak. For example, when building a page by page subfile with say 15 lines per page, we …
RPG CODE EXAMPLE – “Write to joblog” Write to joblog lets us send messages from inside a running RPG program. It’s simple using one of IBM’s API’s – Qp0zLprintf I’ve used this little technique for ever. Simple define a procedure calling the API (in this example I call it “writejoblog”) and then in your mainline code …
Numeric Data Areas are a little trickier than Alphameric Updating any numeric DTAARA in RPGLE is slightly different in RPG /FREEFORMAT than in the good old fashioned column based RPG/400. Using RPG ILE, data structures are treated as mixed-character data. The subfields making up a data structure can be a mix of all data types: …
RPG Programmers are a strange breed of Human If you are a software developer then you will know that RPG is an IBM programming Language. It’s also a Rocket Propelled Grenade. It’s also an acronym for Role Playing Games. This blog will have lots of waffle about being an RPG Programmer and just the occasional …
RPG is a vibrant modern programming language and its getting moderner. is moderner a verb? it should be 🙂 If you are an established RPG programmer, its just too easy to use the same old tried and tested techniques when coding. Doing things the good old fashioned way (or perhaps you call it the tried …
