Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: error in if statement
Top Forums UNIX for Dummies Questions & Answers error in if statement Post 302298629 by Swapna173 on Wednesday 18th of March 2009 07:13:51 AM
Old 03-18-2009
error in if statement
Hi,

This is my script to catch any oracle errors.

In this, the $sqlerr returns
ORA-01017: invalid username/password; logon denied
when i specify wrong username/password

the if condition is failing. how can i resolve the issue.
the if statement gives error
Code:
[: too many arguments

Code:
sqloutput=`sqlplus -s -L $dasDBConnectString @$SqlFiles/testSQLConnection.sql`
		sqlerr=`echo "$sqloutput" | grep "ORA-"`
		echo $sqlerr
		if [ -n $sqlerr ] #sql connection error
		then
			Status=10
		else
			Status=$?
		fi

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parsing error in if statement

hello, I am trying to parse an error returned by a command inside the if statement but it is just displays the full error instead and then stops. if ; then echo "no such package" else echo "similar version found will use pkgrm" fi the above code just displays please let me know... (2 Replies)
Discussion started by: rakeshou
2 Replies

2. Shell Programming and Scripting

Error with if statement..Please help

:b:hi, I have a script as given below: pr_det="1" if then awk ' BEGIN {printf("%23s","session")}' >> report.txt awk ' BEGIN {printf "\n"} ' >> report.txt else awk ' BEGIN {printf("%55s","file_dsc")} ' >> report.txt awk ' BEGIN {printf("%101s","no_recs")} '... (1 Reply)
Discussion started by: jisha
1 Replies

3. Shell Programming and Scripting

Snytax error on If Statement--help

year=`date '+%Y'` month=`date '+%m'` day=`date '+%d'` day=`expr $day - 1` case $month in 1 | 3 | 5 | 7 | 8 | 10 | 12);; if($day =7 ); then $day=6 fi 4 | 6 | 9 | 11);; if ; then $day=31 fi 2);; if ; then if ; then (2 Replies)
Discussion started by: dannyd_y
2 Replies

4. Linux

error in if statement

Hi , I am getting an error when I run the script for checking word "view" in a file . I am using if statement. like this if then VW_VAR=` cat $TN.${ecmdate}.sql1 | grep -i view | awk '{print $3}' | cut -d '.' -f2 ` echo " VW_$VW_VAR " sed -e... (16 Replies)
Discussion started by: capri_drm
16 Replies

5. Shell Programming and Scripting

Error in IF statement

HI i am getting error while executing the given statement for filename in `cat a/file.lst` do if then echo "Exit Code Description :File $filename - is missing in Input Directory" >a.log exit else count1=`awk 'END {print NR}' $filename` echo "$count1">>a.log count2=`awk 'END {print... (4 Replies)
Discussion started by: ravi214u
4 Replies

6. Shell Programming and Scripting

error in insert statement

hi, When i try to run the code below, i get the following error "ksh: syntax error: `(' unexpected" i am not able to figure it out. Can anyone help me? Code: (2 Replies)
Discussion started by: ragavhere
2 Replies

7. Shell Programming and Scripting

Error in if statement

I am working on script for stale nfs. the file consists of cat data01stale.log - - - - /abcd/backup - - - - /abcd/data Script (16 Replies)
Discussion started by: nareshkumar522
16 Replies

8. Shell Programming and Scripting

If statement Syntax error

Hi Can you please tell me what is wrong with this line: if && ]; then basically i want to check if x = 12 and F (Filename) end with 'g'. But it is throwing syntax error. (7 Replies)
Discussion started by: rtagarra
7 Replies

9. Shell Programming and Scripting

Awk/if statement error

Can anybody tell the correct way to use the following awk pattern check within an if statement? When I run this command outside of the if statement cat /tmp/test2.out | awk -v T=$TIME -v G=$GROUP -v C=$CDATE '$0 ~ T && $0 ~ G && $0 ~ C' | grep -i "Starting the group" I get the following... (0 Replies)
Discussion started by: kieranfoley
0 Replies

10. UNIX for Beginners Questions & Answers

Error code with if statement

hello all im new to unix and when i use below script i get an error : #! /bin/bash Echo -e "enter the name of the file : \c" read file_name if then echo "$file_name found" else echo "$file_name not found" fi running the script i get below error : $ ./hello (26 Replies)
Discussion started by: Ibrahims1
26 Replies

LEARN ABOUT DEBIAN

cvm-sql

cvm-sql(7)						 Miscellaneous Information Manual						cvm-sql(7)

NAME

       cvm-sql - CVM SQL Framework

QUERY SUBSTITUTION

       $VAR  and  ${VAR} are replaced with the quoted value of the environment variable named VAR.  Use the second form when VAR contains anything
       other than alpha-numeric or underscore (_) characters.  Do not include quotes in the query.  The variables account and domain  contain  the
       account and domain names given by the CVM client.  $$ is replaced with a single dollar sign.

QUERY RESULTS

       The query must produce the following fields exactly in order.  All required fields must not be null or empty.

       1.     Password, encrypted with crypt(3) (required)

       2.     Actual account name (required)

       3.     User ID (integer) (required)

       4.     Group ID (integer) (required)

       5.     Directory (required)

       6.     Real name (optional)

       7.     Login shell (optional)

       8.     Group name (optional)

       9.     Domain name (optional)

       10.    System account name (optional)

       11.    System account directory (optional)

       12.    Mailbox path (optional)

DEFAULT QUERY

       SELECT  password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
       username=$account AND domain=$domain

SEE ALSO

       cvm-mysql(8), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/cvm/cvm.html

																	cvm-sql(7)
All times are GMT -4. The time now is 08:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy