UNIX for Dummies Questions & Answers

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

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.