Unix scripting pl help


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Unix scripting pl help
# 1  
Old 12-05-2007
Unix scripting pl help

Hi All,
I am new to Unix Scripting. I have below scenario. I need to write a Unix function with the following.


1. I have table. From this table I need to write a query.

SELECT Col1(File_nm),Col2(From_Loc),Col3(To_Loc)
FROM A
WHERE CONDITION

For example

Col1(File_nm) Col2(From_Loc) Col3(To_Loc)
Rec1: PROD20071010 HOME/RAD INBOX/OUT
Rec2:PROD20071105 HOME/RAD INBOX/OUT
Rec3:PROD20070809 HOME/RAD INBOX/OUT


This query will return three records with different Timestamped filename.

2. I need to select recent File_nm(New Timestamp i.e Rec2)

3. eliminate the Control characters from the above file

4. Copy the file from HOME/RAD to INBOX/OUT


Earliest response appreciated.

Regards,
Sree
# 2  
Old 12-06-2007
If I understand you right, you want to perform a copy for each of the files returned by that select statement?

If we assume the following as a sample of your input:
Code:
Col1(File_nm) Col2(From_Loc) Col3(To_Loc)
Rec1:PROD20071010 HOME/RAD INBOX/OUT
Rec2:PROD20071105 HOME/RAD INBOX/OUT
Rec3:PROD20070809 HOME/RAD INBOX/OUT

We'd want the following bit of shell
Code:
#!/bin/sh
while read line
do
`echo "$line" | cut -d ':' -f 2 | awk '{ print "cp "$2"/"$1" "$3 }'`
done

Then just pipe the input into the script, using tail +2 to remove the 'Col1(...' rubbish.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX scripting

LIST=/home/xxxxxxx/ABC/xeeno_scrpts/temp/tempfile ERRORDIR=/home/xxxxxxx/ABC/error_directory EMAILFILE=/home/xxxxxxx/ABC/xeeno_scrpts/temp/emailfile echo "There were errors in the following report file for Xeenos:" > $EMAILFILE echo >> $EMAILFILE echo "This files have been moved to... (9 Replies)
Discussion started by: bcarosi
9 Replies

2. UNIX for Dummies Questions & Answers

Unix Shell Scripting( Calling from Unix to PLSQL)

Hello Experts, I have the following questions to be discussed here at this esteemed discussion forum. I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies

3. UNIX for Advanced & Expert Users

Unix scripting

i need help with this problem this is the problem: Write a script that logs how many users login on/off the system over a 5 minute period. It can run in the foreground, and run 4 times a minute. Set a trap that will not allow a CNTRL-C command, and if a CNTRL-C is excuted store the time and date... (1 Reply)
Discussion started by: sportsmansixty6
1 Replies

4. Shell Programming and Scripting

Unix scripting

how to check if a unix script gets executed without errors across all unix platforms. incase if a script gets executed without errors only one platform say AIX, what needs to be done to that script such that it will run all unix platforms like linux, hp, sun etc (2 Replies)
Discussion started by: rmann
2 Replies

5. Shell Programming and Scripting

Unix Scripting

Hi Gurus, I am a system admin in solaris field and ive planned to study unix scripting.ive planned to start reading Mastering Unix scripting by randal.Scripts in that are based on Korn shell(ksh).my question is whether the same scripts can be applied to other shells like bash etc..And... (4 Replies)
Discussion started by: madanmeer
4 Replies

6. UNIX for Dummies Questions & Answers

Unix Scripting

Hi Gurus, I am a system admin in solaris field and ive planned to study unix scripting.ive planned to start reading Mastering Unix scripting by randal.Scripts in that are based on Korn shell(ksh).my question is whether the same scripts can be applied to other shells like bash etc..And... (1 Reply)
Discussion started by: madanmeer
1 Replies

7. UNIX for Dummies Questions & Answers

Help me Out in unix scripting

Hello every one, plz help me out. I m using 4 files in unix, like file1, file2, file3,file4 in which primary key is ID in column(field) of 4 files. On the bases of ID, i want the corresponding field of 4 files in final file let say collected file. In collected file, ID column should occur only one... (16 Replies)
Discussion started by: kaprus
16 Replies

8. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

9. UNIX for Dummies Questions & Answers

Help With Unix Scripting.

Can anybody tell me the best way to learn unix scripting.can you recommend a good book.Please help! (1 Reply)
Discussion started by: hella
1 Replies

10. UNIX for Dummies Questions & Answers

UNIX Scripting

:confused: I need to find a place or places on the Internet where I can find UNIX scripts to view and to modify to make life easy on the UNIX environment. Can someone help me on this. Thanks (7 Replies)
Discussion started by: wolf
7 Replies
Login or Register to Ask a Question