Creating SQL text files and shell scripts based on the specs
$25-30 USD
Płatność przy odbiorze
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 [url removed, login to view] 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 [url removed, login to view] file using naming convention:
-- all lower case, [table_name].txt & [table_name].sh
-- example: EMPLOYER_CONV folder will have the [url removed, login to view] &
-- [url removed, login to view]
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).
| | |
Numer ID Projektu: #2719321