Hi, I have 10 files of different type (like csv, xls etc) with a different layout. My requirement is to read and load these files into different tables in DB2 Database. The table structure needs to be defined by us based on the file layout. Also, the database needs to be refreshed on a weekly basis such that if a new record comes in any of these files, we need to append it to the corresponding existing tables. How can we achieve this? Is it possible to write a SAS Macro to perform this load and refresh process in DB2? Regards, Krisan
... View more