The past couple days I was on a mission to look for a way to replace our aging dot-matrix receipt printer. We got some new printers to go with our new credit card processor. These printers are Epson TM-T20 thermal printers. I had some problems finding the information to have the printer cut the paper… Continue reading Controlling a Epson TM-T20 on the IBM i (or iSeries)
Ever find that you need to add a custom library list to a C# application that works with IBM i data? Here is what you need to do. Add LibraryList= to your connection string. So that would look like: connectionString=”DataSource=127.0.0.1;DefaultCollection=MYMAINLIB;Naming=sql; UserID=USERNAME;Password=PASSWORD;LibraryList=MYMAINLIB,LIB2,LIB3;”
We had some… problems with our utility bill emails. They weren’t worded clearly enough that some people were getting confused. See, when I wrote this, used the only approach I knew and manually assembled a string of text until the email was created (depended upon if they were auto-pay or not), but over all the… Continue reading Creating a better emailed statement in RPG using CGIDEV2
Via BVS/Tools – FAQ How do I debug an RPG program in batch? Submit your program into batch and make sure it is held. Do this by either holding the job queue that you are submitting the job to, or use the HOLD(*YES) option on the SBMJOB command. Use the WRKUSRJOB and display the job… Continue reading How to Debug a Batch Program
A person on StackOverflow asked a good question a while back. How do I iterate over a set of records in RPG(LE) with embedded SQL? This is a mix of information gleamed from many sources. I use a standard template for every program and modify as needed from there. Here is the core of the… Continue reading How do I iterate over a set of records in RPG with embedded SQL?
I had a problem recently where because of some old programs with built-in O-specs I didn’t really know what the name of the spool file generated is in CL. I found this API that can figure that out for you. Here is how to use it. First declare your variables: /* QSPRILSP Fields */ DCL… Continue reading What was the name of the last spool file my program created? Here is how to determine that.
I just finished up an article about <a href=”http://imho.midrange.com/2007/12/07/easy-field-encyption-for-system-i/”>field encryption for the System i</a> over <a href=”http://imho.midrange.com/” target=”_blank”>In My Honest Opinion</a> at <a href=”http://midrange.com” target=”_blank”>midrange.com</a>