Sponsored Content
Top Forums Shell Programming and Scripting How to Pull out multiple files from DB table and redirect all those files to a differetn directory? Post 302373528 by ss3944 on Friday 20th of November 2009 03:54:24 PM
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.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
ideviceinstaller(1)					      General Commands Manual					       ideviceinstaller(1)

NAME
ideviceinstaller - Manage iDevice apps SYNOPSIS
ideviceinstaller [OPTIONS] DESCRIPTION
Allows to install, upgrade, uninstall, archive, restore and enumerate installed or archived apps on iDevices. OPTIONS
General options: -d, --debug enable communication debugging. -U, --uuid UUID target specific device by its 40-digit device UUID. -h, --help prints usage information Commands: -l, --list-apps list apps installed on the device. Additional options: -o list_user list user apps only (apps installed by the user) This is the default. -o list_system list system apps only (apps available from the system firmware) -o list_all list all types of apps -o xml print output in xml format (PList) -i, --install ARCHIVE install app from a package file specified by ARCHIVE. -u, --uninstall APPID uninstall app specified by APPID. -g, --upgrade APPID upgrade app specified by APPID. -r, --restore APPID restore archived app specified by APPID. -L, --list-archives list archived applications on the device. Additional options: -o xml print output in xml format (PList) -a, --archive APPID archive app specified by APPID. Additional options: -o uninstall uninstall the package after making an archive -o app_only archive application data only -o copy=PATH copy the app archive to directory PATH when done -o remove only valid when copy=PATH is used: remove after copy -R, --remove-archive APPID remove app archive specified by APPID. AUTHOR
This manual page was written by Martin Szulecki. ideviceinstaller(1)
All times are GMT -4. The time now is 05:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy