|
|
|
|||||||
| Home | Forums | Register | Rules & FAQ | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX Desktop for Dummies Questions & Answers Questions regarding GNOME, KDE, CDE, Open Office, etc go here. All UNIX and Linux Newbies Welcome !! |
Other UNIX.COM Threads You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| substr() thru awk Korn Shell Script | sbryant | Shell Programming and Scripting | 4 | 01-24-2008 07:16 AM |
| Help with Korn Shell script | heprox | AIX | 1 | 12-19-2005 10:04 AM |
| korn shell script | pavan_test | UNIX for Dummies Questions & Answers | 1 | 10-26-2005 10:17 AM |
| Multiple su - in Korn Shell script | furrari | Shell Programming and Scripting | 2 | 07-30-2004 06:29 AM |
| su and password in a Korn shell script | Melissa | UNIX for Dummies Questions & Answers | 2 | 10-03-2001 04:24 PM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
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 
|
| Forum Sponsor | ||
|
|
|
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
|
|
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
|
Linear Mode
