I am creating a VBA macro in an Excel spreadsheet to download selected data from an iSeries database. Running into an issue with character set. I don't understand VB well enough yet and have not had success w/ google in resolving this.
I appear to be getting the data, but a lot of the fields are empty (ran a query on the iSeries with the same criteria and got data).
I ran into this issue before but I was using a workfile on the iSeries and just recompiled the workfile to CCSID 37 and it was fine. This time I am doing a simple select/where query in VB and don't see the need to use the intermediary steps.
I am sure that someone out there has run into this before and resolved it. TIA
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!