Sponsored Content
Top Forums Shell Programming and Scripting issues with sql inside if statement Post 302714571 by gary_w on Friday 12th of October 2012 10:04:48 AM
Old 10-12-2012
Please see my amended post above.
This User Gave Thanks to gary_w For This Post:
 

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 (4 Replies)
Discussion started by: kotasateesh
4 Replies

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 }' ); ... (6 Replies)
Discussion started by: ryukishin_17
6 Replies

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 ... (0 Replies)
Discussion started by: ryukishin_17
0 Replies

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 Replies)
Discussion started by: q8devilish
5 Replies

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;; ... (3 Replies)
Discussion started by: tirkha
3 Replies

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... (1 Reply)
Discussion started by: The_Ardly374
1 Replies

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... (6 Replies)
Discussion started by: ryddner
6 Replies

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 ... (3 Replies)
Discussion started by: Vares
3 Replies

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. (3 Replies)
Discussion started by: dr46014
3 Replies

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... (6 Replies)
Discussion started by: Sara_84
6 Replies
post(8) 						      System Manager's Manual							   post(8)

NAME
post - deliver a message SYNOPSIS
/usr/lib/mh/post [options] file OPTIONS
Specifies a file that post should take aliases from. More than one file can be specified, each being preceded with the -alias option. The post program automatically consults the system alias file, /usr/lib/mh/MailAliases. If there is an Aliasfile entry in your post also con- sults the file named in that entry. Filters (re-formats) messages sent to blind copy recipients. Recipients named in the Bcc: field nor- mally receive a new message which includes a copy of the message sent to the other recipients. If this option is specified, this copy of the message is filtered according to the instructions in the named file. The default is -nofilter. Formats messages so as to conform to ARPAnet Internet Message Format protocol. This is the default behavior. You can post from formatting messages in this way by using the -noformat option. Prints a list of the valid options to this command. Adds a Message-ID: or Resent-Message-ID: field to the header. Specifies the mail system over which mail is sent. The only value allowed is smtp, which is the standard mail system. Additional values are supported only for use with other mail systems. Informs the user of each step of the posting/filing process. Allows the user to watch the transport system's handling of the message (for example, local and fast delivery). Specifies the preferred length of the header compo- nents that contain addresses. The default settings for post are: -alias /usr/lib/mh/MailAliases -format -nomsgid -mts smtp -noverbose -nowatch -width 72 -nofilter DESCRIPTION
The program post is called by send(1) to deliver the message in the named file to local and remote users. In fact, all of the functions at- tributed to send on its reference page are performed by post, with send acting as a relatively simple pre-processor. Thus, it is post which parses the various header fields, appends From: and Date: lines, and interacts with the transport system. Normally, post would not be called directly by the user. It searches the To:, cc:, Bcc:, and Resent-xxx: header lines of the specified message for destination addresses, checks these addresses for validity, and formats them so as to conform to ARPAnet Internet Message Format protocol (unless the -noformat option is set). This will normally cause @local-site to be appended to each local destination address, as well as any local return addresses. If a Bcc: field is encountered, the mail system will use its addresses for delivery. The Bcc: is removed from the message sent to original recipients. The copied recipients will receive an entirely new message with a minimal set of headers. The mail system includes a copy of the message sent to the original recipients in the body of the message. This command consults the environment variable $SIGNATURE to determine the sender's personal name in constructing the From: line of the message. RESTRICTIONS
For this version, the -mts option only supports the value smtp. Additional values are supported for use only with other mail systems. PROFILE COMPONENTS
The post command does not consult the user's FILES
The system customization file. The program to process Fcc:s. The program to process Bcc:s. The system alias file. SEE ALSO
Commands: comp(1), mhmail(1), send(1) Files: mh-alias(4), mh-mail(4), mtstailor(4) Standard for the Format of ARPA Internet Text Messages (RFC 822) post(8)
All times are GMT -4. The time now is 01:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy