issues with sql inside if statement Post: 302714571

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sql inside a script

Hi, In a KSH script i have to run a sybase query and get the count into a unix variable. How can i do that? Your help is much appriciated. Thanks, sateesh

2. Shell Programming and Scripting

How to call an sql script inside a while statement in KSH

Hi all, I'm trying to run an sql inside a loop which looks like this #!bin/ksh while IFS=, read var1 var2 do sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF insert into ${TABLE} ( appt_date ) values ( '${var1 }' ); ...

3. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

hi all, i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code. sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE whenever sqlerror exit set serveroutput on size 1000000 declare l_rc ...

4. Shell Programming and Scripting

if inside while statement (PLZ HELP)

hey guys i need some help here i am trying to do a bash shell script to get a parent PID and then search for all childs and kill them all without killing the parent, my problem is in the loop it seems that i dont know how to make a if statment inside a while statment it does not give me what i...

5. Shell Programming and Scripting

Read from user inside a while statement

Hi there I want to ask to a user something about each line of a file. This is my code: #cat test.txt first line second line third line #cat test.sh #!/bin/ksh read_write () { echo "Do you want to print the line (YES/NO)?\n" read TEST case ${TEST} in YES) return 0;; ...

6. Shell Programming and Scripting

Bash Script Issues (If statement for file copying)

Writing a bash script for use with Geektool, pulls the battery info, and shuffles images around so that an Image geeklet can display the correct expression as the desktop background. (Eventually I intend to make it more intricate, based on more variables, and add more expressions) I'm extremely...

7. Shell Programming and Scripting

Multiple conditions inside my if statement

Hello, I am using shell scripting and I am recieving odd results from my if statement if I want it to enter the loop only if L1 is equal to zero and one of the other criteria are filled, however it is entering at other times as well. What can i do to fix this? i tried seperating it...

8. Shell Programming and Scripting

Use sqlplus statement inside case sentence

Hello, I have a problem. I want to launch a different sql queries for different shell parameter values, something like this. #/bin/bash case $1 in "A") sqlplus -s user/pass << SQL query A; SQL "B") sqlplus -s user/pass << SQL2 ...

9. Shell Programming and Scripting

Multiple conditions inside if statement

I was trying to write multiple conditions inside the if statement but its not working. export VAR_NM=abc.txt export CURR_DT=20131011 export PREV_DT=20131012 if && then echo "Yes" else echo "NO" fi It should return Yes but returning NO always.Appreciate any help.

10. Shell Programming and Scripting

Command in inside awk statement

Hello can you please help me with below script which is meant to delete clients from multiple netbackup policies I want to run a command insdie awk statement apparelnlty this script is not working for me for i in $( cat clients_list) do bppllist -byclient $i | awk...

LEARN ABOUT DEBIAN

blaze-remove

BLAZE-REMOVE(1) 					    BlazeBlogger Documentation						   BLAZE-REMOVE(1)

NAME

       blaze-remove  - removes a post or page from the BlazeBlogger repository

SYNOPSIS

       blaze-remove [-fipqPV] [-b directory] id...

       blaze-remove -h|-v

DESCRIPTION

       blaze-remove removes a blog post or a page with the specified id from the BlazeBlogger repository.

OPTIONS

       -b directory, --blogdir directory
	   Allows you to specify a directory in which the BlazeBlogger repository is placed. The default option is a current working directory.

       -p, --page, --pages
	   Tells blaze-remove to remove a page or pages.

       -P, --post, --posts
	   Tells blaze-remove to remove a blog post or blog posts. This is the default option.

       -f, --force
	   Disables requiring manual confirmation of each blog post or page removal.  This is the default option.

       -i, --interactive
	   Enables requiring manual confirmation of each blog post or page removal.

       -q, --quiet
	   Disables displaying of unnecessary messages.

       -V, --verbose
	   Enables displaying of all messages. This is the default option.

       -h, --help
	   Displays usage information and exits.

       -v, --version
	   Displays version information and exits.

EXAMPLE USAGE

       Remove a blog post:

	 ~]$ blaze-remove 10
	 Successfully removed the post with ID 10.

       Remove a page:

	 ~]$ blaze-remove -p 4
	 Successfully removed the page with ID 4.

       Remove multiple blog posts:

	 ~]$ blaze-remove 10 4 6
	 Successfully removed the post with ID 10, 4 and 6.

       Remove multiple blog posts safely:

	 ~]$ blaze-remove -i 10 4 6
	 Remove the post with ID 10 titled `Debian and Fedora Packages'? y
	 Remove the post with ID 4 titled `BlazeBlogger 0.8.0 RC2'? y
	 Remove the post with ID 6 titled `BlazeBlogger 0.8.1'? y
	 Successfully removed the post with ID 10, 4 and 6.

SEE ALSO

       blaze-config(1), blaze-add(1), blaze-list(1)

BUGS

       To report a bug or to send a patch, please, add a new issue to the bug tracker at <http://code.google.com/p/blazeblogger/issues/>, or visit
       the discussion group at <http://groups.google.com/group/blazeblogger/>.

COPYRIGHT

       Copyright (C) 2008-2011 Jaromir Hradilek

       This program is free software; see the source for copying conditions. It is distributed in the hope that it will be useful, but WITHOUT ANY
       WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Version 1.2.0							    2012-03-05							   BLAZE-REMOVE(1)