topic Re: Scripting interactive command. in Operating System - HP-UX

Scripting interactive command.

Gulam Mohiuddin — Fri, 24 Feb 2006 09:19:02 GMT

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.

Re: Scripting interactive command.

Peter Godron — Fri, 24 Feb 2006 09:21:49 GMT

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

Re: Scripting interactive command.

renarios — Fri, 24 Feb 2006 09:29:32 GMT

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

Re: Scripting interactive command.

Patrick Wallek — Fri, 24 Feb 2006 09:30:31 GMT

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

Re: Scripting interactive command.

Senthil Kumar .A_1 — Fri, 24 Feb 2006 11:30:41 GMT

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

Re: Scripting interactive command.

Arturo Galbiati — Fri, 24 Feb 2006 11:44:33 GMT

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

Re: Scripting interactive command.

Geoff Wild — Fri, 24 Feb 2006 12:40:56 GMT

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