Let me ask something altogether different about RPG....
I have nothing to do with it, but 3 of my fellow-workers have. I am using a Powerfull ETL tool to create interface files (semi-colon) seperated to consolidate and aggregate data into very specific fields for a forecasting system. I use a three-stage approach, 1 fetching operational data and filtering/aggregating, 2 adding dimensional data through joins and lookups and 3 merging data from different subsystems by union queries.
Management keeps popping up the question whether they should not create the files with RPG , even if this means not having the ability to write a flatfile to another NT server. In my opinion an ETL tool is much more suited, but people seem to think that RPG is the choice for any situation.............
Comments please.....! T. Blom
Information analyst
tbl@shimano-eu.com