korn shell script


 
Thread Tools Search this Thread
Special Forums UNIX Desktop Questions & Answers korn shell script
# 1  
Old 10-26-2005
korn shell script

hi all

i am writing the korn shell script.
i have a SQL script which gives me the folowing output

DSA.WLG.20050713211544.20051025.20050713211544 28991 1130198400
DSA.WLG.20050713211544.20051025.20050713211544 25881 1130198400
DSA.WLG.20050711210100.20051025.20050711210100 25881 1130198400
DSA.WLG.20050711210100.20051025.20050711210100 28991 1130198400



i have to write a korn shell script which will move the

DSA.WLG.20050713211544.20051025.20050713211544 SA.WLG.20050713211544.20051025.20050713211544
DSA.WLG.20050711210100.20051025.20050711210100
DSA.WLG.20050711210100.20051025.20050711210100

the above to a folder say /home/pav and

28991 1130198400
25881 1130198400
25881 1130198400
28991 1130198400

the above to a different folder say /home/ssk


can anyone help me please

thanks
# 2  
Old 10-26-2005
when you say 'move' I assume the output of the SQL script is a list of FILENAME - 3 per line.
Code:
#!/bin/ksh

pav='/home/pav'
ssk='/home/ssk'

yourSQLscript | while read one two three junk
do
   mv "${one}" "${pav}"
   mv "${two}" "${ssk}"
   mv "${three}" "${ssk}"
done

# 3  
Old 10-26-2005
korn shell script

the output of the sql script is:

DSA.WLG.20050713211544.20051025.20050713211544 28991 1130198400
DSA.WLG.20050713211544.20051025.20050713211544 25881 1130198400
DSA.WLG.20050711210100.20051025.20050711210100 25881 1130198400
DSA.WLG.20050711210100.20051025.20050711210100 28991 1130198400

then korn shell script has to move the 1st column:to /home/sk

DSA.WLG.20050713211544.20051025.20050713211544
DSA.WLG.20050713211544.20051025.20050713211544
DSA.WLG.20050711210100.20051025.20050711210100
DSA.WLG.20050711210100.20051025.20050711210100


the the 2nd column and 3rd column move to /home/ssk

28991 1130198400
25881 1130198400
25881 1130198400
28991 1130198400

i tried yours. read one two three..what is it i could not understand..
i will not get any headings from my sql script since i am using set heading off in my sql script.

can you please clarify..
Thanks & Regards
# 4  
Old 10-27-2005
I don't quite understand what you've tried and what didn't work...
Can you elaborate, pls!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with improving korn shell script

I am primarily a SQA/Tester and new to korn shell. How can I improve the following script? #/bin/ksh SourceLocation=~/Scripts/Test/Source TrackerLocation=~/Scripts/Test/Tracker TargetLocation=rdbusse@rdbmbp:/Users/rdbusse/Scripts/Test/Target for file in $(cd $SourceLocation; ls) do ... (7 Replies)
Discussion started by: bayouprophet
7 Replies

2. Shell Programming and Scripting

Need urgent help with korn shell script

Hi All, Need urgent help with korn shell script, which monitors AIX WPARs Status. Basically WPARs run on a LPAR, So there is a Command "lswpar" which displays WPARs status. This script should be checking the WPARs Status and email support if WPAR is down or broken. General lswpar output is as... (3 Replies)
Discussion started by: aix_admin_007
3 Replies

3. Shell Programming and Scripting

pass null value to sql script from korn shell script

There are 4 parameters that I have to pass from korn shell to sql script. 1) I have to check if $1 , $2 , $3 and $4 are null values or not . How can I do that ? 2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies

4. Shell Programming and Scripting

korn shell script guidance

Please look over my short comings during this line if questions. I have multiple lines in a file that look like, phycook 618722 1 76 12:15:13 pts/122 70:24 /4js/runtime2.02.10/lib/fglrun-bin initmenu.42r phycook 593484 1 65 12:15:18 pts/122 69:22... (3 Replies)
Discussion started by: juredd1
3 Replies

5. Homework & Coursework Questions

Korn Shell Script

1. The problem statement, all variables and given/known data: Write a korn shell script with an alfanumeric string as argument. The script lists the file's names in the current directory that contain the given string as substring and that can be read and written. 2. Relevant commands, code,... (3 Replies)
Discussion started by: burm
3 Replies

6. Shell Programming and Scripting

Korn Shell Script

I have to solve some exercises in Korn Shell, but i'm having some problems. For example: Write a korn shell script with an alfanumeric string as argument. The script lists the file's names in the current directory that contain the given string as substring and that can be read and written. I... (3 Replies)
Discussion started by: burm
3 Replies

7. Shell Programming and Scripting

Korn shell interactive script

Hi, How can I prompt a user for two input and pass the input to variables in the script. I have the following script but it is not working: +++++++++Begin+++++++++++ #!/bin/sh database_c=$1 output_f=$2 echo "Your db is $1\nOutput is $2" +++++++++End+++++++++++ Thanks, Leonard (3 Replies)
Discussion started by: leonard905
3 Replies

8. Shell Programming and Scripting

Korn Shell script not running

I am sorry, this is really trivial, yet I am not able to understand what the problem is! I am using korn shell and running this script #!/bin/ksh keep=3 while ; do echo $keep keep=$(($keep-1)) done I am getting this error: `keep=$' unexpected I am not able to understand it because ... (1 Reply)
Discussion started by: Asty
1 Replies

9. AIX

Help with Korn Shell script

I have this Korn shell script that runs via a cron entry. It runs in a loop "watching" a specific file system for files with a certain name. The file system that it is watching is an upload file system for an FTP server. When files that are the correct name come in, it takes the extension of the... (1 Reply)
Discussion started by: heprox
1 Replies

10. UNIX for Dummies Questions & Answers

korn shell script

hello., i have 2 files.. 1 file is in this folder /home/test/ssk/DSA.WLG.20050713211544.20050710.20050713211544 (this part) other file is in this folder /home/kk/dev/DSA.WLG.20050711210100.20050710.20050711210100 ... (1 Reply)
Discussion started by: pavan_test
1 Replies
Login or Register to Ask a Question