Sponsored Content
Full Discussion: Passing variable to sql
Top Forums Shell Programming and Scripting Passing variable to sql Post 302841643 by blackrageous on Wednesday 7th of August 2013 04:58:28 PM
Old 08-07-2013
here's something I do a lot, use a here document in a script or command line...
Code:
#! /bin/bash
.
.
.
msyql -u username --password=foobar <<EOD
select * from ${1};
.
.
.
EOD
# back in bash script context

 

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. UNIX for Advanced & Expert Users

passing value to a variable in a SQL

Hi Folks, This is a small chunk of the bigger problem which i am facing and some help here will help me resolve the rest of the issue. Problem is that i need to pass the value of a variable from a shell script to a SQL query (infact a lot of SQL's) i have the following solution but somehow... (4 Replies)
Discussion started by: kamitsin
4 Replies

3. Shell Programming and Scripting

Passing argument to a pl/sql block

Hi, How can I pass an argument to a pl/sql block through perl/unix shell scripting. (2 Replies)
Discussion started by: er_ashu
2 Replies

4. Shell Programming and Scripting

passing paramaters to a pl\sql precedure

I have this piece code in a shl, I need to pass paramaters to a PL\SQL PRECEDURE like $fseqno and faidy I know that the $fseqno works correctly but I am not sure aboyt the faidy can I code it like that faidy ='0910' ? Thank you for i in 3526*.dat do # Capture just the file... (1 Reply)
Discussion started by: rechever
1 Replies

5. Shell Programming and Scripting

passing arguments to sql script

Hi Gurus, i have one requirement in unix script, i have a file called abc.txt in that few lines are there with the empid, i need to read each line and pass to .sql script. ex: abc.txt 2345 2346 1243 1234 i need to pass these arguments to .sql script rom unix ex: select * from... (1 Reply)
Discussion started by: Devendar
1 Replies

6. UNIX for Advanced & Expert Users

Passing Hash variable in to sql query in perl

Hi Everyone, Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below i have defined two Hash %lc and %tab as below $lc{'REFF'}='V_RES_CLASS'; $lc{'CALE'}='V_CAP_CLASS'; $lc{'XRPD'}='V_XFMR_CLASS'; $tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
Discussion started by: jam_prasanna
6 Replies

7. Shell Programming and Scripting

Passing a string variable from Unix to Sql Plus

Hi Guys, I am trying to pass a string variable from Unix shell script to sqlplus as a parameter. I have tried using single quotes with the variable name but it does not work. Please help me with it. I am using BASH. My code: Your help is much appreciated. Thanks, shil (2 Replies)
Discussion started by: infintenumbers
2 Replies

8. Shell Programming and Scripting

Passing variable from file to sql from script

Hi Friend, I have one file in which some number are mentioned and number of lines are vary every time And i need to pass that number to my sql command from script. Suppose i have file acc.txt 45456546456 45464564565 67854353454 67657612132 Number of records are vary every time.... (20 Replies)
Discussion started by: pallvi_mahajan
20 Replies

9. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

10. Shell Programming and Scripting

Passing sql file name as an argument

Hi all, I have a a file which contains an oracle query. If this file is pushed into a shell script such as the below, it of course works fine. #!/usr/bin/sh su - oracle -c 'sqlplus -s / as sysdba <<EOF @/home/cron/ORA/sql/T-ORA006-OracleSessions.sql exit; EOF . What i am after... (2 Replies)
Discussion started by: nms
2 Replies
TENTACLE_CLIENT(1)					   Client file transfer protocol					TENTACLE_CLIENT(1)

NAME
tentacle_client - a client file transfer protocol SYNOPSIS
tentacle_client <options> Tentacle is a client/server file transfer protocol that aims to be: - Executable programs or shell commands - System calls (functions provided by the kernel) - Library calls (functions within program libraries) Tentacle was created to replace more complex tools like SCP and FTP for simple file transfer/retrieval, and switch from authentication mechanisms like .netrc, interactive logins and SSH keys to X.509 certificates. Simple password authentication over a SSL secured connection is supported too. The client and server (TCP port 41121) are designed to be run from the command line or called from a shell script, and no configuration files are needed. Tentacle is now the default file transfer method for Pandora FMS and Babel Enterprise. Tentacle is implemented in Perl and ANSI C (Windows platforms included). You can download it and get more information at the official Sourceforge website http://tentacled.sourceforge.net/. OPTIONS
Tentacle Client options : -a address : Server address (default 127.0.0.1). -c : Enable SSL without a client certificate. -e cert : OpenSSL certificate file. Enables SSL. -f ca : Verify that the peer certificate is signed by a ca. -g : Get files from the server. -h : Show help. -k key : OpenSSL private key file. -p port : Server port (default 41121). -q : Quiet. Do now print error messages. -r number : Number of retries for network operations (default 3). -t time : Time-out for network operations in seconds (default 1s). -v : Be verbose. -w : Prompt for OpenSSL private key password. -x pwd : Server password. EXAMPLES
tentacle_client -a 192.168.1.1 -v /bin/bash Simple file transfer with maximum file size set to 1MB tentacle_client -a 192.168.1.1 -x password -v /bin/bash Simple file transfer with password authentication (not secure) tentacle_client -a 192.168.1.1 -x password -e cert.pem -k key.pem -v /bin/bash Secure file transfer with client certificate and password authentication NOTES
Tentacle requires Perl 5.8 or higher to works SEE ALSO
tentacle_server(1), pandora_server(1), pandora_agent(1) 0.2.0 2010-05-11 TENTACLE_CLIENT(1)
All times are GMT -4. The time now is 03:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy