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 More Discussions You Might Find Interesting
1. Solaris
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
2. Solaris
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
3. UNIX for Dummies Questions & Answers
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
4. UNIX for Dummies Questions & Answers
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
5. AIX
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
6. Windows & DOS: Issues & Discussions
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. HP-UX
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
10. Shell Programming and Scripting
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