Redirect output from SQL to unix variable

10 More Discussions You Might Find Interesting

1. 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...

2. Shell Programming and Scripting

SQL output to UNIX variable

I have a sql statement , i need to assign to a variable in Unix sel count(*) AS num_files from TABLE_A; i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files

3. Shell Programming and Scripting

How to redirect output of a command to a variable during ftp mode?

Hi, How can I redirect the output of a following command to a variable. ftp myservername ftp> user (username) guptaji 331 Password required for guptaji. Password: ftp> size /home/salil/abc.dat ftp> a='size /home/salil/abc.dat' ?Invalid command I want to redirect value of size to...

4. Shell Programming and Scripting

How to redirect 'crontab' output to a variable?

I'm trying to redirect the output of crontab to a variable named "crontab_status" as below: crontab_status=$(crontab -l) executing the script is not redirecting to the variable. Please help!

5. Shell Programming and Scripting

sql output into a variable

i have to do a check in my UNIX script to see whats saved in the database. depending on whats there will fork data to certain functions. However i do not know how to capture SQL output into a UNIX variable. Below is what i have tried, but i get an error: Error 3706 Failure 3706 Syntax error:...

6. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

Hi, I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use.. Please can any body help me in this regards Thanks & Regards Abdul Hafeez Shaik

7. Shell Programming and Scripting

redirect the grep output into the variable

i want to redirect the grep output into the variable but i am not able to get it i tried veri=`grep -i $1 "${logdir}"* | grep -i adding | grep -iv equation | tail -1 | cut -d ':' -f 1` vari=$(grep -i $1 "${logdir}"* | grep -i adding | grep -iv equation | tail -1 | cut -d ':' -f 1) BUT NOT...

8. Shell Programming and Scripting

awk redirect output to shell variable

I'm trying to redirect awk's output to a BASH variable. Currently the statement looks like this options=`awk '{ while (i < NF) { print $i; ++i } }' answer but for some reason that makes $options look like this: 1 2 3 4 1 2 3 Now, the input file 'answer' is taken from a dialog...

9. UNIX for Dummies Questions & Answers

Redirect Output In Variable

how make assign the output of the command (for example: grep "file" "string" ) in a variable ($name)? i thing how put the result of the command (grep , cut, find ecc) in a variable.. IT's Possible ??

10. UNIX for Dummies Questions & Answers

redirect command output to variable

Hi, I am looking for a way to redirect the result from a command into a variable. This is the scenario. Using the find command I will be getting multiple records/lines back. Here is the command I am using: find /�path�/ -name nohup.out -print This now is giving me the paths and file...

LEARN ABOUT CENTOS

radsqlrelay

RADSQLRELAY(8)						     FreeRADIUS helper program						    RADSQLRELAY(8)

NAME

       radsqlrelay - relay SQL queries to a central database server

SYNOPSIS

       radsqlrelay [-?]  [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path

DESCRIPTION

       radsqlrelay  tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
       base, even if the database has extended downtime.

       The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.

OPTIONS

       -?     Print usage help information.

       -d sql_driver
	      Driver to use: mysql, pg, oracle.

       -b database
	      Name of the database to use.

       -f file
	      Read password from file, instead of command line.

       -h host
	      Connect to host.

       -u user
	      User for login.

       -P port
	      Port number to use for connection.

       -p password
	      Password to use when connecting to server.

       -1     One-shot mode: push the file to database and exit.

       -x     Turn on debugging.

       file_path
	      The pathname of the SQL logfile to use.

NOTES

   Oracle driver
       The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:

       db.domain.tld =
	 (DESCRIPTION =
	   (ADDRESS_LIST =
	     (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
	   )
	   (CONNECT_DATA =
	     (SERVICE_NAME = <DB SID>)
	   )
	 )

SEE ALSO

       rlm_sql_log(5)

AUTHOR

       Nicolas Baradakis <nicolas.baradakis@cegetel.net>

								   19 June 2005 						    RADSQLRELAY(8)

Shell Programming and Scripting