UNIX variable to SQL statement Post: 302749127

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sql query variable not exactly unix

I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help. I can run sql queries in scripts against my informix db using: dbaccess mydb myquery.sql >> sql.output I need to write my script to select based on todays date. Its very...

2. Shell Programming and Scripting

Executing a Oracle SQL statement in a UNIX script

Hi All, I need to select one column from a table based upon the passed in parameter. I tried this: sqlplus -silent $MISP_USER << EOF set feedback off; set verify off; set sqlprompt "" SELECT mail_flag FROM dailyjobs WHERE job_name = '$1'; exit 0 EOF exit...

3. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

hi all, i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code. sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE whenever sqlerror exit set serveroutput on size 1000000 declare l_rc ...

4. Shell Programming and Scripting

Using Unix Variable in a PL/SQL block

Hi, I have a unix varaible called as account which hold values which i want to use in a PL/SQL block in a shell script. This variable value is being used in multiple places in the PL/SQL block and i get an erroe whenenevr is use this varaible with $prompt. Help Urgently

5. Shell Programming and Scripting

I want to get the Unix variable value in the sql stmt

Hi All I have a requirement where in I am stuck. There is a shell script that is being developed by me. It consist of the sql stmt also. I need to export a variable called HOMEPAGE with a value say www.abc.com. and then use this $HOMEPAGE variable in the sql stmt. My ultimate aim is to fetch all...

6. Shell Programming and Scripting

Unix shell command output to a sql statement

Can i do this Say one command sed 's/:*/ /g' $summf is returning C1234 C2345 C3434 some no of rows, now this ouput i have to insert it into a DB table how do i do this??

7. UNIX for Dummies Questions & Answers

unix script with SQL statement problem

Hello, I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused: echo Input file list to check: read filelist for file in 'cat $filelist.txt' do echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >>...

8. UNIX for Dummies Questions & Answers

SQL statement is not work on unix script

Hi, I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? :mad: echo " Column filename format a30"|sqlplus4 echo Input file list to check: read filelist for file in `cat $filelist.txt` do...

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

10. Shell Programming and Scripting

UNIX Sqlplus - Capture the sql statement about to run and execution status

Greetings Experts, I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to execute the contents in the file (there are around 300 view creation and grant statements) in Oracle and...

LEARN ABOUT DEBIAN

ibam

IBAM(1) 																   IBAM(1)

NAME

       IBAM - the Intelligent Battery Monitor

SYNOPSIS

       ibam [options]

DESCRIPTION

       IBAM-0.3, the Intelligent Battery Monitor
       (C) 2001-2004 Sebastian Ritterbusch

OPTIONS

       -h, --help
	      displays help message

       -v, --version
	      displays software version

       -b, --bios
	      show bios apm guesses

       -s, --seconds
	      displays times in seconds

       -c, --correctseconds
	      displays changes in seconds

       -r, --readonly
	      no files will be updated

       -a, --all
	      show ALL information

       --battery
	      show battery time

       --batteryadaptive
	      show adaptive battery time

       --batterybios
	      show bios battery time guess

       --percentbattery
	      show battery percentage

       --percentbios
	      show bios percentage

       --charge
	      show charge time

       --chargeadaptive
	      show adaptive charge time

       --percentcharge
	      show charge percentage

       --totalbattery
	      show total battery time

       --totalbatteryadaptive show adaptive total battery

       --totalcharge
	      show total charge time

       --totalchargeadaptive
	      show adaptive total charge

       --plot[=profiles]
	      use gnuplot to plot battery and charge graphs and plot the last <profiles> additional profiles

       --plotderivations
	      same as above plus standard deviations

       --plotdeviations
	      same as above plus standard deviations

       --import
	      import V0.1 data from current directory

       --profile
	      enable additional yet unused profiling

       --noprofile
	      disable additional profiling

       --credits
	      to everyone contributing to ibam

AUTHOR

       This manual page was written by Martin Wuertele <martin@wuertele.net> for the Debian GNU/Linux system (but may be used by others).

									 2								   IBAM(1)