Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to Pull out multiple files from DB table and redirect all those files to a differetn directory?

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to Pull out multiple files from DB table and redirect all those files to a differetn directory?
Prev   Next
# 1  
Old 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.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Load multiple files into a table

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

2. Shell Programming and Scripting

How do I use grep to pull incremental data and send to multiple files?

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

3. UNIX for Dummies Questions & Answers

Reading Table name from a list of files in a Directory

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

4. Shell Programming and Scripting

find string from multiple dir and redirect to new files

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

5. UNIX for Dummies Questions & Answers

Redirect stdin stdout to multiple files

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

6. Shell Programming and Scripting

how to redirect multiple input files?

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

7. Shell Programming and Scripting

How to redirect the output to multiple files without putting on console

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

8. Shell Programming and Scripting

redirect files to a directory

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

9. UNIX for Dummies Questions & Answers

can you redirect multiple files for input?

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

10. UNIX for Dummies Questions & Answers

Redirect output to multiple files.

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
Login or Register to Ask a Question

LEARN ABOUT SUSE

mono-asp-apps

mono-asp-apps(1)						   User Commands						  mono-asp-apps(1)

NAME

       mono-asp-apps - utility to manage ASP.NET 2.0 applications installed from RPMs

SYNOPSIS

       mono-asp-apps command [options]

DESCRIPTION

       The  'mono-asp-apps'  command is useful on systems which install applications from RPM packages and when the RPM packages have been created
       according to the Mono RPM packaging guidelines for ASP.NET applications.

       The utility allows one to initialize, enable, disable and start installed applications.	Note that you do not use this  utility	to  manage
       applications hosted and managed by the Apache (or other) web server, only by xsp.

       Note  that  this  utility is useful only on systems where at least one application packaged according to the Mono ASP.NET 2.0 RPM packaging
       guidelines has been installed.

COMMANDS

       The commands which take an application name, require the it to be one of the registered names. See the `list` command below.

       init APPLICATION_NAME
	      Initializes the application named APPLICATION_NAME, if it hasn't been done already.  Initialization actions performed  are  applica-
	      tion specific, but may include creating databases and populating them, creating directories, downloading files etc.

       enable APPLICATION_NAME
	      Enables APPLICATION_NAME for automatic start when XSP is started as part of the system bootup process.

       disable APPLICATION_NAME
	      Disables APPLICATION_NAME, so that it is not started automatically when XSP is started as part of the system bootup process.

       start APPLICATION_NAME [server_options]
	      Manually	starts	the  xsp2  process passing the configuration of APPLICATION_NAME to the xsp2 process. Applications may ship with a
	      bundled start script which will be used instead of xsp2 if present. server_options are passed verbatim to the server process.

       list   Lists all the applications known to the utility.

AUTHORS

       Marek Habersack <mhabersack@novell.com>

SEE ALSO

       xsp(1)

MORE INFORMATION

       The Mono project (http://www.go-mono.com) is a collaborative effort led by Novell (http://www.novell.com) to implement an open source  ver-
       sion of the .NET Framework.

MAILING LISTS

       Mailing lists are listed at the http://www.mono-project.com/Mailing_Lists

mono-asp-apps 2.6.4						    31 Oct 2007 						  mono-asp-apps(1)