Re: ISeries data to pivot tables in Excel

On 10/28/11 6:25 AM, Versfelt, Charles wrote:

1. After I set library list and saw my list of files, I didn't see ALL the files in the library, just some of them.
Where are my missing files?

First guess, it's a security issue. Does the user profile used to establish the ODBC connection have Read access to the files that are missing?

2. I found the file I needed and selected it. The file has 15 fields. When I got my field list in my pivot table, there were only 13 fields, and one field I need is missing. I noticed the missing fields are my packed numeric fields.

Is that a limitation of Excel, that it can't pull in packed numeric fields, or is there some way to get those fields without changing the file field definitions on the iSeries?

First guess, make sure that you are converting the tables properly. What is the CCSID of your system? My guess it's 65535. If so you really should change it to another value. You then -may- have to change all of your files to the same CCSID, but for now let's change the system's value.

Regarding "limitations" of Excel, the only limitation I've found with it, other than a row limit, is that it can't remember Common Table Expressions correctly, but that's obviously not the problem here.

Bill