Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data I […]
Continue reading
Discussing a data interchange process with a software vendor today (who shall remain nameless), they told me that their product could talk to an AS400 but had no experience of iSeries or IBM i…. *sigh* I am not telling you the company name because I don’t wan to to embarrass them in public… butif you […]
Continue reading
Now, before you get all bent out of shape and point your grubby little index finger at me cackling “you called it an AS400 na-na-nu-na-naaah“, I do have a legitimate reason. It’s a shallow SEO based one (the grey haired brigade keep searching for “zip AS400 library”) but it’s legitimate. I only used the wrong […]
Continue reading
Here’s a blast from the past: I was just testing an IBM i program that is importing data from a Windows Server, converting the data, juggling it, tweaking it and when its finished playing it finally shoves it into an IBM i Database. Fun Fun FUN! But if its running interactive and I want to […]
Continue reading
Modernizing RPG Programs – Learn the RPG History first I had email email from an old work colleague this morning. He was a windows programmer, with limited exposure to RPG, but works in a company that is driven by a huge, old, complex RPG3 application that has changed little over the last decade. He is […]
Continue reading
Add a System to Connect to The first thing we wan to do is to add a System to use with ACS – so lets click “System Configurations” Sod it… it’s easier to show you than to tell you:
Continue reading
You think you know IBM i? You havent met 7.3 IBM i 7.3 Announcement & Material IBM® DB2™ for i Temporal Support, enabling clients to conduct accurate analysis of data within a specific historical time period More advanced analytics capability driven by enhanced OLAP functionality, allowing clients to better forecast, define gaps and build new […]
Continue reading
If the phrase “Free IBM i system” sounds too good to be true, then you just might have come to the right place. Try the machine that replaced the AS400 and iSeries for free! Do you want to try the latest IBM i operating system version for free? Do you want to try out the […]
Continue reading
Promoting RPG So, you have completed your programming! You have tested the code in your library and it’s ready to pass on to the QA testing team or the User Acceptance Test team. How are we going to do that in Turnover? The process is called promotion and you do it using a thing called […]
Continue reading
Checking out code – this is booking the code or reserving it for *you* to work on. This takes a copy of the high level (UAT, QA, TST or PROD) into your developer library and lets you work on it. You work and compile it in there using the Programmers Worklist (which is Turnover’s version […]
Continue reading