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!
# 8  
Old 11-25-2011
One simple mistake cost me one hour....
Quote:
#!/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" | tr -d '\r' | mdsql
echo "-----script end `date` for $file----" >>log.txt
done
sleep 60
done
thanks a lot felipe and methyi...... Proud to be a member of this site..........

---------- Post updated at 12:18 AM ---------- Previous update was at 12:09 AM ----------

No I didn't mean the head command... I missed tr command in the highlighted line. mdsql is a tool similar to dbaccess...
# 9  
Old 11-25-2011
Well I'll say it if nobody else will!
You are clearly processing text files which were prepared on a Microsoft platform and contain the MSDOS line terminator <carriage-return><line-feed> rather than a standard unix text file which contains just the line terminator <line-feed>.
You will make your whole life easier if you convert the files from MSDOS format to UNIX format first. There are standard utilities with unix but the name varies with the unix version. Usually "dos2ux" or "dos2unix". See your "man" pages or tell us what Operating System you have.

Ps. I'm still concerned that you will be invoking "mdsql" once for every line of SQL. This appears to be grossly inefficient.
# 10  
Old 11-26-2011
Yes Methyl........ Need to find an alternative to use mdsql only once....... By the way I prepare the text files in unix platform only........
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