Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

"If" command not working.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting "If" command not working.
# 1  
Old 06-27-2014
"If" command not working.
I have the following script:
Code:
isql -Uabc -SSYB_LOCOMOTIVE -Ppwd -D ex_ecmapn_dd -oakanksha.txt <<EOF
select wc_clm_id from ex_ecmapn_dd..ex_arh_rtv_req_t
go
EOF
(sed 1,2d akanksha.txt > abc.txt |  sed '$d' abc.txt) > new.txt
(paste -sd, new.txt > xyz.txt | sed "s/,$//" xyz.txt)>lmn.txt
isql -Uabc -SSYB_LOCOMOTIVE_JE -Ppwd -Dex_ecmje_dd -oakanksha.txt <<EOF
select sum(count(*)) from ex_ecmje_dd..ex_je_t where clm_id in (`cat lmn.txt`) group by clm_id
go
EOF
(sed 1,2d akanksha.txt > abc.txt |  sed '$d' abc.txt) > new.txt
count=$(<new.txt)
thresholdValue=35000
if[$count -le $thresholdValue];
then  mailx -s "hi" "akanksha.kumari@xyz.com"
echo "success"
fi

and i am getting following error:
Code:
Script.ksh[14]: if[:  not found.
Script.ksh[15]: 0403-057 Syntax error at line 15 : `then' is not expected.

# 2  
Old 06-27-2014
Code:
if [ $count -le $thresholdValue ]

The spaces are important.
This User Gave Thanks to CarloM For This Post:
Sharma331
# 3  
Old 06-27-2014
Still not working tried by giving spaces
# 4  
Old 06-27-2014
TRy
Code:
COUNT=$(cat new.txt)

# 5  
Old 06-27-2014
Quote:
Originally Posted by Sharma331
Still not working tried by giving spaces
With exactly the same error? If not, post the output - otherwise we're just guessing.
# 6  
Old 06-27-2014
Quote:
Originally Posted by CarloM
With exactly the same error? If not, post the output - otherwise we're just guessing.
Yes CarloM its exactly the same error

---------- Post updated at 08:13 AM ---------- Previous update was at 08:07 AM ----------

Quote:
Originally Posted by vbe
TRy
Code:
COUNT=$(cat new.txt)

Tried this also still the same error

---------- Post updated at 08:27 AM ---------- Previous update was at 08:13 AM ----------

Just foran update.
I was trying to run this script step by step like first i added isql then ran the script.
Again added sed statements and ran the script.
Again added isql and ran the script.
All the time script was running fine and i was getting all the expected results.
Last step was to compare.
The moment i added the if statement i started getting error...

If this info helps..
Thanks
# 7  
Old 06-27-2014
try not to copy paste the if statement. Please write it down manually using vi editor. The syntax should be if [ condition ];

space after '[' and before ']'
This User Gave Thanks to Souvik Patra For This Post:
Sharma331
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using sed command to replace "|" with ^ for all *.dat files in a folder not working

I am trying to use the below sed command to replace all "|" to ^, in a folder had 50 dat files. when i tried with 1 file it worked but when i tried with wild card, is not working. sed -i 's/"|"/\^/g' *.dat Is this the proper way to use sed command thank you very much for help. (3 Replies)
Discussion started by: cplusplus1
3 Replies

2. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

3. Filesystems, Disks and Memory

"parted" command not working in Fedora9

I ran the foll. command: parted /dev/sdb (parted) p mkpart primary 1GB 1.5GB The parted command (when I print the details) outputs something like below: 1 2048MB ....... what I want to bring in your notice that only 1 row came showing the complete size of the disk (detachable device)... (1 Reply)
Discussion started by: ravisingh
1 Replies

4. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

5. UNIX for Advanced & Expert Users

command for recently modified files - "find" command not working

I have three files a.txt , b.txt , c.txt in a directory called my_dir1 .These files were created before two or three months . I have a tar file called my_tar1.tar which contains three files a.txt , b.txt , d.txt . Somebody untarred the my_tar1.tar into my_dir1 directory. So existing two files were... (1 Reply)
Discussion started by: joe.mani
1 Replies

6. Shell Programming and Scripting

"sed" command is not working in shell script

Hi All, I am not much strong in shell scripting... I am using sed command in my script to find and replace a string....... This is how script looks : ############# #!/usr/bin/ksh CONFIG_FILE=iom_test.txt FIND=`echo "NIS_FTP_SERVER1=123.456.iom.com"` REPLACE=`echo... (2 Replies)
Discussion started by: askumarece
2 Replies

7. Shell Programming and Scripting

sub option of awk command not working with "\" character.

Hi all, I would like to replace some string in a text file by some string which would contains special characters like "/","\". I.e. I have a text file with the statement contactperson somewhere in it. Now I want to replace it by something else which includes special characters like "/","\" ... (1 Reply)
Discussion started by: shareef
1 Replies

8. UNIX for Advanced & Expert Users

Running command "md5" on remote host not working.

My question is very strange. I can run ls command on remote host using ssh successfully. but when i try to run /sbin/md5 command on remote host. it doesnt run and get back to me on command prompt. md5 command is exist on remote host. This is what i tried which ran successfully. Query -... (1 Reply)
Discussion started by: ynilesh
1 Replies

9. UNIX for Dummies Questions & Answers

Listing only directories in the current working directory using the "ls" command

Hello All, I am trying to list only directories in my current directory using the command "ls -d". But the output only contains the default directory "." and doesn't list the rest of the directories in the working directory. Can anyone explain why this is happening (2 Replies)
Discussion started by: igandu
2 Replies
Login or Register to Ask a Question