10-21-2009
Hi.
It helps if you post examples representative to your problem. This saves on the guess work.
My previous post shows how to return values from SQL/Plus into a shell variable.
If that's not enough, please do let me know.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am coding shell script.
I need to connect to different databases like DB2, Oracle and Sybase.
I would then need to query tables where it has all the groups, users for that database.
I would also need who has what kind of permissions.
EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies
2. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
3. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
4. Shell Programming and Scripting
hi Guys,
i have a problem with oracle query in my unix script..
I'm getting the following error while executing..
./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
7. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
8. Shell Programming and Scripting
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies
9. Shell Programming and Scripting
Hi,
Im new to DB2.
I need to connect to DB2 from shell script and return the query output back to shell script variable.
this is my code
#!/bin/ksh
db_name=db
db_user=usr
db_pwd=pwd
db2 <<EOSQL
connect to $db_name user $db_user using "$db_pwd"
select count(1) from table
quit
EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies
10. Shell Programming and Scripting
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 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)