I am currently working on a project where there is a file which has a field of length 3 (packed decimal). Under the project, we need to increase that length to 5 packed decimal.But this change is causing a lot of impact on the system as lot of programs and queries need to be changed/recompiled. Is there any other alternative which can be thought of in this case? Just an FYI...the file does not have a DDS and is created using SQL script.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!