Hi all,
I am new to shell scripting.I have made a simple shell script which will give me number of records in a database table. The SQL statement is working fine and there are 11 rows in this table. But problem is that it is not printing this value and fucntion does not get called. Please see the debug output at the end. The variable count2 does not get initialzed. Thanks.
Code:
#!/usr/bin/ksh
set -x
UIDPWD=`cat $TABS_HOME/.restrict/$ORACLE_SID`
export UIDPWD
get_number1()
{
set -x
sqlplus -s <<!
$UIDPWD
set head off
set feedback off
select count(*)
from MSC041501_090318A
/
exit
!
}
count2 = `get_number1`
echo "The total number of records in file is $count2"
Debug Output:
Code:
+ + cat /export/home/tabs/.restrict/TABST1
UIDPWD=its/its123
+ export UIDPWD
+ get_number1
+ sqlplus -s
+ 0<<
its/its123
set head off
set feedback off
select count(*)
from MSC041501_090318A
/
exit
+ count2 = 11
./count.sql[17]: count2: not found
+ echo The total number of records in file is
The total number of records in file is
Last edited by zaxxon; 04-14-2009 at 09:48 AM..
Reason: CODE tags are wonderful!
Hi,
I am new to unix as well as shell programming.
Any body can provide me a simple shell script which should copy/transfer/fetch a file(using FTP)from remote server to local system.and it should log the details when it was fetched.If there is any error,the error msg should log in log... (1 Reply)
I M TRYING TO DO SUM THING I M A NEW LEARNER TO SHELL SCRIPT PLZZZ HELP ME FRIENDS
I M TRY TO DO SUM THING C IT AND HELP ME
First open a .ctl file
Copy the file into temp file
Add A EXTRA FIELD “ext_date” with keeping value “##**&&”
EG- EXT_DATE CONSTANT"******"
Each time... (2 Replies)
Hi,
I am new to unix and using linux 7.2. I would like to create a script that would make it easyer for me to run my java programms. At the moment I have to type java myJavaprogram
I am trying to write a script that will allow me to type something like this "myscript myJavaprogram" or maybe... (4 Replies)
This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord
but only one record is getting wrote in DB.... Please advise ASAP...:confused:
function InsertFtg
{
FTGSTR=""
echo "Saurabh is GREAT $#"
let... (2 Replies)
Hello Friends,
I am writing a shell script which will grab a file if it exists and copies it to another folder and will append with current date. I have written but gives me error, plz help:
--------------------------------------------
#!/usr/bin/sh
source=/home/dev4rice/naveen/test1... (4 Replies)
Hello forum members,
I have to redirect a output of command into a text file inside a script file but iam getting an errors.so please see below script and suggest me for corrections.
#!/bin/ksh
read IP_ADD
echo nslookup $IP_ADD 2>&1| tee log1.txt
cat /amex/gcst/siva/Testr/log1.txt... (6 Replies)
Hi ,
I am in need of simple shell script that has one input file containing some words
Input file 1 :
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****... (6 Replies)
Hello,
I am running openmediavault on my Raspberry and I would like to use it as a backup FTP server of snapshots taken from my IP cams.
So I get the network recorder to upload every 3 seconds a snapshot to the Raspberry. Everything works perfectly.
I would need now a simple script that... (5 Replies)
Hello,
I need to create one very simple shell script that checks if the first character of the file ./pump.txt is 0 and in that case gives a message.
If the first character is instead 1, it does give a different message.
I have written:
irr= head -c 1 ./pump.txt
if ]; then
echo... (4 Replies)
Hello, Trying to look
vgcheck() {
lsvg -o|
while read vg; do
lsvg -p $vg|grep Missing
if ;then
echo "OK:PASSED"
else
echo "FAIL"
... (3 Replies)
Discussion started by: kvosu
3 Replies
LEARN ABOUT SUNOS
return
exit(1) User Commands exit(1)NAME
exit, return, goto - shell built-in functions to enable the execution of the shell to advance beyond its sequence of steps
SYNOPSIS
sh
exit [n]
return [n]
csh
exit [ ( expr )]
goto label
ksh
*exit [n]
*return [n]
DESCRIPTION
sh
exit will cause the calling shell or shell script to exit with the exit status specified by n. If n is omitted the exit status is that of
the last command executed (an EOF will also cause the shell to exit.)
return causes a function to exit with the return value specified by n. If n is omitted, the return status is that of the last command exe-
cuted.
csh
exit will cause the calling shell or shell script to exit, either with the value of the status variable or with the value specified by the
expression expr.
The goto built-in uses a specified label as a search string amongst commands. The shell rewinds its input as much as possible and searches
for a line of the form label: possibly preceded by space or tab characters. Execution continues after the indicated line. It is an error to
jump to a label that occurs between a while or for built-in command and its corresponding end.
ksh
exit will cause the calling shell or shell script to exit with the exit status specified by n. The value will be the least significant 8
bits of the specified status. If n is omitted then the exit status is that of the last command executed. When exit occurs when executing
a trap, the last command refers to the command that executed before the trap was invoked. An end-of-file will also cause the shell to exit
except for a shell which has the ignoreeof option (See set below) turned on.
return causes a shell function or '.' script to return to the invoking script with the return status specified by n. The value will be the
least significant 8 bits of the specified status. If n is omitted then the return status is that of the last command executed. If return
is invoked while not in a function or a '.' script, then it is the same as an exit.
On this man page, ksh(1) commands that are preceded by one or two * (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words, following a command preceded by ** that are in the format of a variable assignment, are expanded with the same rules as a vari-
able assignment. This means that tilde substitution is performed after the = sign and word splitting and file name generation are not
performed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO break(1), csh(1), ksh(1), sh(1), attributes(5)SunOS 5.10 15 Apr 1994 exit(1)