Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Please correct the error in the following script
Top Forums Shell Programming and Scripting Please correct the error in the following script Post 302575282 by Rajesh Putnala on Monday 21st of November 2011 07:34:18 AM
Old 11-21-2011
CPU & Memory Please correct the error in the following script
Code:
#!/bin/ksh
db_user=$DB_USER_NAME
db_pwd=$DB_PASSWORD
db_sid=$TWO_TASK
if [ $# -ne 1 ]; then
echo "\tUsage: MoveUsageProcessing <BC Log file Name>"
exit 1
else
BCLogFileName=$1
fi
grep -i  'MoveUsage daemon needs to run on this account before it can be billed'  $1 |awk -F\| '{for(i=0;++i<=NF;) if($i ~ /Acct/) print substr($i,6)}' > ./$1.txt
echo " log file path is : './$1.txt' ";

sqlplus -s /nolog |&
print -p "connect $db_user/$db_pwd@$db_sid;"
print -p "SPOOL output.txt;"

while read var_ack_party_name
do
print -p "set pagesize 0 feedback off verify off heading off echo off linesize 100 \n"
print -p "select *  from bus_event where ack_party_name like 'MOVE_USAGE_DAEMON%' and event_data_text like '%"$var_ack_party_name"%';"
done <./$1.txt

awk '/OrdAcctCycChg/ {print $1,substr($3,length($3),1)}' ./output.txt | while read a b
do
 MoveUsageDaemon -r $b -i $b -e $a -p 1
done

the output when i ran this is :
Code:
atlvivd_on_burrow /tmp> newtrial.ksh 20111011.71BC.LOG
 log file path is : './20111011.71BC.LOG.txt' 
awk: can't open ./output.txt

The problem may be because of accessing output.txt file before it is getting created(because the query(in bold) is taking much time)
I need to wait till the query is executed completely...can anyone help me in thisSmilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Error : Field $() is not correct

Hi All, I'm new to shell scripting. Trying to extract substring using awk script as shown below : Flag=$1 Length=`echo ${#Flag}` NewLen=$Length-2 NewFlag=`echo $Flag|awk '{print substr($Flag,0,$NewLen)}'` echo "New string is : $NewFlag" exit When I execute this script the following... (3 Replies)
Discussion started by: abbey
3 Replies

2. Shell Programming and Scripting

Correct the error plz

Hi, I'll get a file whose first line comprises of system name, timestamp of file creation and the seq number. System name and seq num I need to other computation. My requirement is, I'll have to check whether the timestamp is greater than current timestamp and also check if the timestamp is... (2 Replies)
Discussion started by: Mandab
2 Replies

3. Shell Programming and Scripting

Is the script correct ???

Dear Collegues is the below given is correct ? #!/usr/bin/perl $a = @ARGV; while ($a = @ARGV) { exec "./jagan ../dat/ml_in @ARGV"; } Jagan (0 Replies)
Discussion started by: jaganadh
0 Replies

4. Shell Programming and Scripting

Please correct my Script

I am new to awk, can somone please correct the following script awk -F "," 'BEGIN { foreach ((getline < "file1.csv") > 0) {i++ a=1 --> assuming the first column in the row will be stored in a foreach (a in f1) { if (a == $5) continue print a; } } } file2.csv' Here is what I... (11 Replies)
Discussion started by: nuthalapati
11 Replies

5. Shell Programming and Scripting

Awk Script Counting of Correct vs. Error Responses

Hello, I have been trying to use an awk script to parse out correct and incorrect answers in a simple tab-delimited text file. I am trying to compare the user's response to the stimulus presented (in this case, an arrow pointing left or right; e.g., "<--" vs. "-->"). I have the data for the... (6 Replies)
Discussion started by: Jahn
6 Replies

6. Emergency UNIX and Linux Support

Please correct my script

Please correct my script if it any exceptional, since im calling other external script with in my script. #!/bin/bash FE1=TMM DT1=/home/myHome/dated_1 REPORT=/home/otherHome/Report.sh ## Run the report for FE1 & DT1 cd /home/myHome SERV_LST=/home/myHome/srvc-lst echo "Welcome to... (5 Replies)
Discussion started by: raghunsi
5 Replies

7. Shell Programming and Scripting

Can anyone correct the error in this script

ret=`sqlplus -s /nolog << EOF connect $db_user/$db_pwd@$db_sid; SPOOL ./$DirectoryName/TableData.txt; set pagesize 0 feedback off verify off heading off echo off linesize 150 while read var_ack_party_name do select * from bus_event where ack_party_name like... (13 Replies)
Discussion started by: rkrish
13 Replies

8. Shell Programming and Scripting

Please Correct My script

############### #filename.sh ############### CUREENT_DATE=02 log_file_path="$CUREENT_DATE"-"${0##%*/}`|cut -d "." -f1|awk -F "/" '{print $NF}'`"".log" echo $log_file_path ################ #output required 02-filename.log (6 Replies)
Discussion started by: mohitmehral
6 Replies

9. Shell Programming and Scripting

Need output of script on screen and file with correct return status of the called script.

Hi, I am trying to capture logs of the script in the file as well as on the screen. I have used exec and tee command for this. While using exec command I am getting the correct output in the file but, script output is not getting displayed on the screen as it get executed. Below is my sample... (14 Replies)
Discussion started by: Prathmesh
14 Replies

10. Shell Programming and Scripting

Can some one correct this script

Hi, I tried writing a script and there was a problem with SFTP part can some one correct where is is the mistake Enveronment file #!/bin/bash export HOST_NAME=<> export USER_NAME=<> export PASSWORD=<> export SOURCE_PATH=/u03/informatica/current/server/infa_shared/TgtFiles/mfg export... (4 Replies)
Discussion started by: spradeep86
4 Replies

LEARN ABOUT DEBIAN

chrootuid

CHROOTUID(1)						      General Commands Manual						      CHROOTUID(1)

NAME

       chrootuid - run command in restricted environment

SYNOPSIS

       chrootuid [-i] newroot newuser command...

DESCRIPTION

       The  chrootuid  command sets up a restricted environment for executing command. Access to the file system is restricted to the newroot sub-
       tree; privileges are restricted to those of the newuser account (which must be a known account in the unrestricted environment).  The  ini-
       tial working directory is changed to newroot.

       chrootuid  combines  chroot(8)  and su(1) into one program, so that there is no need to have commands such as /usr/bin/su in the restricted
       environment.

       Only the superuser can use the chrootuid command.

OPTIONS

       There is only one option for chrootuid: -i. That option makes it run in interactive mode. Errors will  be  printed  on  stderr  instead	of
       through syslog and the exit status will be 1 if there are any errors.

RETURN CODES

       The exit status of chrootuid when running on daemon mode (default) is always 0.

       If  it  is  running  on interactive mode, it will exit with an exit status of 1 if there is any error in its invocation, otherwise the exit
       status is the exit status of command.

DIAGNOSTICS

       Problems are reported to the syslog daemon if running on daemon mode.  If running on interactive mode, errors are reported on stderr.

SEE ALSO

       chroot(8), su(1)

AUTHOR(S)
       Wietse Venema
       Eindhoven University of Technology
       Department of Mathematics and Computer Science
       Den Dolech 2, P.O. Box 513, 5600 MB Eindhoven, The Netherlands

       IBM T.J. Watson Research
       P.O. Box 704
       Yorktown Heights, NY 10598, USA

CREATION DATE

       Tue Oct 13 11:37:29 MET 1992

LAST MODIFICATION

       Mon May 20 22:49:02 CEST 2007

VERSION
/RELEASE
       1.3

																      CHROOTUID(1)
All times are GMT -4. The time now is 07:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy