Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Passing variables to sql from batch shell in linux
Operating Systems Linux Passing variables to sql from batch shell in linux Post 76452 by rama71 on Tuesday 28th of June 2005 11:16:45 AM
Old 06-28-2005
Passing variables to sql from batch shell in linux
Hi,

I need to put this command in a batch shell.

sqlplus -s user/password @test.sql

and in the test.sql I have this command

select * from pbempl where pebempl_id = $1;

How I can pass the variable $1 from the batch shell???

Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Passing PL/SQL variable value to Shell Varible

Hi my UNIX Friends, Im calling some SQL scripts through Unix Shell scripting. How do I export the value of PL/SQL variable value into a Unix shell script variable? Also could any one inform me about the 'search' and 'cut' utility of PL/SQL (like 'grep' and 'cut' in Shell scripting). ... (10 Replies)
Discussion started by: ganapati
10 Replies

2. Shell Programming and Scripting

passing two variables into a shell script?

Hello all, i have a infile.txt text file which contains such variables: aaa 123 asds 1323 asdsd 13434 lkjlkj 324324 23432 lkjlkj 24324 ljlkj 3j4lk 234kj3 and i want to pass them to my script such as: ./myscript $1 $2 where $1 is the first value in the first row and $2 is the second... (2 Replies)
Discussion started by: Bashar
2 Replies

3. Shell Programming and Scripting

Passing argumnets from shell script to sql

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

4. Shell Programming and Scripting

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

5. Shell Programming and Scripting

Passing Shell Variables in ISQL

Hi.. I am passing a variable in my shell function. I need to access it for an isql comand in the shell script. However the isql o/p gives no results if i pass a variable in the command. The isql command works perfectly fine if i hardcore the table name. My script is : ... (0 Replies)
Discussion started by: dikki
0 Replies

6. Shell Programming and Scripting

Passing the nawk variables to the shell

nawk '($1 ~ "1000") && ($1 ~ "5665" ) { sub ($6,"89");flag =1;print }' old.txt >> new.txt I want to set a flag in awk , if the both conditions are met. I want to pass this flag to shell Can anyone please help me on this (1 Reply)
Discussion started by: prav076
1 Replies

7. UNIX for Dummies Questions & Answers

Passing Shell Variables to an awk command

Hello, I have two files File1 & File2. File1 76 135 136 200 250 345 .... File2 1 24 1 35 1 36 1 72 .... I want to get all the values form File2 corresponding to the range in File 1 and feed it to a program. Is the code below right? Can I pass shell variables to awk in this... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

8. Homework & Coursework Questions

Passing shell variables to a webpage

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: This is my assignment as a whole - Use SVG to present certain dynamic (the raw data should change at least once... (5 Replies)
Discussion started by: ChedWick
5 Replies

9. Shell Programming and Scripting

Passing awk variables to shell

Hi. I need to parse file and assign some values to variables, right now i do like below MYHOMEDIR=`awk '/Home/ {print $NF}' output.txt` MYSHELL=`awk '/Shell/ {print $NF}' output.txt` PRGRP=`awk '/Primary/ {print $NF}' output.txt` SECGRP=`awk '/Second/ {print $NF}' output.txt` In this... (10 Replies)
Discussion started by: urello
10 Replies

10. UNIX for Dummies Questions & Answers

Passing Global Shell variables to awk

Hi All, Iam trying to pass global shell variables and is not working Main script is like below CYEAR=`date +"%y"` CFYEAR=`date +"%Y"` CMONTH=`date +"%m"` if then PMONTH=12 PYEAR=`expr $CYEAR - 1` PFYEAR=`expr $CFYEAR - 1` else PMONTH=`expr... (6 Replies)
Discussion started by: baanprog
6 Replies

LEARN ABOUT REDHAT

mysql

MYSQL(1)						      General Commands Manual							  MYSQL(1)

NAME

       mysql - text-based client for mysqld, a SQL-based relational database daemon

SYNOPSIS

       mysql   [-B|--batch]   [-#|--debug=   logfile]  [-T|--debug-info]  [-e|--exec=  command]  [-f|--force]  [-?|--help]  [-h|--host=  hostname]
       [-n|--unbuffered] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-q|--quick]  [-r|--raw]  [-s|--silent]  [-S|--socket=	snum]  [-u|--user=
       uname] [-v|--verbose] [-V|--version] [-w|--wait]

DESCRIPTION

       The  mysql  program provides a curses-based interface to the SQL-based database server daemon, mysqld(1).  Full fuller documentation, refer
       to the HTML documents installed with the package.

OPTIONS

       -B|--batch
	      Print results with a tab as separator, each row on a new line.

       -#|--debug=logfile
	      Employ the specified debug log.

       -T|--debug-info
	      Print debug information upon exiting.

       -e | --exec=command
	      Execute the specified command and quit (--batch is implicit).

       -f|--force
	      Continue even if the face of a SQL error.

       -?|--help
	      Display a help message and exit.

       -h|--host=hostname
	      Connect to the specified host.

       -n|--unbuffered
	      Flush the buffer after each query.

       -p|--password[=pwd]
	      Employ the specified password when connecting to the database server.  If a password is not supplied, it will be requested  interac-
	      tively.

       -P|--port=pnum
	      Employ the specified port number for connecting to the database server.

       -q|--quick
	      Do not cache the result; print it row by row.  This may slow down the server if the output is suspended.

       -r|--raw
	      Write fields without conversion.	(used with --batch).

       -s|--silent
	      Silent mode: reduce the amount of output.

       -S|--socket=snum
	      Employ the specified socket file for connecting to the database server.

       -u|--user=uname
	      Employ the specified user name for logging in to the server.

       -v|--verbose
	      Verbose mode: write more Specifying this option twice produces a tabular output format.

       -V|--version
	      Print the mysql version number and exit.

       -w|--wait
	      Wait and retry if the database server connection is down.

FILES

       /depot/bin/mysql      executable

       /depot/bin/mysqld     executable

       /depot/bin/safe_mysqld
			     executable shell script for starting mysqld safely

       /site/var/mysql/data  location of database files

EXAMPLE

       You can also read a backup dump file back into MySQL with:

       mysql  database < backup-file.sql

SEE ALSO

       isamchk	(1),  isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver 6.3, distribution 3.20.20 Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with no
       warranty.   Manual  page  by  R. P. C. Rodgers, Lister Hill National Center for Biomedical Communication, U.S. National Library of Medicine
       (rodgers@nlm.nih.gov).

								   13 June 1997 							  MYSQL(1)
All times are GMT -4. The time now is 09:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy