I am trying to join our sales analysis file, all fields, with our accounts receivable file using SQL. I can extract the information okay but when I issue the following fetch command:
FETCH NEXT FROM SALESSORT
INTO :SALESREC ,:CUSTREC
it skips the null records. I have spent the last 6 hours researching this problem with no success. Is there any way to read in the null records? Right now we are using to many work files to do this kind of project and I am trying to change that. Any help will greatly be appreciated.
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!