I need to import large amount of data (upto 30k+ records) using DB2 data sent from database. Database does not exist on the Mainframe. I receive data from DBA in the form of text files. I need to extract data from these text files using table joins and select conditions. Output is required in a flatfile. I cannot use VSAM though. What is the best way to receive these input files and write output file. All suggestions are welcome!
The source system does not support joins and select queries. Source system will provide all the data existing in the tables. The input files are received via ftp to Mainframe. My assignment is to 'select' required data from the input files and join with other related files and write output to a combined file. This has to be performed on the Mainframe.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
You still have not described the requirement. . .
How may files are there? How many fields? How is the data to be "joined"?
What should the output look like? How much data volume is there in each file?
If you cannot describe the requirement, the best we may be able to offer is "write the needed code to create the needed output". The better detail you provide the more useful suggestions you will receive.
If the mainframe also runs db2 is there some reason the data cannot be loaded into mainframe tables and the output created by processing those tables?