11-20-2009
How to Pull out multiple files from DB table and redirect all those files to a differetn directory?
Hi everyone!!
I have a database table, which has file_name as one of its fields.
Example:
File_ID File_Name Directory Size
0001 UNO_1232 /apps/opt 234
0002 UNO_1234 /apps/opt 788
0003 UNO_1235 /apps/opt 897
0004 UNO_1236 /apps/opt 568
I have to extract all the files whose size is greater than 500 and send all those files to a different directory /apps/opt/new
How do I loop through the table and send all those file_names, which match the size criteria to a different directory?
Thanks in advance..
Please do help me out, as this is very urgent for me.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am new to shell scripting and have a question. I would like to redirect the output of a command to multiple files, each file holding the exact same copy. From what I read from the bash manpage and from some searching it seems it cannot be done within the shell except setting up a loop. Is... (3 Replies)
Discussion started by: cbkihong
3 Replies
2. UNIX for Dummies Questions & Answers
I have a program that is reading strings into a vector from a file. Currently I am using this command:
a.out < file1
The program runs and prints the contents of the vector to the screen, like its supposed to. The problem is that it needs to read in 3 files to fill the vector. Is there anyway... (4 Replies)
Discussion started by: Matrix_Prime
4 Replies
3. Shell Programming and Scripting
i have some 2000 files and i want to redirect it to a dir
after i give the command
find . -mtime -15 -print
it gives some 2000 files
file1.DAT
file2.DAT
:
:
:
file2000.DAT
------------------------------------------------------------------------how to redirect all these 2000 files... (2 Replies)
Discussion started by: ali560045
2 Replies
4. Shell Programming and Scripting
How to redirect the output to multiple files without putting on console
I tried tee but it writes to STDOUT , which I do not want.
Test.sh
------------------
#!/bin/ksh
echo "Hello " tee -a file1 file2
----------------------------
$>./Test.sh
$>
Expected output:
-------------------... (2 Replies)
Discussion started by: prashant43
2 Replies
5. Shell Programming and Scripting
I have a program that runs like "cat f1 - f2 -", I need to write shell script to run the program whose standard input will be redirected from 2 files. I spend a whole day on it, but didn't figure out. Can someone help me out? Thanks! (8 Replies)
Discussion started by: microstarwwx
8 Replies
6. UNIX for Dummies Questions & Answers
Hi,
i know how to
a) redirect stdout and stderr to one file,
b) and write to two files concurrently with same output using tee command
Now, i want to do both the above together.
I have a script and it should write both stdout and stderr in one file and also write the same content to... (8 Replies)
Discussion started by: ysrini
8 Replies
7. Shell Programming and Scripting
Hi,
I am new to script and I want find one string from multiple files in diff directories and put that out put to new file.
Like I have A,B & C directories and each has multiple files but one file is unic in all the directories like COMM.txt
Now I want write script to find the string... (8 Replies)
Discussion started by: Mahessh123
8 Replies
8. UNIX for Dummies Questions & Answers
Hi ,
I have searched through the forum but not able to find out any help :(
i have a directory having lot of files which contains sql statemtns
eg : file 1 contains
select from table_name1 where .....................
select from
table_name2 where ..........
select
from ... (3 Replies)
Discussion started by: Trendz
3 Replies
9. Shell Programming and Scripting
Hi Everyone,
Im currently using the below code to pull data from a large CSV file and put it into smaller files with just the data associated with the number that I "grep".
grep 'M053' test.csv > test053.csv
Is there a way that I can use grep to run through my file like the example below... (6 Replies)
Discussion started by: TheStruggle
6 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I need to load data from two files to a single table.
My requirement is that I get two files in which a few column data are manadatory.
These files are identified based on the file name.
For example, I have two files ABCFile and BCDFile. ABCFile has mandatory data in column 3 and 4... (0 Replies)
Discussion started by: reshma15193
0 Replies
LEARN ABOUT OPENSOLARIS
soladdapp
soladdapp(1M) System Administration Commands soladdapp(1M)
NAME
soladdapp - add an application to the Solstice application registry
SYNOPSIS
/usr/snadm/bin/soladdapp [-r registry] -n name -i icon -e executable
[args]
DESCRIPTION
soladdapp adds an application to the Solstice application registry. After it is added, the application is displayed in the Solstice
Launcher main window (see solstice(1M)).
OPTIONS
-r registry Define the full path name of the Solstice registry file.
-n name Define the name of the tool to be registered.
-i icon Define the full path name of the tool icon.
-e executable Define the full path name of the tool.
args Specify any arguments to use with the tool.
When executed without options, soladdapp uses /opt/SUNWadm/etc/.solstice_registry (the default registry path).
RETURN VALUES
0 on success
1 on failure
2 if the registry is locked
3 if the entry is a duplicate.
EXAMPLES
Example 1 A sample display of the soladdapp command.
The following adds an application called Disk Manager to the Solstice application registry for display in the Solstice Launcher main win-
dow.
# soladdapp -r /opt/SUNWadm/etc/.solstice_registry -n "Disk Manager"
-i /opt/SUNWdsk/etc/diskmgr.xpm -e /opt/SUNWdsk/bin/diskmgr
FILES
/opt/SUNWadm/etc/.solstice_registry
The default registry path.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsadml |
+-----------------------------+-----------------------------+
SEE ALSO
soldelapp(1M), solstice(1M), attributes(5)
NOTES
Globally registered applications are used by local and remote users sharing the software in a particular /opt directory. They can be added
only using soladdapp.
SunOS 5.11 15 Sep 1995 soladdapp(1M)