error in if statement Post: 302193536

Sponsored Content

Operating Systems Linux error in if statement Post 302193536 by capri_drm on Friday 9th of May 2008 05:44:04 PM

05-09-2008

Registered User

I modified the add VW_ section. When I run it as sh -x scriptname <dbname> <source_schema> <target schema>
the output on screen is exactly what I want but the files generated is not the one. I am missing the output of files somewhere .

##############################################################################
#checks if the file has view in it
#############################################################################
cat $TN.${ecmdate}.sql | grep -i 'view'
if [ $? -eq 0 ]
then
VW_VAR=` cat $TN.${ecmdate}.sql | grep -i view | awk '{print $3}' | cut -d '.' -f2 `
echo " VW_$VW_VAR "
sed -e 's/'${VW_VAR}'/VW_'${VW_VAR}'/g' $TN.${ecmdate}.sql > $tmpfile_cln
cat $tmpfile_cln
# cat $tmpfile_cln > $TN.${ecmdate}.sql
else
cat $TN.${ecmdate}.sql > $tmpfile_cln
fi

################################################################################################

help please !

capri_drm

View Public Profile for capri_drm

Find all posts by capri_drm

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. 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")} '...

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

4. 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...

5. 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:

6. UNIX for Dummies Questions & Answers

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 sqloutput=`sqlplus -s -L...

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

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.

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...

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

LEARN ABOUT DEBIAN

isql

isql(1) 							UnixODBC Reference							   isql(1)

NAME

       isql - utility to submit SQL queries to a data source.
       iusql - Unicode version of isql.

SYNOPSIS

       isql DSN [UID [PWD]] [options]

DESCRIPTION

       isql can be used to submit SQL to a data source and to format/output results.  It can be used in batch or interactive mode.

OPTIONS

       DSN    Name of the data source you want to connect to.

       UID    Your login to connect the DSN.

       PWD    Your password needed to login to the DSN.

       -b     Batch mode.  It will not do any prompting.

       -dx    Delimit columns with x.

       -x0xXX Delimit columns with XX, where XX is in hex.  For example -x0x09 will use a tab.

       -w     Wrap results in an HTML table

       -c     Print column names on first row.	This options only has effect in combination with the -d option.

       -mn    Limit column display width to n

       -v     Verbose output.

       --version
	      This prints the version.

EXAMPLES

       cat My.sql | isql WebDB MyID MyPWD -w
	      Each line in My.sql must contain exactly 1 SQL command except for the last line which must be blank.

AUTHOR

       This manual page was written by Kurt Roeckx <kurt@roeckx.be> for the Debian package of unixODBC.

UnixODBC							     Dec 2004								   isql(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parsing error in if statement

Discussion started by: rakeshou

2. Shell Programming and Scripting

Error with if statement..Please help

Discussion started by: jisha

3. Shell Programming and Scripting

Snytax error on If Statement--help

Discussion started by: dannyd_y

4. Shell Programming and Scripting

Error in IF statement

Discussion started by: ravi214u