Shell script for an db import process


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell script for an db import process
# 1  
Old 02-19-2010
Shell script for an db import process

Hello,

I would like a to have an script that would accept variables for "foruser" and "touser" during an db import..
I am pasting an sample script below...
The "and" in the below script needs to changed..to a correct syntax

Code:
for i in `cat /tmp/from` and  for j  in `cat /tmp/to`
do
{
imp fromuser=$i touser=$j .....
}
done

cat /temp/from
1
2

cat /tmp/to
3
4

For the first run ::: fromuser=1 and touser=3
second run ::: fromuser=2and touser=4

Thanks.

Last edited by jjoy; 02-19-2010 at 10:19 AM.. Reason: code tags, please...
# 2  
Old 02-19-2010
You can do something like this:

Code:
awk '{getline from < "/tmp/from"} {print from "," $0} ' /tmp/to |
while IFS="," read fromuser touser
do
  echo "$fromuser" en "$touser"
  # do your stuff here
done

# 3  
Old 02-22-2010
Thanks Franklin..It did work..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script Process id

Hi I have one doubt while calling a shell scripts from another shell script. suppose i have two shell script abc.sh and xyz.sh i call many instance of xyz.sh in abc.sh when i look at process id's using ps command i can see process ids for abc.sh command bur not a single process id of xyz.sh.... (2 Replies)
Discussion started by: AnkitMogha
2 Replies

2. UNIX for Dummies Questions & Answers

How to import a variable Used in Another Korn Shell Script?

Hi I am using two shell scripts which are running on the system simultaneously. And in one of the script i am exporting an Integer Variable. Now i want to use the variable in another script. But i cannot run the first script in the second as the first script has many other functions which... (3 Replies)
Discussion started by: Ajesh
3 Replies

3. Red Hat

How to run a process through shell script.?

hey , i have to write a script to run a process through shell script and if the process runs successfully then return success. i used nohup to start the process but nothing occured . #!/bin/sh nohup ./cvt -f MediationSources.xml & can anyone pls help me Thanks (3 Replies)
Discussion started by: ramsavi
3 Replies

4. Shell Programming and Scripting

Shell script validation using process.

Hi All, I have a shell script in Linux and it will be invoked by 2 methods, 1) An automated background process . 2) Logining into the box and directly executing the script. I need to put a validation in my shell script such that it will be executed successfully on when an... (11 Replies)
Discussion started by: vininx
11 Replies

5. Shell Programming and Scripting

Shell script for process monitoring

Im having a bit of troble coming up with a script that does this monitors processes to see if they die, if they do die, restart the process and write out to a log file that the process was restarted with the new PID and the date and time the new process was launched. Any suggestions? (1 Reply)
Discussion started by: jspinal
1 Replies

6. Shell Programming and Scripting

Terminate a process using shell script

Hi, I am writing a shell script to run a process and write the output of the process to a file. Inside program.sh: ./process.sh > tempfile .. open tempfile do the following But the problem is that process.sh is running indefinitely and program.sh is not executed completely. Can... (4 Replies)
Discussion started by: dreamgirl314
4 Replies

7. Shell Programming and Scripting

Kill a process from parent shell within a shell script

Hi, I am looking for a solution for the following problem: Im Using tcpdump within a shellskript started in a subshell by using brackets: ( /usr/sbin/tcpdump -i ... -c 1 ) - I want the outout of tcpdump saved in a variable - Than tcpdump-Process in the Subshell should be killed - and I... (6 Replies)
Discussion started by: 2retti
6 Replies

8. Shell Programming and Scripting

Shell Script to Kill Process(number of process) Unix/Solaris

Hi Experts, we do have a shell script for Unix Solaris, which will kill all the process manullay, it used to work in my previous env, but now it is throwing this error.. could some one please help me to resolve it This is how we execute the script (and this is the requirement) ... (2 Replies)
Discussion started by: jonnyvic
2 Replies

9. AIX

Getting process ID in a shell script.

Hi all, In my script i need to store the process ID of my app server in a variable. I know how to verify whether a process is running, by following: ps -ef|grep 'jboss' status=$? if ; then # process is running else # process is nor running fi But what I need here... (11 Replies)
Discussion started by: haroon_a
11 Replies

10. UNIX for Dummies Questions & Answers

Shell Script to end process help

I'm trying to write shell script that when invoke, has 2 arguements, or 1. If there's one arguement, then that's the process name. If there's 2, then one is the timeout. USAGE: Assign1.sh <process> <timeout> If no timeout was set, then the default timeout is 15 minutes. So after it read the... (6 Replies)
Discussion started by: NoobieBoobie
6 Replies
Login or Register to Ask a Question