|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
bash script & sql query
Post 302451648 by Scott on Tuesday 7th of September 2010 03:20:09 PM
09-07-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (3 Replies)
Discussion started by: Lindarella
3 Replies
2. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: Sherry_Run
1 Replies
3. Shell Programming and Scripting
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 (2 Replies)
Discussion started by: kingluke
2 Replies
4. Shell Programming and Scripting
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! (2 Replies)
Discussion started by: kingpeejay
2 Replies
5. Shell Programming and Scripting
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... (8 Replies)
Discussion started by: Dird
8 Replies
6. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: Kapom
2 Replies
7. Red Hat
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... (5 Replies)
Discussion started by: ramsavi
5 Replies
8. Shell Programming and Scripting
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... (4 Replies)
Discussion started by: juzz4fun
4 Replies
9. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
10. Shell Programming and Scripting
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 ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies
LEARN ABOUT DEBIAN
stapgraph
STAP(1) General Commands Manual STAP(1) NAME
stapgraph - systemtap grapher SYNOPSIS
stapgraph [ OPTIONS ] FILENAME [ ARGUMENTS ] stapgraph [ OPTIONS ] - [ ARGUMENTS ] stapgraph [ OPTIONS ] -e SCRIPT [ ARGUMENTS ] DESCRIPTION
The stapgraph program is a simple frontend to stap that produces graphs from the output of stap scripts. This manual corresponds to version 1.7. OPTIONS
stapgraph accepts all options accepted by stap. They are passed through to the stap process running the script or probe points. USER INTERFACE
The script that produces results can be started from a dialog within the program, in addition to being launched using the program's command line arguments. This dialog allows arguments to be passed to stap and to the script. When running, a mouse left click on a graph pauses the display of data, even though it is still collected by the program. Dragging the mouse scrolls the graph backwards and forwards in time; clicking the displayed pause button restarts the display of new data. The scroll wheel can be used to zoom in and out on the graph. SCRIPT OUTPUT SYNTAX
Scripts can output Comma Separated Values (CSV) which will be interpreted by stapgraph. The first value is the X coordinate of the graph, usually a time value. stapgraph assumes that this value is constantly increasing. A different syntax allows the script to specify many details of the graph's appearance. %DataSet: DATA-SET-NAME SCALE COLOR GRAPHSTYLE The data set name identifies a data set that will be emitted by the script. "SCALE" is the overall vertical scale of the graph for this data set. "COLOR" is a red-green-blue hex color. "GRAPHSTYLE" is one of bar - a traditional bar graph dot - plotted points discreet - An event style timeline that records that an event happened at a certain time. %Title: TITLE A title for the whole graph. %XAxisTitle: TITLE The legend for the X axis %YAxisTitle: TITLE The legend for the Y axis. %YMax: MAX VALUE The maximum value displayed on the graph. GRAPH DATA
DATA SET TIME VALUE Each data point that is to be plotted is tagged with the data set name, followed by the time and value of the point. SEE ALSO
stap(3stap), staprun(3stap), BUGS
Use the Bugzilla link off of the project web page or our mailing list. http://sourceware.org/systemtap/,<systemtap@sourceware.org>. Red Hat 2013-05-14 STAP(1)