01-25-2007
Urgent help needed - shell script
Dear friends,
I am trying to prepare a shell script which do the following task. Being a beginner in scripting I need a bit of help from you all for shell script which does the following job.
1.Check for existence of a file in a shared directory (at some remote location ) once in a day
2.Load the records from the file to the correct table via SQL Loader
3.Invoke SQL Plus via command line to run some update queries that are required before running the Server Task
4. And finally, run the Server Task via command line.
I don't have much knowledge of comparision functions , how to invoke cmd line and run sqlldr cmd for getting records in a table. Hope someone help me out.
Thnx
Aru
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear friends,
please help me to solve following problem.
I'm running a frontend application from which i'll be invoking the shell script with arguments as given below
-driver -w -p "ABC XYZ" -S -ds con -dn "abc xyz"
i am getting
$1=-driver
$2=-w
$3=-p
$4="ABC
$5=XYZ"
$6=-S
$7=-ds... (3 Replies)
Discussion started by: swamymns
3 Replies
2. UNIX for Dummies Questions & Answers
I need shell script code for the following
1. Read syscat.columns after connecting to DB2 using SQL cursor
2. Read the output of the previous SQL command in the shell script
3. Perform insertions and deletions in the output of step 1
Thanks (1 Reply)
Discussion started by: skyineyes
1 Replies
3. Shell Programming and Scripting
How to find unique lines in a file without using 'uniq' and 'sort' command in k shell... (3 Replies)
Discussion started by: aajan
3 Replies
4. Shell Programming and Scripting
Lot of dump files are created and filling up our file system.
( i.e. /Aix/app/clone1/heapdump659904.1188950424.txt, Aix/app/clone2/heapdump87878.88798.txt) . We got an alert that the filesystem was full and saw there were heapdumps from a few months ago that we didn't know about. It would be... (2 Replies)
Discussion started by: jayaramanit
2 Replies
5. Shell Programming and Scripting
My I/p FIle
#%npr
#
{
{
collectionBeginTime_Date 19Jul2007
granularityPeriod 900
NODEID BSC19
RLC_Raw_Blocksize_CS2 2048
START_DATE 19Jul07
measTimeStamp_Date 20Jul2007
COLLECTION_INTERVAL_MINS 15
RLC_User_Blocksize_CS2 1024
... (1 Reply)
Discussion started by: aajan
1 Replies
6. UNIX for Advanced & Expert Users
Today I logged as root on my HP-UX server and by mistake executed below command
# ksh -i vi
Then onwards for every root logging the ksh shell giving wired output to every command
e.g
# ls
kÚ
.brw_history
.brwpause
.brwtmp
: : :
1+~H4p+À+~KÑ
1+Ðè
d
15kÚ
1d+~èYÑd:ðè½h|À+~èY4:àh|À+
And so... (6 Replies)
Discussion started by: zing_foru
6 Replies
7. Shell Programming and Scripting
Hi..
I need help to write script (shell script/TCL) which finds the no of elapsed days from current month to coming month.
Actually i have written one Tcl script to get current time...
i.e.
set time -format %c ]
puts "TIME STAMP :$time"
it prints :
TIME STAMP :Mon Mar... (0 Replies)
Discussion started by: arp@g7
0 Replies
8. Shell Programming and Scripting
Hi Guys,
Need a script!!!!!!!!!!!
Sample File:
./R1/new/svp920m02f.4gl
./R1/new/svp921m01.4gl
./R1/new/svp950m01.4gl
./R1/new/svp950m01d.4gl
./R1/new/svp950m01g.4gl
./R1/new/svp955m01.4gl
./R1/new/svp960m01.4gl ... (4 Replies)
Discussion started by: aajan
4 Replies
9. Shell Programming and Scripting
Hi,
Thanks for the reply to the previous posting.I need a shell script to the following.I am entirely new to the comapny and please help me with this.
1) Create the file with a timestamp i.e. nrt_readership.mmddyyyyhhmm
2) The processing job will look for files of the pattern... (0 Replies)
Discussion started by: pharishraja
0 Replies
10. Shell Programming and Scripting
I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being... (1 Reply)
Discussion started by: Gurdza32
1 Replies
LEARN ABOUT DEBIAN
shell-quote
SHELL-QUOTE(1p) User Contributed Perl Documentation SHELL-QUOTE(1p)
NAME
shell-quote - quote arguments for safe use, unmodified in a shell command
SYNOPSIS
shell-quote [switch]... arg...
DESCRIPTION
shell-quote lets you pass arbitrary strings through the shell so that they won't be changed by the shell. This lets you process commands
or files with embedded white space or shell globbing characters safely. Here are a few examples.
EXAMPLES
ssh preserving args
When running a remote command with ssh, ssh doesn't preserve the separate arguments it receives. It just joins them with spaces and
passes them to "$SHELL -c". This doesn't work as intended:
ssh host touch 'hi there' # fails
It creates 2 files, hi and there. Instead, do this:
cmd=`shell-quote touch 'hi there'`
ssh host "$cmd"
This gives you just 1 file, hi there.
process find output
It's not ordinarily possible to process an arbitrary list of files output by find with a shell script. Anything you put in $IFS to
split up the output could legitimately be in a file's name. Here's how you can do it using shell-quote:
eval set -- `find -type f -print0 | xargs -0 shell-quote --`
debug shell scripts
shell-quote is better than echo for debugging shell scripts.
debug() {
[ -z "$debug" ] || shell-quote "debug:" "$@"
}
With echo you can't tell the difference between "debug 'foo bar'" and "debug foo bar", but with shell-quote you can.
save a command for later
shell-quote can be used to build up a shell command to run later. Say you want the user to be able to give you switches for a command
you're going to run. If you don't want the switches to be re-evaluated by the shell (which is usually a good idea, else there are
things the user can't pass through), you can do something like this:
user_switches=
while [ $# != 0 ]
do
case x$1 in
x--pass-through)
[ $# -gt 1 ] || die "need an argument for $1"
user_switches="$user_switches "`shell-quote -- "$2"`
shift;;
# process other switches
esac
shift
done
# later
eval "shell-quote some-command $user_switches my args"
OPTIONS
--debug
Turn debugging on.
--help
Show the usage message and die.
--version
Show the version number and exit.
AVAILABILITY
The code is licensed under the GNU GPL. Check http://www.argon.org/~roderick/ or CPAN for updated versions.
AUTHOR
Roderick Schertler <roderick@argon.org>
perl v5.8.4 2005-05-03 SHELL-QUOTE(1p)