01-30-2017
This is to make my requirement more clear
For Example:
Let's say I have 5 queries in my Script
- create table abc
- create table xyz
- create table ghf
- touch kiran.ksh
- rm das.sh
Now, in the beginning of the Script, I will read an input from oracle table, which gives the SeQ_NO to execute.
Now when I get the seq number, I want to say in the Script to execute all the statements starting from the seq_no obtained.
(if the Seq_no obtained is 2, I should say in the Script to start from statement 3. If the input from the Table is NULL, then the Script should run from the beginning.)
My main requirement is that, I want to write command/ piece of code in the Script, which says start from statement number(based on what input we get from table) and execute till the end.
Please help me with your thoughts.
Last edited by rbatte1; 01-31-2017 at 12:47 PM..
Reason: Converted textual list to formatted numbered list and corrected spellings
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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)