Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Condition checking issue while if
Top Forums Shell Programming and Scripting Condition checking issue while if Post 302835649 by lovelysethii on Monday 22nd of July 2013 10:41:10 PM
Old 07-22-2013
here is my updated string:

Code:
#!/bin/csh


# ***  Lovely Sethi 08/2013  ***
#  This process executes the BRAVO_MAIN_REFRESH.sql
#
#  This file should be scheduled in CRONTAB to run each Big run.

#  /uv1402/u207/home/bravodba/bestdbscript/shscriptfiles/RUNDATE.sh

end_ct=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID   << EOF
                select description from bravo_statistics
                where trunc(time_stamp)=trunc(sysdate)-4
                and description='END CAT';
EOF`
echo $end_ct;
emtr_cnt=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID   << EOF
                select count(*) from mrs.bill_cal
                where trunc(actual_run_date)=trunc(sysdate)-3;
EOF`
echo $emtr_cnt;
if [ "$end_ct" -eq "END CAT" ] && [ $emtr_cnt -eq 1 ]; then
echo $end_ct
else
echo "value not found"
fi

#sqlplus $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID @/uv1402/u207/home/bravodba/bestdbscript/sqlscriptfiles/BRAVO_MAIN_REFRESH.sql
#/uv1402/u207/home/bravodba/bestdbscript/shscriptfiles/sendmailanalysisrefresh.sh

value of both the variables are true, so it should echo $end_ct, but instead it is first giving an error:
Quote:
sh bravo_main_refresh.sh
+ sh bravo_main_refresh.sh
DESCRIPTIO ---------- END CAT
COUNT(*) ---------- 1
bravo_main_refresh.sh: test: unknown operator ----------

please suggest
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Condition checking

Dear all That's another problem from me, i wanna do a lot of if statement checking for correct input by user, will be prompt input again if the input not meet the requirement defined by If or while statement... like this one .... while I know it's less effiency write the program... (14 Replies)
Discussion started by: trynew
14 Replies

2. Shell Programming and Scripting

Checking condition inside the loop

Hi all, I have one clarification i am using the loop which will process for each record .suppose there is f ailure in the first record it need to send mail and process the next .my code: defcount=`cat <filename>|wc -l` while ] do if <some condiotion> then echo "mail" fi done so... (1 Reply)
Discussion started by: ithirak17
1 Replies

3. Shell Programming and Scripting

sed solution for condition checking

Hi all , Recently i came across this in FAQ's. I have a file cat rem.txt sreedhar 20 sreedhar 10 sreedhar 15 sreedhar 18 sreedhar 16 sreedhar 30 I have to replace sreedhar with "Sridhar" if the second parameter is > 18. I need to do it in "sed" only. I am wondering how this... (4 Replies)
Discussion started by: panyam
4 Replies

4. Shell Programming and Scripting

Unzip file By checking condition.

Hi.. Gurus I Have a list of .zip files in a directory. I want to check whether each .zip file having some particular file or not (say .jsp) if it's having .Jsp file then create a directory as per the .zip file and extract the content to that directory except the .jsp file, If .zip not having... (3 Replies)
Discussion started by: posix
3 Replies

5. Shell Programming and Scripting

Cutting specific line of a file by checking condition

testfile.csv 0","1125209",,"689202CBx18888",,"49",,,"NONMC",,,,,"01112010",,,,,,,"MTM- "1","",,"689202ABx19005",,"49",,,"NONMC",,,,,"01072010",,,,,,,"MTM- testfile.csv looks like above format if the second column is null then get 23rd column and store in a different varible .. add all the... (1 Reply)
Discussion started by: mgant
1 Replies

6. Shell Programming and Scripting

create separate file after checking condition..

Problem : I want to create a separate file for country list if condition is true. Please help. ***************************************************** Input file: SV-INCR-139302-365540488-201104090934.sqllog SV-INCR-1082-552793184-201104040805.sqllog SV-INCR-1077-855045741-201104040805.sqllog... (4 Replies)
Discussion started by: humaemo
4 Replies

