topic Re: Input to command automatically in Operating System - HP-UX

Input to command automatically

Soul_1 — Thu, 11 Mar 2010 09:14:52 GMT

Hi all,

i want to give input to a command automatically.

for Example:
Normally i have to run the command say "x" for intiating sql query and afterwards ihave to give the sql commands and press enter

#x
SQL>select * from data_detail;
quit;
#

i need to auomate this .Please help me

Cheers !!

Re: Input to command automatically

Horia Chirculescu — Thu, 11 Mar 2010 09:38:16 GMT

Hello,

If you use sqlplus (x=sqlplus), you could make a sql script (your select/insert/whatever/quit will go there) and then se something like this:

sqlplus -s '/ as sysdba' @yourscript.sql

If you script would use some variable, you can add that variable at the end of this command like this:

sqlplus -s '/ as sysdba' @yourscript.sql $variable1

In your script.sql you can access that variable by $1.

Horia.

Re: Input to command automatically

Horia Chirculescu — Thu, 11 Mar 2010 09:39:39 GMT

> by $1.

Sorry, it is &1. Read manual for sqlplus.

Horia.

Re: Input to command automatically

James R. Ferguson — Thu, 11 Mar 2010 12:40:05 GMT

Hi:

You could use a here-document:

sqlplus <

Re: Input to command automatically

rariasn — Thu, 11 Mar 2010 13:34:07 GMT

Hi,

# cat sample.sh

echo "..."
sqlplus / sample.sql
ERR=$(grep 'ORA-' sample.log)

if [ "$ERR" = "" ]
then
echo "SAMPLE: OK."
else
echo "sample: ERROR"
exit 3
fi

# cat sample.sql

spool sample.log
select * from data_detail;
spool off
exit;

Rgs,

Re: Input to command automatically

Arturo Galbiati — Fri, 12 Mar 2010 08:25:44 GMT

Hello,
don't use sqlplus user/password but:
sqlplus
conn user/password
....
exit

reason why is that by 'ps -ef|grep [s]lplus' in the first way it's possible to cach database password!!

HTH,
Art

Re: Input to command automatically

Arturo Galbiati — Fri, 12 Mar 2010 08:28:51 GMT

Hello,
don't use sqlplus user/password but:
sqlplus
conn user/password
....
exit

reason why is that by 'ps -ef|grep [s]qlplus' in the first way it is possible to cach database password!!

HTH,
Art