1) I need to extract data present in column A from a O* table, which is of of two columns 'A' and 'B'. The field value can be between 14 to 19 in length and numeric and the file should have a comma at the end of each record ( e.g - the file extract should look like below
rec1 - 1234567891011121,
rec2 - 34567891011121,
rec3 - 1234567891011121111,
2) again, I need to read the same file after processing and load data
in Column 'B' of the same table. the input file will look like -
rec1 - 1234567891011121,1234567891011120
rec2 - 34567891011121,34567891011120
rec3 - 1234567891011121111,1234567891011121110
can any one suggest any solution to this , it will be a great help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!