|
|
Sponsored Content
Operating Systems
AIX
Controling a statement to execute
Post 302244509 by zaxxon on Wednesday 8th of October 2008 04:33:48 AM
10-08-2008
Note: This is not AIX specific, should have been posted in the Shell Scripting subboard; recall this next time please 
I am not sure how you check if your job was ok or not - I guess you will have to parse your error.txt... ?
So just react to this and not simply erase your file in the end, wether it was succesful or not, as you do it atm.
Not sure if your runEod.sh produces an exit code you can use to decide what to do next.
Since you have this script and probably wrote it yourself, I guess you can easily adjust to your efforts?
Quote:
The problem is that I am clering the file which contains the completed job entry at the last.
And say if a job fails it goes and clear the file.
What i need is that only if the entire file is sucessfully executed then only I should clear the file and if the scripts fails in between it should skip this step.
And say if a job fails it goes and clear the file.
What i need is that only if the entire file is sucessfully executed then only I should clear the file and if the scripts fails in between it should skip this step.
So just react to this and not simply erase your file in the end, wether it was succesful or not, as you do it atm.
Not sure if your runEod.sh produces an exit code you can use to decide what to do next.
Since you have this script and probably wrote it yourself, I guess you can easily adjust to your efforts?
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to have an if statement in a script to run if there are certain processes running. Easiest way I can see to do this is to run a ps and grep the results based on what I am looking for:
$ ps -ef | grep wtrs
---
webtrend 5046 1 0 May 12 ? 0:28 /webtrends/versions/6.1/wtrs_ui... (6 Replies)
Discussion started by: LordJezo
6 Replies
2. Shell Programming and Scripting
Hi
I have a text file , contents are
Line1:field1,field2,field3,field4,field5,field6.......field20
Line2:field1,field2,field3,field4,field5,field6.......field20
Line3:field1,field2,field3,field4,field5,field6.......field20
....and so on...
I want to read this file and insert the data into... (4 Replies)
Discussion started by: Amruta Pitkar
4 Replies
3. Shell Programming and Scripting
ls -ld /path/to/dir1 path/to/dir2 | awk '{print $8}'
how to execute above script in IF ELSE Statement.
Pls iam new to Unix (1 Reply)
Discussion started by: laknar
1 Replies
4. Shell Programming and Scripting
I have written a script for converting an IP address into its corresponding AS number in PHP. But based on the timing analysis, I've observed that it takes a long time to process large number of entries. So I need to do something directly in unix. What method would one suggest for this purpose?
... (8 Replies)
Discussion started by: Legend986
8 Replies
5. Shell Programming and Scripting
Hi All,
I am using Unix ksh script.
I need to insert values to a table using the o/p from a slelect statement.
Can anybody Help!
My script looks like tihs.
---`sqlplus -s username/password@SID << EOF
set heading off
set feedback off
set pages 0
insert into ${TB_NAME}_D... (2 Replies)
Discussion started by: nkosaraju
2 Replies
6. Shell Programming and Scripting
Hello All,
I am new to shell scripting. I am working on Solaris O/S, bash script and sybase programming.
I want to loop through multiple values in an array and for each value, I
want to select a row from the database.
following is the code written for it.
output="loop.csv" ... (8 Replies)
Discussion started by: arundhati_s
8 Replies
7. Shell Programming and Scripting
I want to control the speed of execution of a script, There are 1000 lines in script, i want 100 lines to be executed in 10 seconds and from 11th second execution from 101 line should start, again so on. Please help me in creating the script.
Thanks,
cmaniar (1 Reply)
Discussion started by: cmaniar
1 Replies
8. Shell Programming and Scripting
Hi friends,
I would like to get some help on the following requirement. I have a SQL file with following things,
select 1 from dual;
select user from dual;
select sysdate
from
dual;
BEGIN
PL/SQL Code
END;
/
This file will be saved as sql file. When I run my expected shell script,... (1 Reply)
Discussion started by: ssnair
1 Replies
9. Shell Programming and Scripting
Hi,
I am new to Shell Scripting, and I need to create nicknames for 600 tables in db2. I have the file names in a text file and i have to pass these table names to a shell script create nicknames in db2. Can some one please help me in this regard. (1 Reply)
Discussion started by: kamalanaatha
1 Replies
10. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
LEARN ABOUT CENTOS
execute
EXECUTE(7) PostgreSQL 9.2.7 Documentation EXECUTE(7) NAME
EXECUTE - execute a prepared statement SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ] DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the prepared statement must have been created by a PREPARE statement executed earlier in the current session. If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE statement, or else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of their parameters; the name of a prepared statement must be unique within a database session. For more information on the creation and usage of prepared statements, see PREPARE(7). PARAMETERS
name The name of the prepared statement to execute. parameter The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible with the data type of this parameter, as was determined when the prepared statement was created. OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE. EXAMPLES
Examples are given in the EXAMPLES section of the PREPARE(7) documentation. COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a somewhat different syntax. SEE ALSO
DEALLOCATE(7), PREPARE(7) PostgreSQL 9.2.7 2014-02-17 EXECUTE(7)