06-27-2002
Check query execution to go further
Can any one help with script (Korn) to do following ?
I have 3 tasks to do in a shell.
Task (1) is executing query which unloads the result into file XYZ.
Before I start Task (2) which is java program and depends on
file XYZ, I need to make sure that Task (1) is completed successfully.
Before I start Task (3) which has to do with emailing file XYZ, I need to make sure Task (1) & (2) run successfully.
Questions:
[1] How can I check whether my query run successfully or not ?
[2] How can I check that my java program runs successfully and created another file which it supposed to?
[3] How can I check whether email has been sent successfully or not ?
Quick response will be great help !!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
2. Shell Programming and Scripting
I have an expect script that interrogates several hundred unix servers for both access and directories therein using "ssh user@host ls -l /path". The combination of host/path are unique but the host may be interrogated multiple times if there are multiple paths to test.
The expect script is run... (2 Replies)
Discussion started by: twk
2 Replies
3. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
4. UNIX for Advanced & Expert Users
Advance Thanks.
(1) I would like to know any unix/Linux command to check EOF char in a file.
(2) Or Any way I can check a file has been reached completely at machine B from machine A. Note that machine A ftp/scp the file to machine B at unknown time. (5 Replies)
Discussion started by: alexalex1
5 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
Hi ,
I have a scripts which run at every 1 min and do some job.
this scripts look for the file in the directory and move in the other directory.
I want to write a line which forst check if the *.LOG file exist in the directory
if *.LOG exist
then
do for i in *.LOG
load
... (7 Replies)
Discussion started by: guddu_12
7 Replies
7. Shell Programming and Scripting
Hi Experts,
I am checking how to get day in Perl.
If it is “Monday” I need to process…below is the pseudo code.
Can you please prove the code for below condition.
if (today=="Monday" )
{
while (current_time LESS THAN 9:01 AM)
... (1 Reply)
Discussion started by: ajaypatil_am
1 Replies
8. AIX
Hello,
I have 3 AIX 6.1 machines running INFORMIX 11.7 database engine.
One of these servers is the database server and the other 2 servers are connecting to it.
I am doing a test to determine the time of query execution between these servers and i see that in specific times one of these... (12 Replies)
Discussion started by: omonoiatis9
12 Replies
9. Programming
Dear team
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies
10. UNIX for Beginners Questions & Answers
I have a shell script which is used to get the input and have another shell script (a sub script) at the end of this shell script which is used to upload the inputs in the Oracle database. I can check the execution status of the parent script using sh -x script.sh. but this command doesn't show the... (1 Reply)
Discussion started by: srilaxman
1 Replies
LEARN ABOUT SUSE
task::weaken
Task::Weaken(3) User Contributed Perl Documentation Task::Weaken(3)
NAME
Task::Weaken - Ensure that a platform has weaken support
DESCRIPTION
One recurring problem in modules that use Scalar::Util's "weaken" function is that it is not present in the pure-perl variant.
While this isn't necesarily always a problem in a straight CPAN-based Perl environment, some operating system distributions only include
the pure-Perl versions, don't include the XS version, and so weaken is then "missing" from the platform, despite passing a dependency on
Scalar::Util successfully.
Most notably this is RedHat Linux at time of writing, but other come and go and do the same thing, hence "recurring problem".
The normal solution is to manually write tests in each distribution to ensure that "weaken" is available.
This restores the functionality testing to a dependency you do once in your Makefile.PL, rather than something you have to write extra
tests for each time you write a module.
It should also help make the package auto-generators for the various operating systems play more nicely, because it introduces a dependency
that they have to have a proper weaken in order to work.
How this Task works
Part of the problem seems to stem from the fact that some distributions continue to include modules even if they fail some of their tests.
To get around that for this module, it will do a few dirty tricks.
If Scalar::Util is not available at all, it will issue a normal dependency on the module. However, if Scalar::Util is relatively new ( it
is >= 1.19 ) and the module does not have weaken, the install will bail out altogether with a long error encouraging the user to seek
support from their vendor (this problem happens most often in vendor-packaged Perl versions).
This distribution also contains tests to ensure that weaken is available using more normal methods.
So if your module uses "weaken", you can just add the following to your Module::Install-based Makefile.PL (or equivalent).
requires 'Task::Weaken' => 0;
AUTHOR
Adam Kennedy <adamk@cpan.org>, <http://ali.as/>
SEE ALSO
Task, Scalar::Util, <http://ali.as/>
COPYRIGHT
Copyright 2006 - 2009 Adam Kennedy.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
perl v5.12.1 2009-06-12 Task::Weaken(3)