How to promote a file using Turnover for iSeries 

 January 17, 2012

By  NickLitten

Using a Change Management tool to promote files makes the creation and replacement of target files so much easier.

#INTERNET-FACT: Turnover for iSeries, is a change management tool that really eases this process for us developers.

Consider this scenario – we want to make a change to an IBM i *PF (physical file) like adding a field or changing a field size. This is a hefty file change, changing the level ID of the file and will require recompilation of all related logical files and all programs that use the physical and/or any of the related logical views.

Turnover makes this because after we have ‘checked out’ the physical file it will ask us if we want to also grab all related logical files and programs for recompilation. Just say YES and let Turnover do the work.

We make our file changes in DEV and compile them… add to the promotion form and the Turnover will select the group of objects we want to compile. Then, the compile wizard does the rest. It organizes the compile and puts everything in the right order automatically. It checks for dependent objects as well as custom compile commands. As this change involves a physical file, when it puts the new file in the target environment it will repopulate the file with your data, recompile associated logicals, and even reapply triggers and constraints.

iseries turnover wdsc plugin Turnover for iSeries

The user interface for the TURNOVER® for iSeries v100 plug-ins exactly mirrors the WDSC GUI


IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Shameless Trekkie, Belligerent Nerd, Englishman Abroad and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and remember: If at first you don't succeed then skydiving probably isn't a hobby you should look into.

Nick Litten

related posts:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"cff50":{"name":"Main Accent","parent":-1},"a344d":{"name":"Accent Transparent","parent":"cff50"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"cff50":{"val":"var(--tcb-skin-color-0)"},"a344d":{"val":"rgba(46, 138, 229, 0.85)","hsl_parent_dependency":{"h":210,"l":0.54,"s":0.78}}},"gradients":[]},"original":{"colors":{"cff50":{"val":"rgb(0, 178, 255)","hsl":{"h":198,"s":1,"l":0.5}},"a344d":{"val":"rgba(0, 178, 255, 0.85)","hsl_parent_dependency":{"h":198,"s":1,"l":0.5}}},"gradients":[]}}]}__CONFIG_colors_palette__

Get In Touch

I’m always looking for awesome input, feedback and critique!