Creating SQL text files and shell scripts based on the specs

This job requires manual effort and 2 small scripts There is no testing on your part. I will be testing all the scripts. You need to be proficient in unix shell scripting and know DB2 SQL commands well. SQL codes are provided in the attached word document. ## Deliverables the coder must be proficient in unix shell scripting on Aix familiar with DB2 SQL commands Please review the specs carefully before placing a bid. **You job is to:** 1. Verify DDL against the excel worksheet Note: if the DDL is not matching let me know and I will change it 2. Copy and paste all the DDL into new [login to view URL] document 3. Ensure each field is identified for exports, i.e.: (SELECT '' from ... should be SELECT '' AS FILED_NAME from the excel worksheet) and there is a DELETE command before INSERT 3. Create a folder with .txt and .sh with for each table based on the APPENDIX A and [login to view URL] file using naming convention: -- all lower case, [table_name].txt & [table_name].sh -- example: EMPLOYER_CONV folder will have the [login to view URL] & -- [login to view URL] 4. Create a small script to delete all the files from the output directory 5. Create a master script to call all the scripts The work should be completed within a day or so. You can recommend creative solutions (i.e.: creating a master script or using variables to minimize the manual effort) The budget is between $25 to $37 The worker must guarantee they will complete the project, or they forfeit their own money (in addition to not getting paid). | | |