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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT REDHAT
adsl-connect
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)