I am using SQL Left Outer Join in an SQLRPGLEI Declare Cursor statement. I need indicator variables of SMALLINT type to handle my null returns in FETCH statements. How and where do these have to be defined? There are no SMALLINT fields in the tables I am joining. Thank you in advance for your consideration.
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!