Our Iseries site is a heavy user of embedded SQL. We have over the past few months started using SQL UDFs and have recently been found out when the dependent UDFs have not been deployed along with the main deployed code.
Would anyone know if there is an easy way of identifying dependent SQL UDFs used by deployed programs and if they were used, whether these UDFs were installed in the deployed environment.
Software/Hardware used: Power Systems running IBMi / SQLRPGLE
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!