Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to Pull out multiple files from DB table and redirect all those files to a differetn directory?
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 302373591 by rdcwayx on Saturday 21st of November 2009 01:08:31 AM
Old 11-21-2009
Something like this?

Code:
$ awk 'NR>1 {if($4>500) print "cp ",$3"/"$2,$3"/new/"$2} ' ur_table_file
cp  /apps/opt/UNO_1234 /apps/opt/new/UNO_1234
cp  /apps/opt/UNO_1235 /apps/opt/new/UNO_1235
cp  /apps/opt/UNO_1236 /apps/opt/new/UNO_1236

you can export the output to a file, and add x permission on it, then run it.
 

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

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)
All times are GMT -4. The time now is 01:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy