04-10-2008
passing values from sql to shell script
Hi guyz,
Posting a thread after a long time.
I want to pass two variables to unix shell script from sql script.
Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture email flag in unix.
10 More Discussions You Might Find Interesting
1. Programming
I am having a shell script which has to be called from a C program. I have to pass two parameters to this script. HOw can I do that?
eg:
int main()
{
char st1;
char str2;
// call a shell script
call_sh(str1,str2) where call_sh is the name of the shell script.
then i need to get the return... (5 Replies)
Discussion started by: Rajeshsu
5 Replies
2. Shell Programming and Scripting
Hi all
I want to know how to pass value from one shell script to another
suppose i have script named A.This 'A.sh' calls 'B.sh' .Now some calculations
are done by B.sh ..Say in variable X.
Now i want to pass the value of this X variable to 'A.sh'...
A.sh ----> B.sh ( X variable )
... (6 Replies)
Discussion started by: dhananjaysk
6 Replies
3. Shell Programming and Scripting
Dear Friends,
Please help me to achieve the following:
I want to pass one parameter from Shell-script to Sql-script.
Example:
My ShellScript.sh is calling report.sql like this:
/bin/sqlplus /reports.sql
And
My report.sql is calling many Stored-Procedures like this:
exec... (0 Replies)
Discussion started by: subodhbansal
0 Replies
4. Shell Programming and Scripting
hi I all ,
I have sql statment in my shell script , I pass two argument to the script I need to pass the this two arguments to the sql statment
example :
runsql.sh "1" "2"
sql :
updat tables_x set y=0
where
A=:x should subsituted by "1"
and
B=:y shuold subsituted bt "2"... (1 Reply)
Discussion started by: habuzahra
1 Replies
5. Shell Programming and Scripting
Hi, hope everyone are fine. Please find my issue below, and I request your help in the same
In a configuration file, i have a variable defined as below
TEST = 'One','Two','Three'
I am trying to pass this variable in to a sql script which is define in a pl/sql block
as follows,
In the... (1 Reply)
Discussion started by: ramakanth_burra
1 Replies
6. Shell Programming and Scripting
Hi all,
I am executing shell script in which I am using SQLLDR
In this SQLLDR I am passing text file having PL/SQL script. This script will produce some formated output, this output I have to spool in another text file. Currently I have given this in script file as following
Spool... (2 Replies)
Discussion started by: shekharjchandra
2 Replies
7. Shell Programming and Scripting
Hi,
Solaris : 10 .
I have 3 database in single file system i.e. /d01 . whenever I connect to oracle user using the below method
#su - oracle
It will prompt for which database environment you want to set(PROD,TEST,UAT) :
whichever i need i will enter required DATABASE and perform my... (2 Replies)
Discussion started by: maooah
2 Replies
8. Shell Programming and Scripting
Greetings all,
If I have a SH script that calls a PERL script in the following way:
perl $HOME/scripts/config.properties
And in the config.properties PERL file, this Perl script only sets a number of environmental parameters in the following way:
#!/usr/bin/perl
$VAR1 = (
... (3 Replies)
Discussion started by: gikyo12
3 Replies
9. Shell Programming and Scripting
Hello,
Here is the code i have written to get the count of a plsql query back to the unix.
function checkforCOIDs
{
countcheck=`sqlplus -s $1/$2@$3
whenever oserror exit sql.oscode rollback
whenever sqlerror exit sql.sqlcode rollback
set serverout on size 2000;
set head off feedback off... (2 Replies)
Discussion started by: santosh2eee
2 Replies
10. Shell Programming and Scripting
:wall: Hi,
I have an XML file with 5 tags. I need to pass values to the XML file from a shell script that will replace values in 2 of the tags. I cannot hardcode the tag values in XML and use replace command in script as the values are likely to change.
Please help !!!!!!!!!!! (2 Replies)
Discussion started by: Monalisaa
2 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)