Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Run the Script from any stage by updating data from Oracle Table.
Top Forums Shell Programming and Scripting Run the Script from any stage by updating data from Oracle Table. Post 302990414 by rbatte1 on Thursday 26th of January 2017 06:56:24 AM
Old 01-26-2017
You would (re)start by running the script like this:-
Code:
$ my_script             # Run from the top, i.e. default is step 1
$ my_script 6           # Run from step 6 (or next step if 6 is not defined)

The default setting line means that if $step is not set then it to 1, so if it is already set, it retains that value. Write a little test script to try it out.

You could even have a step zero defined that is never run unless you force it.

Overall though, I would strongly suggest that you split it up and have one script for one task, then use a proper scheduler.




I hope that this helps,
Robin
Last edited by rbatte1; 01-26-2017 at 07:56 AM.. Reason: Closing good wishes
This User Gave Thanks to rbatte1 For This Post:
kiran1992
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

updating a column in oracle table using shell script

Hi friends, i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql STATUS is the variable declared in the .profile =============================== if sqlplus <<END... (3 Replies)
Discussion started by: sveera
3 Replies

2. Shell Programming and Scripting

script for updating table using file(

Hi, Data file path (.txt) Control file(.ctl) I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me... (1 Reply)
Discussion started by: unihp1
1 Replies

3. Shell Programming and Scripting

To load data from variable to oracle table

Hi all, How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value... Can someone help me how to do it? I have searched, but not able to get answer. i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies

4. Shell Programming and Scripting

To load data from variable to oracle table ....???

Hi all, How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value... Can someone help me how to do it? I have searched, but not able to get answer. i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

5. Shell Programming and Scripting

load a data from text file into a oracle table

Hi all, I have a data like, 0,R001,2,D this wants to be loaded into a oracle database table. Pl let me know how this has to be done. Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies

6. Shell Programming and Scripting

Script not reading Data from oracle table properly

Hi, I have a case where i am connecting to the oracle DB and reading a column value.... Script is in production...it was running fine,,,but suddenly now some times its started giving pain.... Script runs dailly....but sometimes its reading data from Oracle DB and sometimes its not rading the... (2 Replies)
Discussion started by: Sagarddd
2 Replies

7. Shell Programming and Scripting

select data from oracle table and save the output as csv file

Hi I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data. I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Discussion started by: rdhanek
2 Replies

8. Shell Programming and Scripting

sending mail using Mailx with data from oracle table

Hi, i need to send emails to the mail ids i receive using the sql query . SELECT L.ALARM_DEF,L.CRITERIA,L.DISTANCE_METRE,L.EMAIL,L.LAC_ID,L.LAST_CHECK,L.RANGE, L.RESOURCE_MSISDN,LM.ADDRESS,LM.NAME FROM LANDMARK_ALARM_CONF l, LANDMARK lm WHERE L.LANDMARK_ID=LM.LANDMARK_ID AND... (0 Replies)
Discussion started by: aemunathan
0 Replies

9. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

10. Shell Programming and Scripting

I want a script to view the complete log information of data stage job from UNIX IBM AIX.

Hi, I am working on data stage 8.7 version and I want a script a to view the all log information of the data stage job from UNIX environment. Can you please help me out by give the script. Thanks in advance... (7 Replies)
Discussion started by: victory
7 Replies

LEARN ABOUT DEBIAN

lqr_carver_get_enl_step

LQR_CARVER_GET_ENL_STEP(3)				     LqR library API reference					LQR_CARVER_GET_ENL_STEP(3)

NAME

       lqr_carver_get_enl_step - get the enlargement step of a LqrCarver object

SYNOPSIS

       #include <lqr.h>

       gfloat lqr_carver_get_enl_step(LqrCarver* carver);

DESCRIPTION

       The function lqr_carver_get_enl_step returns the enlargement step of the LqrCarver object pointed to by carver, i.e. the maximum
       enlargement allowed in a single step for that carver, expressed as the ratio with respect to its reference width (for horizontal
       rescalings) or height (for vertical rescalings). The returned value is strictly greater than 1 and less than 2.

SEE ALSO

       lqr_carver_get_width(3), lqr_carver_get_height(3), lqr_carver_get_ref_width(3), lqr_carver_get_ref_height(3), lqr_carver_get_channels(3),
       lqr_carver_get_col_depth(3), lqr_carver_set_enl_step(3), lqr_carver_resize(3), lqr_carver_get_orientation(3)

COPYRIGHT

       Copyright (C) 2007-2009 Carlo Baldassi

LqR library 0.4.1 API (3:1:3)					    10 Maj 2009 					LQR_CARVER_GET_ENL_STEP(3)
All times are GMT -4. The time now is 05:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy