I need a Java expert to help me to do PoC: Read a flat file, validate and insert to DB2 database. Documents attached as below: - db2 drivers attached : [url removed, login to view] & [url removed, login to view] - create a database called CLIMO and run the below scripts to create the necessary tables. -- Scripts file [url removed, login to view] to create a code table C_EXTREME_REC and DR_HIST_REC for validation. -- Script file [url removed, login to view] to create other master tables and the output Tables DR_HR_OBS, DR_DAY_OBS, DR_MTH_ - Attached find the source flat file - [url removed, login to view] for the month of Jan'07 (Processing of Daily Register File) - Use case document for this input file - Document for validation rules...(very exhaustive..but refer to the points relevant only to this case -keep the configurable items in the properties file.. for example, db2driver location, source dir path, input file name etc.. After seeing this docs, please let me know how quickly this java program can be completed - This is a PoC only.. Once approved, will get the order and i will offload to you.
Fully Working java code
Java 1.4 ;DB28.2 ; Eclipse