Contact us at 1-800-361-6782

Recorded IBM i session

Resize Your IBM i Database Fields with Fresche’s Automated Resizing Solution

As companies expand, they often outgrow the size of the fields in their databases. Will some of the fields in your IBM i environment soon be too small for invoice or item numbers, codes, or other data? Field expansion creates numerous cascading changes throughout an application, potentially causing many code-related problems. This can make it almost impossible to manually expand the fields.

Ray Everhart and John Westcott discuss how Fresche’s X-Resize solution automatically resizes database fields and all fields in affected programs.

You’ll learn how taking an automated approach to field resizing:

  • Removes the risk of human error
  • Provides a detailed impact assessment for all instances for the resize project
  • Eliminates the guess work and automatically handles all aspects of the resizing task

Request the recording

Manual Field Expansion Is Time Consuming and Risky

There are a lot of factors that can influence the need for field resizing, such as a company’s organic growth or expansion through acquisitions. Over time, an organization’s requirements can change, causing them to outgrow the current size of the fields in their databases.

Field expansion creates numerous changes throughout an application, affected fields in many files and cascading through variables across numerous programs. It can be next to impossible to perform these tasks manually, as there are many code-related problems that can occur. Due to the massive scope and the resources required to carry out the effort, IT departments often delay these projects.

An Automated Approach Saves Time and Eliminates Risk

Fresche’s resizing solution helps you meet the needs of the business by providing all of the tools necessary to identify and resolve issues at all stages of your resizing project. The X-Resize solution can assist with the following:

  • Accurately defining the scope for the field resize project
  • Resolving all exceptions that can affect the scope of the resize project
  • Identifying all manual program changes required so they can be scheduled for implementation
  • Developing a project plan, including timeline and resourcing requirements
  • Automatically resizing the fields in the project in all affected files and programs

Meet the Presenters

Ray Everhart


Ray has spent years helping IBM i companies by assessing their RPG, COBOL and CA 2E (Synon) applications and processes to improve business outcomes. As Product Manager for X-Analysis, he works closely with IBM i customers to understand their business goals and technical needs in order to drive innovation within the product suite.

Ray Everhart
John Westcott

John Westcott

VP, Business Transformation - Fresche

John has worked in IT for 25 years and specializes in bridging the gap between business needs and IT initiatives. He has years of experience delivering successful IT solutions that ensure businesses can thrive. As Fresche’s VP of Business Transformation, he helps clients leverage the power of IBM i to implement IT strategies that use modern technology and future-proof organizations.

X-Resize screen shows which fields changed in length

“Based on the magnitude and depth of the project, I can’t imagine the amount of human hours that would have been required to match what X-Resize can do in just hours—without bringing in the potential for human error. It’s really quite amazing.”


Cliff Dowell
Senior Software Engineer, MEDHOST

Read the Case Study [PDF]
Learn more about X-Resize
Share this X-Resize session

Learn how you can remove the risk of human error and eliminate guess work by automatically resizing your fields with Fresche’s X-Resize solution.