while loop help Post: 302206249

Sponsored Content

Operating Systems Solaris while loop help Post 302206249 by prasanth_babu on Tuesday 17th of June 2008 10:13:02 AM

06-17-2008

Registered User

while loop help

Hi All,

can any one help me regarding the following sample code ..,
i just want to repeat the sql query 7 times as mentioned below ..,but it's getting failed.

selet*REF_DATE='03-MAY-08'*
select*REF_DATE='04-MAY-08'*
select REF_DATE='05-MAY-08'*
--
--
select*REF_DATE='10-MAY-08'*

SQL_FILE=sqlfile.sql
COUNTER=3

echo "SET NEWPAGE 0
SET SPACE 0
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TERMOUT OFF
SET FLUSH OFF
SET TRIMS ON
SET VERIFY OFF
SET MAYKUP HTML OFF SPOOL OFF
set linesize 250 " > $SQL_FILE

while [ $COUNTER <= 10 ]; do

echo "select 'TIMESTAMP, CALLING_NUMBER, CALLED_NUMBER, DURATION(MINUTES), TRUNKIN, TRUNKOUT, VIOLATIONFLAG,CIRCLE,POICODE,INOPERATOR,SERVICE,RATE' from dual;

SELECT RATED35||','||RATED36||','||RATED37||','||round((RATED23/60),2)||','||RATED17||','||RATED18||','||RATED54||','||RATED11||','||RATED46||','||RATED1||',
'||RATED2||','||trim(round(rated12,2)) FROM TRAFFIC WHERE REF_DATE='{$COUNTER}-MAY-08' AND FILE_ID IN ( (SELECT fileid FROM FILE_DISTR WHERE fileid >= 121423
8 AND fileid <= 1239493 AND SUBSTR ( SUBSTR (filename, INSTR (filename, '_', 1, 5) + 1),1,INSTR ( SUBSTR (filename,INSTR (filename, '_', 1, 5) + 1),'_',1,1)-
1) IN ( SELECT DISTINCT mod_code FROM file_recon WHERE ref_date = '31-may-08' AND POI_CODE IN ('DVGEWD','HBOCBT','HSNOCB','KLROCB','KLROCB','MCROCB','MDYOCB
','MRTAX','MRTAX','MYOCB','MYOCB','TMROCB','TMROCB','CENTAX','CENTAX','CENTAX','WMSOCB','WMSOCB','WM SOCB','WMSOCB','WMSOCB')))) and rated20 like '%USC%'; " >> $SQL_FILE

let COUNTER=COUNTER+1
done

echo "spool off
exit" >> $SQL_FILE

Last edited by prasanth_babu; 06-17-2008 at 11:33 AM..

prasanth_babu

View Public Profile for prasanth_babu

Find all posts by prasanth_babu

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is there a better way I could have run this loop. (For loop with two variables)

Sorry for such a dreadful title, but I'm not sure how to be more descriptive. I'm hoping some of the more gurutastic out there can take a look at a solution I came up with to a problem, and advice if there are better ways to have gone about it. To make a long story short around 20K pieces of...

2. Shell Programming and Scripting

Using variables created sequentially in a loop while still inside of the loop [bash]

I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends. As an example I've written a script called question (The fist command is to show what is the contents of the...

3. Shell Programming and Scripting

Null Handling in Until loop. . .loop won't stop

Hi Im running this script, which is supposed to find the max value build some tables and then stop running once all the tables are built. Thing is , it keeps assigning a null value to $h and then $g is null so it keep building tables i.e. testupdateNUL. How can I stop this? Here is what I have: ...

4. Shell Programming and Scripting

BASH loop inside a loop question

Hi all Sorry for the basic question, but i am writing a shell script to get around a slightly flaky binary that ships with one of our servers. This particular utility randomly generates the correct information and could work first time or may work on the 12th or 100th attempt etc !....

5. Shell Programming and Scripting

S# in a for loop - concatenate $(loop counter)

Hi, hope I am posting in the right section. My problem is that I have 2 or more arguments passed and I want to check if the arguments passed exists or not. The first argument should not exist and the remaining others should exist. example: ./shells.sh argument1 argument2 argument3 ...

6. Shell Programming and Scripting

My for loop decides to become an infinite loop?

Hi, I was debating if I should put this in the dummies or scripts section, I apologize in advance if I chose poorly. Fairly new to Unix and BASH scripting but I thought I made it fairly well given my limited understanding. However, the output indicates that it's looping and I'm ending up with a...

7. Shell Programming and Scripting

Array Variable being Assigned Values in Loop, But Gone when Loop Completes???

Hello All, Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....? I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping through a string containing some of these "Illegal Characters". Now...

8. Shell Programming and Scripting

Reset while loop to loop same file multiple times

Hi, I want to read file multiple times. Right now i am using while loop but that is not working. ex. While read line do while read line2 do echo stmt1 #processing some data based on data., done < file2.txt done < file1.txt # This will have 10...

9. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ...

10. Shell Programming and Scripting

For loop or while loop from a text file

Hi all, i developed a script to measure the uptime of a process in a Solaris 10/11 environments. All is well, but i came across a situation where there are multiple processes of the same name. Basically i have the following result file: beVWARS 13357 19592122 beVWARS 14329 19591910...

LEARN ABOUT LINUX

set_constraints

SET 
CONSTRAINTS(7)						   SQL Commands 						SET CONSTRAINTS(7)

NAME

       SET CONSTRAINTS - set constraint checking modes for the current transaction

SYNOPSIS

       SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }

DESCRIPTION

       SET  CONSTRAINTS  sets  the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of
       each statement. DEFERRED constraints are not checked until transaction commit. Each constraint has its own IMMEDIATE or DEFERRED mode.

       Upon creation, a constraint is given one of three characteristics: DEFERRABLE INITIALLY DEFERRED, DEFERRABLE INITIALLY  IMMEDIATE,  or  NOT
       DEFERRABLE.  The  third	class  is  always  IMMEDIATE and is not affected by the SET CONSTRAINTS command. The first two classes start every
       transaction in the indicated mode, but their behavior can be changed within a transaction by SET CONSTRAINTS.

       SET CONSTRAINTS with a list of constraint names changes the mode of just those constraints (which must  all  be	deferrable).  The  current
       schema  search  path  is  used  to find the first matching name if no schema name is specified. SET CONSTRAINTS ALL changes the mode of all
       deferrable constraints.

       When SET CONSTRAINTS changes the mode of a constraint from DEFERRED to IMMEDIATE, the new mode takes effect retroactively: any  outstanding
       data  modifications  that  would  have  been checked at the end of the transaction are instead checked during the execution of the SET CON-
       STRAINTS command.  If any such constraint is violated, the SET CONSTRAINTS fails (and does not change the constraint mode). Thus, SET  CON-
       STRAINTS can be used to force checking of constraints to occur at a specific point in a transaction.

       Currently,  only  foreign key constraints are affected by this setting. Check and unique constraints are always effectively not deferrable.
       Triggers that are declared as ``constraint triggers'' are also affected.

NOTES

       This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside of a  trans-
       action block (BEGIN/COMMIT pair), it will not appear to have any effect.

COMPATIBILITY

       This command complies with the behavior defined in the SQL standard, except for the limitation that, in PostgreSQL, it only applies to for-
       eign-key constraints.

SQL - Language Statements					    2010-05-14							SET CONSTRAINTS(7)