Project Overview: Project should take no more than 24 to complet.e 85% 0f required information has been provided to complet project
Project is to create code stub that will loop thru multiple database servers and do the following tasks
0. Project will be written in korn shell
1. Connect to a list of database servers referenced in .pw file
2. Execute a query that generates an output text file
3. Append results of each query from each database server to one text file
What I am Providing
1. Listing of .pw file ### Password file with database server connection parameters
2. Listing of [login to view URL] file ### file with sybase database environment variables
3. Listing of [login to view URL] ### Sybase RDBMS Environment variables
4. Query to connect to sybase database servers
Hi! I will write this script for you with great pleasure!
I have some questions however:
Is the queries to databases are always the same or will be stored in file / provided as parameter when executed?
Should the text file with results be formatted in some manner?
Should query results from different databases separated by some sort of delimiter?
Should the script write date / time when the query was executed?