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