Difference between revisions of "Information Systems:State of the Union"
Jump to navigation
Jump to search
(Created page with "This is a generic scribble page used to log and discuss limitations to our current IT infrastructure. Currently, there is a focus limitations surrounding the IBM i and the ASW...") |
(→Query) |
||
| Line 7: | Line 7: | ||
==Query== |
==Query== |
||
| − | Querying the business server |
+ | Querying the business server for data is a core business function, providing the statistics to drive business development and financial decision-making. Transactional data is useless if there is no way to summarize and analyze it. In light of this, IBM has always packaged a query tool to query the DB2 database that is the data heart of the IBM Power8 machine. This tool has evolved, and so has the query language, but we currently do not employ any of the newer and more efficient methods of accessing data. |
*First generation: Query/400 or AS/400 Query |
*First generation: Query/400 or AS/400 Query |
||
| − | *Second generation: |
+ | *Second generation: Query Manager for i |
| + | *Third and current generation: DB2 Web Query for i |
||
| − | * |
||
==The RPG programming language== |
==The RPG programming language== |
||
Revision as of 20:22, 1 March 2016
This is a generic scribble page used to log and discuss limitations to our current IT infrastructure. Currently, there is a focus limitations surrounding the IBM i and the ASW ERP software.
Data
Disaster Recovery
Query
Querying the business server for data is a core business function, providing the statistics to drive business development and financial decision-making. Transactional data is useless if there is no way to summarize and analyze it. In light of this, IBM has always packaged a query tool to query the DB2 database that is the data heart of the IBM Power8 machine. This tool has evolved, and so has the query language, but we currently do not employ any of the newer and more efficient methods of accessing data.
- First generation: Query/400 or AS/400 Query
- Second generation: Query Manager for i
- Third and current generation: DB2 Web Query for i
The RPG programming language
ASW and extensions are programmed in RPG.