bash script & sql query Post: 302451644

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

I have a script that looks for all jobs that contain a particular calendar. Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this? I have tried: select job_name from job where run_calendar='1&15dom' select job_name from job...

2. Shell Programming and Scripting

script variable within a sql query

I created a script to read a csv file with four columns. The script also saved values of each col in a arry. In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file. select Num from tableName where Sec_Num in ('${isin}') /*isin is an arry...

3. Shell Programming and Scripting

Script executing sql query

Hello, I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query? Thanks

4. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance!

5. Shell Programming and Scripting

Oracle SQL Query & connect?

Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best...

6. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that...

7. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup...

8. Shell Programming and Scripting

SQL query within an awk script !!

Hello Experts, This sounds crazy, but one of my requirements is that if ID in 5th column in my input file (: separated) is not present in the oracle database table (say t_id) then this record should be skipped. I am using awk for all other requirements. So I was thinking if this requirement...

9. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way

10. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ...

LEARN ABOUT DEBIAN

rt-email-group-admin-4

rt-email-group-admin(8) 				     Request Tracker Reference					   rt-email-group-admin(8)

NAME

       rt-email-group-admin - Command line tool for administrating NotifyGroup actions

SYNOPSIS

	   rt-email-group-admin --list
	   rt-email-group-admin --create 'Notify foo team' --group Foo
	   rt-email-group-admin --create 'Notify foo team as comment' --comment --group Foo
	   rt-email-group-admin --create 'Notify group Foo and Bar' --group Foo --group Bar
	   rt-email-group-admin --create 'Notify user foo@bar.com' --user foo@bar.com
	   rt-email-group-admin --create 'Notify VIPs' --user vip1@bar.com
	   rt-email-group-admin --add 'Notify VIPs' --user vip2@bar.com --group vip1 --user vip3@foo.com
	   rt-email-group-admin --rename 'Notify VIPs' --newname 'Inform VIPs'
	   rt-email-group-admin --switch 'Notify VIPs'
	   rt-email-group-admin --delete 'Notify user foo@bar.com'

DESCRIPTION

       This script list, create, modify or delete scrip actions in the RT DB. Once you've created an action you can use it in a scrip.

       For example you can create the following action using this script:

	   rt-email-group-admin --create 'Notify developers' --group 'Development Team'

       Then you can add the followoing scrip to your Bugs queue:

	   Condition: On Create
	   Action:    Notify developers
	   Template:  Transaction
	   Stage:     TransactionCreate

       Your development team will be notified on every new ticket in the queue.

USAGE

       rt-email-group-admin --COMMAND ARGS

COMMANDS

   list
       Lists actions and its descriptions.

   create NAME [--comment] [--group GNAME] [--user UNAME]
       Creates new action with NAME and adds users and/or groups to its recipient list. Would be notify as comment if --comment specified.

   add NAME [--group GNAME] [--user UNAME]
       Adds groups and/or users to recipients of the action NAME.

   delete NAME
       Deletes action NAME if scrips doesn't use it.

   switch NAME
       Switch action NAME from notify as correspondence to comment and back.

   rename NAME --newname NEWNAME
       Renames action NAME to NEWNAME.

   NOTES
       If command has option --group or --user then you can use it more then once, if other is not specified.

AUTHOR

       Ruslan U. Zakirov <ruz@bestpractical.com>

SEE ALSO

       RT::Action::NotifyGroup, RT::Action::NotifyGroupAsComment

perl v5.14.2							    2013-05-22						   rt-email-group-admin(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

Discussion started by: Lindarella

2. Shell Programming and Scripting

script variable within a sql query

Discussion started by: Sherry_Run

3. Shell Programming and Scripting

Script executing sql query

Discussion started by: kingluke

4. Shell Programming and Scripting

query sql using shell script

Discussion started by: kingpeejay