7. Shell Programming and Scripting

Multiple condition checking in bash

Hi All, I am trying to check if two variables have value assigned to it. i am doing it like if ] then echo "Please specify either single hostname or host file for the report" usage exit fi But its not working for it.Even i specify values for both variables it dont go... (6 Replies)
Discussion started by: kailash19
6 Replies

8. Shell Programming and Scripting

Checking file existence along with condition

Hi am trying to write a script which find the existence of a file from a find command output and perform a task if the file exists. Help me out with the correct syntax . Am trying with the following one but unable to get the output. if then <some tasks> else echo "file not exists" fi (5 Replies)
Discussion started by: rogerben
5 Replies

9. Shell Programming and Scripting

Condition checking in UNIX

i have a script where i have to find the age of a file, if then echo "dnb file is present for the monthly load" >> $RUNLOG dnb="1" else echo "dnb file has not arrived yet" > $ERRLOG dnb="0" fi i know the file is available so... (3 Replies)
Discussion started by: lovelysethii
3 Replies

10. Shell Programming and Scripting

Checking for null condition in a UNIX variable

i have this code for i in `cat sql_output.txt` do -- some script commands done sql_output.txt has 1 column with employee_ids If the sql_output.txt is null then the do loop should not execute. How can i implement this. for i in `cat sql_output.txt` If i is null or empty then ... (5 Replies)
Discussion started by: rafa_fed2
5 Replies

LEARN ABOUT OSF1

sbig5

sbig5(5)							File Formats Manual							  sbig5(5)

NAME

       sbig5 - A character encoding system (codeset) for Traditional Chinese

DESCRIPTION

       The  Shift  Big-5  (sbig5)  codeset is a variant of the Big-5 codeset (see big5(5)). The only difference between these codesets is that the
       second byte of some Big-5 characters are mapped to different values in the Shift Big-5 codeset. The remapping is done to avoid having  some
       metacharacters like *, which has special meaning to UNIX commands, in the second byte of a 2-byte Big-5 character.

       The mappings of Big-5 characters to Shift Big-5 characters are as follows:

       ------------------------------------------------------------------------
       Big-5	 (2nd	Character Symbol   Shift Big-5 (2nd   Character Symbol
       byte)				   byte)
       ------------------------------------------------------------------------
       40		@		   30		      0
       5B		[		   31		      1
       5C				   32		      2
       5D		]		   33		      3
       5E		^		   34		      4
       5F		-		   35		      5
       60		`		   36		      6
       7B		{		   37		      7
       7C		|		   38		      8
       7D		}		   39		      9
       7E		~		   9F		      nil
       ------------------------------------------------------------------------

       The sbig5 codeset is not supported by a locale but only through codeset conversion.

   Codeset Conversion
       The following codeset converter pairs are available for converting Traditional Chinese characters between sbig5 and other encoding formats.
       Refer to iconv_intro(5) for an introduction to codeset conversion. For more information about the other codeset	for  which  sbig5  is  the
       input or output, see the reference page specified in the list item.  big5_sbig5, sbig5_big5

	      Converting from and to the Big-5 codeset: big5(5).

	      Note that Big-5 encoding is equivalent to the Microsoft code-page format used on PCs for Traditional Chinese. Therefore, you can use
	      these converters to convert Traditional Chinese between PC code-page format and Shift Big-5 encoding.  eucTW_sbig5, sbig5_eucTW

	      Converting from and to Taiwanese Extended UNIX Code: eucTW(5).

SEE ALSO

       Commands: locale(1)

       Others:	ascii(5),  big5(5),  Chinese(5),  code_page(5),  dechanyu(5),  dechanzi(5),  eucTW(5),	GBK(5),  i18n_intro(5),  i18n_printing(5),
       iconv_intro(5), l10n_intro(5), telecode(5)

																	  sbig5(5)
All times are GMT -4. The time now is 08:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy