UNIX for Advanced & Expert Users

Hi,
Some one help in completing the script:

I need to write a script which has to select automatically only one option(below case only D - ALL) out of all options instead of manual entry

There is an script which is used to test number of connection to different db that it connects when we run the script o/p will be like below:
-----
./testconnectiontoDB

Options:
A DB
B DB
C DB
D ALL
Select option: (Here I have to give an option while executing)

--
Now I need to write a script which will automatically give input as D instead of manually(read) entry, so can some one help me in writting a script which will automatically insert option D and execute the script

Above "testconnectiontoDB" I dont have access to modify the script itself, so I have to execute an different script which will inturn call "testconnectiontoDB" script and followed by option "D" inside the script (instead of manual read option) to copy ALL db connection statistic to output file.

Script should be as below:
-------------------------
cat AllDBStatistics
#..
cd path
./testconnectiontoDB
...
followed by input condition to above read script as D option
..

After executing the above script, I will be copying to some temp file as below:
AllDBStatistics >> Output.file

So can some one assist on above logic.

Thanks/-

If you only need to select "D" once:

Code:

echo D | ./testconnectiontoDB

Thanks for the update

Can you please also let me know how to copy the output to some temperorify file because // echo D | ./Script > Output // is not working, can you tell the alternate option to copy the complete output of the script which is executed by above.
So that statistics I can send mail to destination user in case of issues by setting some conditions.

Thanks/-

Off the top of my head:

Code:

NAME=$(basename ${0})

LOGDIR=/tmp
FILE=${LOGDIR}/${NAME}.$(date +%Y%m%d%H%M%S)

# remove comment to remove older log files
# find "${LOGDIR}" -maxdepth 1 -type f -name "${NAME}.*" -mtime +14 -exec rm -f {} \;

echo D | scriptdir/testconnectiontoDB > "${FILE}"

Thanks m.d.ludwig for given Idea:

What is the exact different between both:
1C) echo D | ./testconnectiontoDB
2C) ./testconnectiontoDB | echo D

As per my knowledge by using (1C) D option will be taken and it will get posted to the script it is running right as part of execution? (If I am wrong correct me ..)

In Second option (2C) .. why it wont work in the sameway ..

Please help me inunderstanding the exact difference between both ..

Thanks/-

hello I cant tell apart ,but I think you can get help by the following way:
info "|"
also , you can deeply about the use of "|"

IMHO, understandong [icode]|[\icode] (aka, the "pipe") is fundamental for using UNIX. As is understanding standard-input and -output.

While this is a bit of a simplification, commandA | commandB is functionally equivalent to commandA > tempfile; commandB < tempfile; rm tempfile, but without the overhead of creating, reading, writing, and removing tempfile. Also, both commands are run simultaneously.

So for:
You are correct in:
Although I would say: D\n (the character "D" followed by a newline character) is written to stdout of echo, which is read by testconnectDB.
As per the echo manual page, only output is sent to stdout, nothing is ever read in. So what ever was generated by ./testconnectiontoDB was lost.

Hope this helps.

-- MDL