09-21-2010
better you make spool of all qurey and the grep from that file and then put loop on each record of file .because each time connecting in sql takes cycles of db and take time :-)
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 ULTRIX
uuaids
uuaids(8c) uuaids(8c)
Name
uucompact, uumkspool, uurespool, uupoll - uucp utilities
Syntax
uucompact -ssystem
uumkspool system ...
uurespool [ -t# ]
uupoll system ...
Description
All of the commands are located in
The command compacts uucp system spool directories and associated subdirectories. If system is ALL, then all existing uucp system spool
directories are compacted. Otherwise, only the specified system spool directory is compacted. If no system is specified, is compacted.
If is stopped before it is finished, it can be restarted without reprocessing directories. The command continues processing where it left
off during it's previous instantiation.
The command makes a per system spool directory and associated subdirectories for each of the specified systems. For example, if system is
mk3 and if the local system name is penny, the following directories are created:
/usr/spool/uucp/sys/mk3
/usr/spool/uucp/sys/mk3/C.
/usr/spool/uucp/sys/mk3/X.
/usr/spool/uucp/sys/mk3/D.
/usr/spool/uucp/sys/mk3/D.penny
/usr/spool/uucp/sys/mk3/D.penny
The command moves files from old spool directories to new spool directories. Because the structure of the spool directories has changed
from older versions of it is necessary to respool old spooled files to new spool directories in at least two instances:
o When installing the current version of
o When creating a new system spool directory for each system.
In the latter case, it is necessary to move files from to the new spool directories. To ease this task, moves files that have been spooled
in one of 4 formats and respools them under the new spooling structure. The format is specified by the -t# option, where the number sign
(#) can be any one of the following:
o Original spool - All files are in
o Split spool - Contains the subdirectories
o Modified split spool - Contains all subdirectories listed in split spool, and
o Used when a new system directory has been created and spool files must be moved from the DEFAULT directory to the new system directory.
The command forces a connect attempt to the named systems even if recent attempts have failed, but not if the file prohibits the call. For
example, the file will prohibit the call if it is the wrong time of day. Thus, the should be monitored for messages about the connection.
Files
Spool directory
Logfile
See Also
mail(1), uucp(1c), uux(1c)
uuaids(8c)