Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Emergency !! Need to fix this error!

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Emergency !! Need to fix this error!
# 1  
Old 11-25-2011
Error Emergency !! Need to fix this error!
Pls help me with the below script.
Its returning an error No such file or Directory.
Code:
#!/bin/ksh
cd /enip/enipapp/cbp/AOC2511201
for file in `cat filename.txt | head -1 | tr -d '\r'`
do

        for i in `cat '$file' | tr -d '\r'`
        do
                echo "-----script start `date` for $file----" >>log.txt
                echo "$i" | mdsql
                echo "-----script end `date` for $file----" >>log.txt
        done
        sleep 60
done

Last edited by pludi; 11-25-2011 at 01:16 PM..
# 2  
Old 11-25-2011
There is an issue with this line:
Code:
for i in `cat '$file' | tr -d '\r'`

Because $file is between single quote characters it will never get expanded. It should be between double quote characters.
Last edited by pludi; 11-25-2011 at 01:17 PM..
This User Gave Thanks to methyl For This Post:
Naga06
# 3  
Old 11-25-2011
Thanks Methyl. let me try. But the issue now is when I pass through the script, lines are getting splitted like below... but when i cat that file, its in proper format.. Pls help me...

Quote:
update
table
set
expiretime5='444'
where
productkey5=3
and
subscriberkey=3;
# 4  
Old 11-25-2011
Why do you need "cat"?

Try this:
Code:
#!/bin/ksh
cd /enip/enipapp/cbp/AOC2511201
for file in `head -1 filename.txt | tr -d '\r'`
do
	for i in `tr -d '\r' "${file}"`
	do
		echo "-----script start `date` for $file----" >>log.txt
		echo "$i" | mdsql
		echo "-----script end `date` for $file----" >>log.txt
	done
	sleep 60
done

Good reading: Useless Use of Cat Award

About it splitting, we need to know what you have in the files you use in the script!
-----> filename.txt
-----> And the content of the ${file}

I hope it helps!
# 5  
Old 11-25-2011
Thanks a lot filip. filename.txt consists of file names .
$file consists of below
Quote:
update ts_productorder set expiretime2='20111125000000' where productkey2=204810 and subscriberkey=211876824;
---------- Post updated at 11:28 PM ---------- Previous update was at 11:27 PM ----------

In $file there are 5000 update commands together.
# 6  
Old 11-25-2011
If I understood your post, what is below probably works:

Code:
#!/bin/ksh
cd /enip/enipapp/cbp/AOC2511201
for file in `head -1 filename.txt | tr -d '\r'`
do
	while read updateDML
	do
		echo "-----script start `date` for $file----" >>log.txt
		echo "${updateDML}" | mdsql
		echo "-----script end `date` for $file----" >>log.txt
	done < "${file}"
	sleep 60
done

Last edited by felipe.vinturin; 11-25-2011 at 02:21 PM..
# 7  
Old 11-25-2011
Quote:
for file in `head -1 filename.txt | tr -d '\r'`
This line will only give you the first line of filename.txt. Are you intending to process every filename in filename.txt ?
Just out of interest, what is "mdsql" ? It seems very inefficient to start a process for every line of SQL. Can the process read the entire program directly.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need fix for rsync Error due to version mismatch

rsync --delay-updates -F --compress --archive --rsh='/usr/bin/ssh -t -a -x' /web/admin/Transfer/data/ user1@destserver1:/tmp/testf rsync version on sender server is:3.0.9 rsync version on sender server is:3.0.6 Linux sourceserver1 3.10.0-693.17.1.el7.x86_64 #1 SMP Sun Jan 14 10:36:03 EST... (1 Reply)
Discussion started by: mohtashims
1 Replies

2. HP-UX

Help needed HP UX 11.11i new install on C8000 Desktop messaging system error CAN'T FIX

Hi, I have a HP UX C8000 box , have installed 11.11i from 4 x cds numerous times to try to get a functioning Network or to try and get rid of this error on start up, after new install and 1st startup I get an error "The desktop messaging system could not be started" and then advice about... (12 Replies)
Discussion started by: C8000
12 Replies

3. Shell Programming and Scripting

[Solved] Data error need to fix

Hi Guys, I`m having a strange problem with my data set. Whenever there is a transition to another value is col1, the corresponding 3rd col goes to the next line. This is a huge file, so need to fix in a script. The file is tab delimited. Here is what is happening when transitioning from... (4 Replies)
Discussion started by: gina.lizar
4 Replies

4. Shell Programming and Scripting

Help me please to fix my error

Can you help me to fix my error please?! I checked the code and I think there is no mistake, but when I run it gives me error such line 1: /Users/Manu/trials/hosts: is a directory sort: open failed: /Users/Manu/trials/hosts/*: No such file or directory Help me please... mycode NAME value.... (9 Replies)
Discussion started by: Manu1234567
9 Replies

5. Windows & DOS: Issues & Discussions

Fix script error (%%n)

Hi, I'm currently tinkering with a script that uses the for command to process all *.gif files in the current folder. I marked the spot where it exits out with an error by adding a "pause" The error message given is: convert.exe: unable to open image `%x': No such file or directory @... (2 Replies)
Discussion started by: pasc
2 Replies

6. AIX

I am getting the following error when I do an errpt. What do I need to do to fix it.

Hi Team, I am getting the following error when I do an errpt. What do I need to do to fix it. LABEL: LVM_SA_STALEPP IDENTIFIER: EAA3D429 Date/Time: Sat 12 Jan 01:10:56 2013 Sequence Number: 880 Machine Id: 00C57B904C00 Node Id: spg-lplaw-01... (1 Reply)
Discussion started by: ranjithm
1 Replies

7. UNIX for Dummies Questions & Answers

fix the if and then error in bash

For anyone have work in bash shell scripting before know the if and then statement it work like this if (condition); then I have create a mini shell in C, and I want to make it a bit more tolerable than the normal bash shell where you do not need the ';' between if and then if they are in the... (2 Replies)
Discussion started by: snow2462
2 Replies

8. UNIX for Dummies Questions & Answers

How to fix :[too many arguments error in code

I am getting a :; then echo "Enter zero or one file" echo "You must use a valid directory" echo "Current directory is:" pwd exit 0 fi #Flag Variable flag=1 #Code for no arguments if ; then for filename in * do if ; then ... (2 Replies)
Discussion started by: Brewer27
2 Replies

9. Solaris

How to fix df: cannot statvfs error

I have a Sun Sparc machine with Solaris 9 on it. I changed one file system (also mount point) name from /home to /u01. Then I updated /etc/vfstab. After that, I did df -k, system told me that df: cannot statvfs /home: No such file or directory/. Please tell me how and where to fix this error?... (2 Replies)
Discussion started by: duke0001
2 Replies

10. Solaris

Patching error on Solaris 2.6 - I know the 'fix' - do you?

Patching a Solaris 2.6 server (running application that wasn't approved for anything higher) in single user mode - loading about 120 patches. Following error started occurring after patch 105356-23 /kernel//kernel/strmod/ptem: undefined symbol miocpullup ptem error doing common Actual... (0 Replies)
Discussion started by: RTM
0 Replies
Login or Register to Ask a Question