Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers xargs
# 1  
Old 09-16-2001

Can I use xargs to send a list of commands to a process, to be acted upon individually? Here's what I have: a file that contains numbers, one per line. The desired outcome it to send each number to a DB2 query. I thought xargs would work, but it doesn't. I tried it like this:

cat file | xargs | db2 "select * from table where field = $*"

Can this work somehow?

# 2  
Old 09-16-2001
Someone else can reply better than I concerning xargs because I rarely use that utility.

FWIW: if I had your problem I would write a 5 line PERL script that:

(1) opens the file
(2) reads each line into a $variable
(3) executes the DB command with $variable.

You can also do this with other shell languages using the same basic idea/algorithm above.

Someone familar with PERL , for example, could write the script faster than it takes to post to the forum Smilie because it is just a few lines of code.

Others may want to discuss your xarg problem-solution more directly......

can you believe it?? ...... i was just making a peanut-butter-and-jelly sand' and dropped a big hunk of peanut butter on the keyboard replying to this post .... Smilie
# 3  
Old 09-17-2001
xargs would not be my first choice for something like this, but it can certainly be made work. I don't know what the db command is and looking at your syntax, I can't tell where the arg should be inserted, but here is an example using echo:

cat file | xargs -l -i echo "arg is {}"

and even better:

xargs -l -i echo "arg is {}" < file

Hmmm, I gotta admit that using xargs in a case like this is starting to appeal to me...
# 4  
Old 09-17-2001
xargs works

Thanks everyone. I did get it to work, using xargs with the -n1

file1 is just a list of numbers, one per line:

cat file1 | xargs -n1 "db2 select * from table1 where field1 in ('$*')"
# 5  
Old 09-17-2001
Nice job. Thanks for the follow-up post with your solution for everyone interested in xargs to learn from.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers


Hi, can anyone tell me in detail ? what the following do in detail ? I am trying to get a largest number in a list Thanks Tao LARGEST=$(echo $* | xargs -n1 | sort -nr | tail -1) (3 Replies)
Discussion started by: ccp
3 Replies

2. Shell Programming and Scripting


Hello, I need some help with xargs $ ls aaa bbb ccc ddd$ ls | xargs -I{} ls -la {} -rw-rw-r--. 1 xxx xx 0 May 30 20:04 aaa -rw-rw-r--. 1 xxx xx 0 May 30 20:04 bbb -rw-rw-r--. 1 xxx xx 0 May 30 20:04 ccc -rw-rw-r--. 1 xxx xx 0 May 30 20:04 dddit's possible to have output like this with... (3 Replies)
Discussion started by: vikus
3 Replies

3. Shell Programming and Scripting

Help with xargs

Using the bash shell I'm trying to either create a command for the command line or a script that will show netstat info for a given process name. Here is an example of what I'm trying to do:$ ps aux |grep catalina |grep -v grep | awk '{print $2}' 5132 $ netstat -nlp |grep 5132 (Not all processes... (11 Replies)
Discussion started by: axiopisty
11 Replies

4. Shell Programming and Scripting

Help with xargs

hi Could any one please tell me the option using which we can run multiple commands using xargs I have list of files, I want to run dos2unix and chmod at one shot on them I tried google n searched man pages but couldnt really find the solution , please help right now im doing this ls... (4 Replies)
Discussion started by: sunilmenhdiratt
4 Replies

5. Shell Programming and Scripting

Xargs and

Hello there, Let me show you a simple example of what I am trying to achieve: 1) I have an input text file with some lines: 1 a 2 b 3 c 2) And I want to run a command with these lines as arguments (+ arbitrary extra arguments). For example: $ command "1 a" "2 b" "3 c" "bye" I... (7 Replies)
Discussion started by: tokland
7 Replies

6. Shell Programming and Scripting

Help in using xargs

Hi, I have a requirement to RCP the files from remote server to local server. Also the RCP has to run in parallel. However using 'xargs' retrives 2 file names during each loop. How do we restrict to only one file name using xargs and loop till remaining files. I use the below code for... (2 Replies)
Discussion started by: senthil3d
2 Replies

7. Shell Programming and Scripting

Using xargs

hi i just want to know that how do we use xargs command to find files which are greater than specified memory in a given directory (6 Replies)
Discussion started by: sumit the cool
6 Replies

8. UNIX for Advanced & Expert Users

xargs -P

I discovered that GNU's xargs has a -P option to allow its processes to run in parallel. Great! Is this a GNU thing, or is it supported by other platforms as well? (4 Replies)
Discussion started by: otheus
4 Replies

9. Shell Programming and Scripting

why we use xargs..

hi , can anyone help me by saying why we use xargs.. is it acing like a place holder..? thanks, Krips. (3 Replies)
Discussion started by: kripssmart
3 Replies

10. UNIX for Dummies Questions & Answers

Help with xargs

Hi there, I am trying to move around 3000 files from one directory to another. The mv command is complaining from too many arguments. I tried to use the xargs command but with no luck. Could some body provide help? Regards (4 Replies)
Discussion started by: JimJim
4 Replies
Login or Register to Ask a Question