Scripting interactive command.

[Gulam Mohiuddin]

I have to run the following command on unix command line:

nid TARGET=sys/password@TSH1 DBNAME=TSH2

But this command runs interactively and asks me to enter (Y/[N]) as follows:

Change database ID and database name TSH1 to TSH2? (Y/[N]) =>


I scripted it in a file to pass the value 'Y' as follows:

#!/usr/bin/sh
ORACLE_SID=TSH1 ; export ORACLE_SID
nid TARGET=sys/password@TSH1 DBNAME=TSH2
Y
exit 0


But it didn't work, still asks me:

Change database ID and database name TSH1 to TSH2? (Y/[N]) =>

How to pass 'Y' in the script?


Thanks,

Gulam.

[Peter Godron]

Gulam,
have you tried a redirect?
echo "Y" > answers.lis
nid TARGET=sys/password@TSH1 DBNAME=TSH2 < answers.lis

[renarios]

Hi Gulam,

You can try the here doc:
#!/usr/bin/sh
ORACLE_SID=TSH1 ; export ORACLE_SID
nid TARGET=sys/password@TSH1 DBNAME=TSH2 <Y
exit
EOF

Cheers,

Renarios

[Patrick Wallek]

Try something like this:

#!/usr/bin/sh
ORACLE_SID=TSH1 ; export ORACLE_SID
nid TARGET=sys/password@TSH1 DBNAME=TSH2 << EOF
Y
EOF
exit 0

[Senthil Kumar .A_1]

Hi Gulam,


Yep the answer is Here statemnet.

Follow Patricks instruction. Note there should be a space between "<<" and "EOF". secondly the exit should be after the second EOF, as it is not a response your nid program awaits.

Regards,
Senthil Kumar .A

[Arturo Galbiati]

You can use the here-document feature:
#!/usr/bin/sh
ORACLE_SID=TSH1 ; export ORACLE_SID
nid TARGET=sys/password@TSH1 DBNAME=TSH2 << EOF
Y
EOF

For more info about here-document:
http://wks.uts.ohio-state.edu/unix_course/intro-110.html

HTH,
Art

[Geoff Wild]

If the above don't work, then you may have to do this with expect:

http://hpux.ee.ualberta.ca/hppd/hpux/Tcl/expect-5.43/

I attached a sftp expect script

Rgds...Geoff