Query - Refresh - Info / Overview (12572)
The Query system, or also referred to as CPAT, is the system used to pull data most commonly by Excel spreadsheets that have macro(s). They are also called Refresh Files referring to the fact that the macro in the spreadsheet says “Refresh”. Laptops should have ODBC installed on their laptops for access to the query system to work properly, which is available through the Software Center if necessary for re/install.
See referencing Kbases for install, configuration and troubleshooting.
- 10320 - Create ODBC Data Source for URI Item Master File
- 10715 - Query Menu Error: APPC failure. Failure code is .
- 10915 - Issues with CPAT (Query / Query.rm.com)
- 11827 - IBM iACS – Configure ODBC Single Sign On
- 12157 - Query ODBC Settings for Refresh Files
- 12367 - ODBC for IBM iACS Software Requests
- 12368 - IBM iACS – Installing ODBC
- 12430 - Excel 2013 – Configure IBM Data Transfer on Windows 7
- 12439 - Windows 10 - Query ODBC Settings for Refresh Files
Please note that Support has limited access to the Query system. Users should only be directed to AS400@ur.com after exhausting troubleshooting and only if directed per the Kbase.
Issues with the spreadsheet and excel errors generating from them should be directed back to the original owner of the spreadsheet.