How to run multiple Queries in a ksh Script
I have a KSH script that has one SQL Query and generates and emails output of the query in HTML format. I want to change the script so that it has three SQL queries and the last query generates and emails the HTML output page of just that query.
So far I have:
•
Query 1 - Creates a table by performing a select into into
a table in tempdb
•
Query 2 - Creates a table by performing a select into into a
table in tempdb
•
Query 3 - Performs a join between table 1 and table 2 and creates table 3 Then table 3 is queried and and the result is placed in a HTML file and emailed
I know the code below works great In a script I have but this is only one query. I want to use 3 Queries and the result of the third query
is used to generate the html report.
Hi,
I'm developing a system which requires me to run a ksh script from within a cgi script. What sort of syntax will I need to do this, I'm sure it's simple but can't find out how anywhere!
Thanks. (2 Replies)
Hi guys,
i know how to run a single query using mysql embedded in a shell script as follows:
`mysql -umyuser -pmypass --host myhost database<<SQL
${query};
quit
SQL`
However, how would i be able to run several queries within the same connection?
The reason for this is i am creating... (3 Replies)
Hi
I am new to this Scripting process and would like to know How can i write a ksh script that will call other ksh scripts and write the output to a file and/or email.
For example
-------
Script ABC
-------
a.ksh
b.ksh
c.ksh
I need to call all three scripts execute them and... (2 Replies)
hi i have a script called test.sh. the content is ls >> crontest.txt.
if i run manually it's giving output.but if i scheduled in crontab it's not giving output.
crontab entry:
02 * * * * /sms5/SMSHOME/eds_sh/test.sh >> /sms5/SMSHOME/eds_sh/testfile/logfile 2>&1
I am using ksh.is there... (2 Replies)
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers (6 Replies)
i ran the below in ksh...
nohup <script> &
it is runnign in background.
now how do i see if the above command is success...
i also need to bring the command to foreground and view the run details.
pls advise how to do that... (1 Reply)
Hi programmers, say I have 4 files : file1.py,file2.py,file3.py,file4.py
How do I, on a korn shell, create one file, run_all, that is one file that sequentially calls file1-file4, but only so if they complete w/o errors?
Something like:
#!/usr/bin/ksh
file1.py
/*......????*/
... (7 Replies)
how to store the count of queries in variables inside a filein shell script
my output :
filename
-------
variable1=result from 1st query
variable2=result from 2nd query
.
.
.
. (3 Replies)
How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused: (1 Reply)
Discussion started by: 24ajay
1 Replies
LEARN ABOUT DEBIAN
plucene::search::query
Plucene::Search::Query(3pm) User Contributed Perl Documentation Plucene::Search::Query(3pm)NAME
Plucene::Search::Query - base class for queries
SYNOPSIS
my $s_query = Plucene::Search::Query::Subclass->new({
boost => $boost_factor});
my $scorer = $s_query->scorer($query, $searcher, $reader);
DESCRIPTION
This is an abstract base class for queries.
A query is a specification of the content an properties of the desired documents. Every search is done by matching a query against the
document index and locating the ones that match the query.
The simplest query specifies a single term (or word) that is to be matched against a single field (e.g. 'author') of each of the documents
in the index. This kind of query matches any document that contains the term in the specified field.
A more complex queries may contain nested queries with 'and', 'or', 'not' or 'phrase' relations. Queries may also contains specification of
which document fields to match against the various parts of the query (.e.g. 'authors' and 'title') and hints that may effects the ranking
of the matched documents ('boost' factor).
METHODS
new
my $s_query = Plucene::Search::Query::Subclass->new({
boost => $boost_factor});
boost
Get / set this attribute
scorer
my $scorer = $s_query->scorer
(Plucene::Search::Query $query, $searcher, $reader);
prepare
Does nothing
sum_squared_weights / normalize / _scorer
These must be defined in a subclass
perl v5.12.4 2011-08-14 Plucene::Search::Query(3pm)