select gthamcode as hamcode, gtnumber as item, 'G'
where (gtnumber between 08000000000000 and 08999999999999)
select modkey as hamcode, modndcnum as item, 'M'
where (modndcnum between 08000000000 and 08999999999)
This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The 'M' and 'G' are constants not on the files, they show me which file the record came from.
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!