1) You can use MS Query instead of the add in. It will retrieve up to XL’s maximum of 65,536. How to do this is in my blog: https://itknowledgeexchange.techtarget.com/beyond-excel/
2) You can retreive your system’s model number through DSPSYSVAL QMODEL and your OS level from DSPDTAARA QSS1MRI. V5R3 ended support on 04/30/2009. V5R4 is currently supported. See http://www-947.ibm.com/systems/support/i/planning/upgrade/suptschedule.html
Good luck: Chatmaker
Chatmaker. I am grateful for your help. I used the technique in your blog and everything worked fine until i got an error PWS0007 Operation Result Set Not found. I tried to get around it and redid the procedure but to no avail.
I can run ms query and it gives me the option to select the table data, but when i press finish, it fails.
it also fails if i add the table to MS query and then try to add data into the query.
Thank you for your patience.
<b>Ringside</b>: Sorry for not seeing you had responded earlier.
The AS400 command DSPMSGD RANGE(PWS0007) MSGF(QIWS/QIWSMSG) describes the error as:
Message . . . . : Operation result set not found.
Cause . . . . . : The handle specified for the operation result set to be filled, returned, or used as the based on result set is not found for the server.
Recovery . . . : Correct the operation result set handle and do the function again.
One KB post suggests:Try unchecking “Enable Extended Dynamic Support” in the ODBC DSN setup
All other KB’s indicate this is resolved by patching CA Express.
<b>Client Access Express Updates</b>: http://www-03.ibm.com/systems/i/software/access/windows/downloads.html