Hi,
I got the number of records, but when i tried to the count variable in while loop, i have received the below error, line 23: syntax error near unexpected token `done'
line 23: `done'
Code:
#!/bin/sh
outputvar=`sqlplus -S $username/$password@$tnsname << EOF
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
select count(*) from table;
exit;
EOF`
while [ $outputvar -gt 0 ]
do
echo "value is larger"
done
Hi
I have a shell script in which a string variable is saving following query.
SqlQuery="select a||'|'||b||'|'||c from dual"
I am trying to pass above query as a parameter to some script but its giving me error for "single quote". I tried suppressing it using \' instead of just ' but it... (1 Reply)
Hi there
I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this
SN=123456
n=server1
m=x4140
sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';"
echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
Hi All,
bash-3.00$ gzgrep -i '\ ExecuteThread:' /******/******/******/******/stdout.log.txt.gz
<Jan 7, 2012 5:54:55 PM UTC> <Error> <WebLogicServer> <BEA-000337> < ExecuteThread: '414' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "696" seconds working on the request... (4 Replies)
HI,
I want to connect to database and fetch the count from a table.
The sql query is as below :
select count(*) from table_test where test_column='read';
How can I print the output of this statement using shell script.
Thanks in advance. (4 Replies)
Hi team,
I have two select statements and need to run them using SYSDBA user
select * from temp_temp_seg_usage;
select segment_name, tablespace_name, bytes/ (1024*1024) UsedMb from
dba_segments where segment_name='TEMP_TEMP_SEG_USAGE';
Need to run this using a shell script say named... (1 Reply)
cd /opt/et/WAS/apps/8.0
find . -name "HostIntegration.properties" -o -name "HostSocket.properties" -o -name "environment.properties" 2> /dev/null | awk -F '' '{print $4}'|awk '!x++' | cat>/home/cbadmin/file1.txt
cd /home/cbadmin/
PS3='Please enter a number from list of applications==>:'
select... (3 Replies)
I have a text file in this format
Some lines....
Question no: 1
The question?
A. Answer 1
B. Answer 2
C. Answer 3
D. Answer 4
Answer:B
Some lines....
Question no: 2
The question? (choose 2) (10 Replies)
Hello,
I have script which work 70% of the desired task , the output from script.sh is following , however the desired output I require is following .
Any piece of suggestion would be great..
thanks in advance,
emily
#!/bin/bash ... (8 Replies)
Discussion started by: emily
8 Replies
LEARN ABOUT ULTRIX
rmauth
getauth(8) System Manager's Manual getauth(8)Name
getauth, setauth, rmauth - auth database maintenance
Syntax
getauth [username]
setauth
rmauth username
Description
The command takes as it's only argument a user name or UID. If a user name is supplied it is converted to a UID by searching through The
UID is then used to look up the users entry in the database. If an entry is found it is converted to an ASCII string with a syntax resem-
bling that of the passwd file and printed out as a single line. If no entry is found nothing is printed and an exit status of `1' is
returned.
# getauth username
1000:idvidfy8d:1920129:3600:2678400:0e:0:1000:0:00:00
The first field is the UID of the entry which is used as the key into the database. Then follows: the encrypted password, password modifi-
cation time, minimum password lifetime, maximum password lifetime, account mask, login failure count, audit ID, audit control, audit mask,
and a reserved field.
If the optional username argument is not supplied to getauth it will produce an output line for every entry in the auth database.
The command expects one or more lines from the standard input which must be of a form identical to that produced by the command. The com-
mand converts and stores these lines into the database, one entry per line, replacing any entry already existing for the given UID. By
piping the output of the command into the input of the command an expensive NOP can be produced:
# /usr/etc/sec/getauth | /usr/etc/sec/setauth
The command expects exactly one argument, the user name or UID of an auth entry to be deleted. If the entry is found it is erased and
deleted. If it is not found no action is taken and an exit status of 1 is returned.
Restrictions
Only the superuser and members of the group may read information from the auth database. Only the superuser may modify the auth database.
Diagnostics
An exit value of 0 indicates a successful operation. An exit status of 1 indicates the entry was not found on a lookup or deletion opera-
tion. Any other exit status indicates an error.
FilesSee Alsogetauthuid(3), getpwent(3), auth(5), edauth(8)
Security Guide for Administrators
getauth(8)