Shell Programming and Scripting

Hi

I need to append date to filename.Wrote script to get the date from table ,take this date filed and append to my i/p file when call the below script.Any help should be appreciated .

Exampel

If call the below script

a4.sh filename

o/p should be

filename.2008-02-29


. $HOME/.profile
bteq_file=./bteq_file.txt
rm $bteq_file
touch $bteq_file
echo "bteq << EOF" >> $bteq_file
echo ".logon r01ftdn/LOAD1_xx,xxxTqwe;" >> $bteq_file
echo "database xx_r5;" >> $bteq_file
echo "" >> $bteq_file
loc_code="XX"
freq_code="WC001"
echo "sel Current_process_date from "DATE_CARD" " where location_code=" '$loc_code' " and load_frequency_code="
'$freq_code' " ";">> $bteq_file

echo ".logoff" >> $bteq_file
echo ".quit" >> $bteq_file
echo ".EOF" >> $bteq_file
sh $bteq_file


/
...
....
database xx_r5;

*** New default database accepted.
*** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

sel Current_process_date from DATE_CARD where location_code= 'xx
' and load_frequency_code= 'WC001' ;

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

Current_Process_Date
--------------------
2008-02-29

+---------+---------+---------+---------+---------+---------+---------+----
.logoff
*** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+----
.quit
*** Exiting BTEQ...
*** RC (return code) = 0



Thanks,
MR

Try this (untested):

Code:

$HOME/.profile
loc_code="XX"
freq_code="WC001"

bteq << EOF > /tmp/bteq.out.$$
.logon r01ftdn/LOAD1_xx,xxxTqwe;
database xx_r5;
sel Current_process_date from "DATE_CARD" where location_code='$loc_code' and load_frequency_code='$freq_code';
.logoff
.quit
EOF

date=$(awk '/Current_Process_Date/ { getline; getline; print }' /tmp/bteq.out.$$)

rm /tmp/bteq.out.$$

echo filename.$date

Hi
Thanks,Its working


Thanks,
MR

Hi
This script is working fine ,but when call this script with i/p file its creating
more spaces between filename and date.I want to remove the sapaces and return as m1.2008-02-29


ex: a5.sh m1

m1. 2008-02-29


$HOME/.profile
file=$1
loc_code="XX"
freq_code="WC001"

bteq << EOF > /tmp/bteq.out.$$
.logon r01ftdn/LOAD1_xx,xxxTqwe;
database xx_r5;
sel Current_process_date from "DATE_CARD" where location_code='$loc_code' and load_frequency_code='$freq_code';
.logoff
.quit
EOF

date=$(awk '/Current_Process_Date/ { getline; getline; print }' /tmp/bteq.out.$$)

rm /tmp/bteq.out.$$

mv $file $file.$date
/

Thanks,
MR




m1. 2008-02-29

Hi

This below script ,take the date field from table and loading into file ,I want to add the date to i/p filename.The problem is when call this script appendintg the date to filename with more spaces(filename .28-02-2008) but when printing there is no spaces between filename and date .It was really surprising .Any help it should really appreciated.

$HOME/.profile
file=$1
loc_code="XX"
freq_code="WC001"

bteq << EOF > /tmp/bteq.out.$$
.logon r01ftdn/LOAD1_xx,xxxTqwe;
database xx_r5;
sel Current_process_date from "DATE_CARD" where location_code='$loc_code' and load_frequency_code='$freq_code';
.logoff
.quit
EOF
date=$(awk '/Current_Process_Date/ { getline; getline; print }' /tmp/bteq.out.$$)
rm /tmp/bteq.out.$$
echo "$date"
echo $file."$date" |sed -e "s/ //g'---Printing filename.date without any space
sed -e "s/ //g" $file."$date">$file1."$date"
mv $file1."$date" $file."$date"--Renaming filename .date


Thanks,
MR

Just change this line:

Code:

date=$(awk '/Current_Process_Date/ { getline; getline; print $1 }' /tmp/bteq.out.$$)

No need for sed or anything.

The sed that you added wasn't working because it was trying to remove spaces from the contents of the file, not the filename. You could have done it like this, but the above way should hopefully be simpler and tidier:

Code:

newfilename=$(echo $file.$date | sed 's/ //g')
mv $file $newfilename

Hi,

Thanks ,Its working

Thanks,
MR