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
globus-gram-audit
GLOBUS-GRAM-AUDIT(8) GRAM5 Commands GLOBUS-GRAM-AUDIT(8)
NAME
globus-gram-audit - Load GRAM4 and GRAM5 audit records into a database
SYNOPSIS
globus-gram-audit [--conf CONFIG_FILE] [[--create] | [--update=OLD-VERSION]] [--check] [--delete] [--audit-directory AUDITDIR] [--quiet]
DESCRIPTION
The globus-gram-audit program loads audit records to an SQL-based database. It reads $GLOBUS_LOCATION/etc/globus-job-manager.conf by
default to determine the audit directory and then uploads all files in that directory that contain valid audit records to the database
configured by the globus_gram_job_manager_auditing_setup_scripts package. If the upload completes successfully, the audit files will be
removed.
The full set of command-line options to globus-gram-audit consist of:
--conf CONFIG_FILE
Use CONFIG_FILE instead of the default from the
configuration file for audit database
configuration.
--check
Check whether the insertion of a record was
successful by querying the database after
inserting the records. This is used in tests.
--delete Delete audit records from the database right
after inserting them. This is used in tests to
avoid filling the databse with test records.
--audit-directory DIR Look for audit records in DIR, instead of looking
in the directory specified in the job manager
configuration. This is used in tests to control
which records are loaded to the database and then
deleted.
--query SQL Perform the given SQL query on the audit
database. This uses the database information from
the configuration file to determine how to
contact the database.
--quiet Reduce the amount of output for common
operations.
FILES
The globus-gram-audit uses the following files (paths relative to $GLOBUS_LOCATION.
etc/globus-gram-job-manager.conf
GRAM5 job manager configuration. It includes the
default path to the audit directory
etc/globus-gram-audit.conf
Audit configuration. It includes the information
needed to contact the audit database.
University of Chicago 08/30/2011 GLOBUS-GRAM-AUDIT(8)