Turnover Pre-Run and Post-Run When we are promoting changed objects, using Soflanding TURNOVER, we sometimes want to run commands before or after the form runs. These pre-run and post-run commands are easy to add to any form, so lets look at how to do it! How do we add a Pre-Run or Post-Run in TURNOVER?

Read More

IBM i SQL numeric to alphameric So – today I was talking to a colleague who wanted to make a database change to a big old file. This meant changing one of the fields from 7 numeric to 12 alpha. Sounds simple right? Oh if only life were that simple… Now add the complexity that

Read More

Only Numpty Programmers hardcode library names #internetfact One of the mumbling, drooling, gray haired programmers on my team asked me to peer review his code this morning. This was for a simple SQL table to be created and promoted through multiple environments using TURNOVER. The code looked something like this: CREATE TABLE MYLIB/TESTSQL ( TSTFLD

Read More

TURNOVER and IBM i ASP (Auxiliary Storage Pools) Unicom (who bought out ‘Softlanding Systems’) recommends upgrading to TURNOVER V101 before implementing iASP technology. It recommends it because it only works on V101 😉 The main thing to remember is that you need to set your job, or session, to use the iASP before going into

Read More

Turnover Tip Tuesday Wow – that’s another long URL title. I really wanted to call this “How To Check Out An Object From One Library And Promote It To A Different Library but keep the program source code line change dates” but that just seemed too ridiculously long. Why are we talking about this? We all

Read More

TURNOVER Client for Windows I really like the Softlanding (aka Unicom) TURNOVER for Windows, aka Turnover CLIENT aka Turnover Graphical Editor. It’s simple to use, not as clunky and old fashioned as the terminal based green screen menus and it’s just simple. Being simple myself, I like simple. 😉 Some people love the graphical editor.

Read More

TURNOVER Reference Docs for IBM i Programmers Earlier, I was explaining how to use TURNOVER Change Management to some RPG Developers who have spent years using Turnover but who had never used the Programmer Worklist Function. I was mildly surprised at the manual technique that was being used to check out each object, adding to

Read More

TSERVER Subsystem on IBM i TURNOVER Software Change Management for iSeries (*) uses a subsystem to control the distribution of software revisions to other nodes in the network. The TURNOVER TSERVER subsystem is a quiet little background job that controls the sending and receiving jobs. * Softlanding not upgraded their TURNOVER software branding for over

Read More

LMS 7.3 – IBM i Lodging Management System In the words of Jesse from the Fast Show (showing my age there) — This week I will be mostly preparing to upgrade LMS 7.1 to LMS 7.3.3 So, this Las Vegas Casino uses Turnover V100 to manage software change management across its IBM i Systems. I

Read More

Turnover User Profiles So, we have IBM i User profiles defined and these users now want to use TURNOVER – so what next? Luckily, defining a user is very simple just launch Turnover (in this blog I use the Windows version running on Windows10) and click the machine you want to administer. TURNOVER FOR WINDOWS

Read More

TURNOVER TUTORIAL No, I will not be teaching you how to bake a #APPLETURNOVER We will be delving into the slightly less delicious world of software change management for RPG Programmers and IBM i Software Developers. I’ve been working on a freelance gig for some time now and the client uses Turnover (by Softlanding /

Read More

EXTPRC – External Procedures Question: How do I promote External Procedure using Turnover and get them to automatically *REPLACE on the destination machine? Answer: Like this! The problem here, is that SQL Stored Procedures have no equivalent of *REPLACE on the CREATE PROCEDURE statement! That’s easy – “just add a Drop to line one of the

Read More