Sponsored Content
Top Forums Shell Programming and Scripting How to use LOOP in Unix Script? Post 302454989 by ustechie on Monday 20th of September 2010 01:13:57 PM
Old 09-20-2010
How to use LOOP in Unix Script?

Hi Unix Gurus,

I need your help in below mentioned problem:

$input_file -----> This file has number of SELECT COUNT(*) statements. Ther could be 1 statement or more than 1, it is not fixed.

[B][U]I need to implement the following logic.....

for i in `cat $input_file`
do
calculate count of SELECT COUNT(*) statement
(if possible, I need to store the count of each statement in a variable)
if count >= 200000
then
exit processing
fi
done



Thanks in advance !!!

Last edited by ustechie; 09-20-2010 at 02:19 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Please help with UNIX while loop...

Hi all. I am trying to execute a while loop that reads a log file containing a file listing, and it compares file sizes, etc. But I am getting an error that makes it seem like it is not reading the log file line by line. When I do a 'more' on the log file, it doesn't appear to be wrapped... ... (1 Reply)
Discussion started by: gerard1
1 Replies

2. Shell Programming and Scripting

for loop in unix

hi, can any one suggest why the program 2 is not working. only difference is for ab in *.txt for ab in a_DATA.txt b_DATA.txt c_DATA.txt ------------------------------------ Program :1 (working fine) #!/bin/ksh for ab in a_DATA.txt b_DATA.txt c_DATA.txt suf="_" echo "old->... (1 Reply)
Discussion started by: deep_kol
1 Replies

3. Shell Programming and Scripting

Unix Shell Script to loop over Directory and send Filesname as parameters

Hi there I'm new to UNIX scripting; I’m stuck with the following I have an Oracle SQL script that takes three parameters 1- File Name 2- File Path 3- File creation date Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need... (3 Replies)
Discussion started by: windjashi
3 Replies

4. Shell Programming and Scripting

for loop in Unix

This is the content of a file work.log 1 TGBUS I-US 0;15;83 i did this for i in `cat work.log` do echo $i done I wanted the out put to be 1 TGBUS I-US 0;15;83 But the output appears as 1 TGBUS I-US 0;15;83 For Loop treats space as a delimiter. Can i overrride this space as... (10 Replies)
Discussion started by: kinny
10 Replies

5. Shell Programming and Scripting

How to loop use while loop in csh script?

Hi all, i got 2 text file. file.txt value.txt i want use C shell script to write out while both of the file got different limit....how i going to write it in 1 while loop? (4 Replies)
Discussion started by: proghack
4 Replies

6. UNIX for Dummies Questions & Answers

Help with unix for loop

Hi, I have a command that I want to translate to Unix. I mostly work with Windows and because of that I am stuck on a part. What I cannot find on the internet is skipping the first lines in a for loop and using a certain word/token. (I know how to do a normal loop with output) I need to skip... (1 Reply)
Discussion started by: flappy
1 Replies

7. Shell Programming and Scripting

foreach loop in unix script

Hi all, I have a script which searches for all sql files in the current directory and replaces all sql files with an underscore with a dash. The next part I need to do is record the number of changes made (underscore to dash) and display this value (e.g.2). This is what I have so far; find /... (17 Replies)
Discussion started by: shawi
17 Replies

8. Shell Programming and Scripting

UNIX shell script - cut specified line and perform loop

Guys, I have a requirement as below. consider,if i use df command, its getting the below output. file system kbytes used avail %used Mounted on /dev/sample/ 45765 40000 5765 50% / /dev/filesys/ 30000 20000 1000 80% /u .... .... Now i wanted to cut the /u... (11 Replies)
Discussion started by: AraR87
11 Replies

9. Shell Programming and Scripting

UNIX for loop

Guys, Please help me on the below.. sample.prm /u/test/: mail=123@gmail.com purgedays=30 zipdays=7 purgefile=log.gz zipfile=log /u/test/: mail=123@gmail.com purgedays=30 purgefile=txt.gz zipfile=txt zipdays=7 (2 Replies)
Discussion started by: AraR87
2 Replies

10. Shell Programming and Scripting

UNIX shell script for loop issue

Guys, Please help on the below. sample.prm /u/test/: mail=123@gmail.com purgedays=30 zipdays=7 purgefile=log.gz zipfile=log /u/test/: mail=123@gmail.com purgedays=30 purgefile=txt.gz zipfile=txt zipdays=7 (1 Reply)
Discussion started by: AraR87
1 Replies
ADSL-CONNECT(8) 					      System Manager's Manual						   ADSL-CONNECT(8)

NAME
adsl-connect - Shell script to manage a PPPoE link SYNOPSIS
adsl-connect [config_file] adsl-connect interface user [config_file] DESCRIPTION
adsl-connect is a shell script which manages an ADSL connection using the Roaring Penguin user-space PPPoE client. If you omit con- fig_file, the default file /etc/sysconfig/network-scripts/ifcfg-ppp0 is used. If you supply interface and user, then they override the Ethernet interface and user-name settings in the configuration file. Note that normally, you should not invoke adsl-connect directly. Instead, use adsl-start to bring up the ADSL connection. adsl-connect first reads a configuration file. It then brings up a PPPoE connection. If the connection ever drops, a message is logged to syslog, and adsl-connect re-establishes the connection. In addition, each time the connection is dropped or cannot be established, adsl- connect executes the script /etc/ppp/adsl-lost if it exists and is executable. The shell script adsl-stop causes adsl-connect to break out of its loop, bring the connection down, and exit. TECHNICAL DETAILS
adsl-connect uses the following shell variables from the configuration file: ETH The Ethernet interface connected to the ADSL modem (for example, eth0). USER The ADSL user-id (for example, b1xxnxnx@sympatico.ca). PIDFILE A file in which to write the process-ID of the adsl-connect process (for example, /var/run/pppoe.pid). Two additional files ($PID- FILE.pppd and $PIDFILE.pppoe) hold the process-ID's of the pppd and pppoe processes, respectively. By using different configuration files with different PIDFILE settings, you can manage multiple PPPoE connections. Just specify the con- figuration file as an argument to adsl-start and adsl-stop. AUTHOR
adsl-connect was written by David F. Skoll <dfs@roaringpenguin.com>. The pppoe home page is http://www.roaringpenguin.com/pppoe/. SEE ALSO
pppoe(8), adsl-start(8), adsl-stop(8), pppd(8), pppoe.conf(5), adsl-setup(8), adsl-status(8), pppoe-sniff(8), pppoe-server(8), pppoe- relay(8) 4th Berkeley Distribution 21 February 2000 ADSL-CONNECT(8)
All times are GMT -4. The time now is 04:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy