Creating SQL text files and shell scripts based on the specs

Anulowany Opublikowano Mar 7, 2012 Płatność przy odbiorze
Anulowany 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).

| | |

Administrowanie bazami danych Linux MySQL Instalowanie skryptów Shell Script SQL UNIX

Numer ID Projektu: #2719321

O projekcie

Zdalny projekt Aktywny Mar 29, 2012