Add a custom IBM i library list to a C# application

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;”

Creating a better emailed statement in RPG using CGIDEV2

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

What was the name of the last spool file my program created? Here is how to determine that.

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.

Easy Field Encyption for System i

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>