Thank you very much anchal khare and abubacker for your prompt response.
Really appreciate.
To make it clear.. This is my original objective:
Quote:
job_name="$(echo "load_didrnge.sh")"
table_name="$(echo "DIDRNGE")"
cv="$(echo "CV000")"
cv="$(print 'CV09')"
file_name=`CP99978_`$cv`.TXT`
file_name="$(awk '{print $1}' $cv )"
log=/tmw/oradata14/monthly_log/CP99978_$cv.log
sqlldr crispadm/admcrisp data=/tmw/oradata14/CP99978_CV001.TXT control=/home/oracle9/dba_area/adslmpr.ctl log=/tmw/oradata14/monthly_log/CP99978_CV001.TXT.log \
bad=/tmw/oradata14/monthly_log/CP99978_CV001.TXT.bad errors=5000000 skip=1
set cv="$(echo "CV001")"
/home/oracle9/dba_area/general/PROCEDURE_TRACKING_LOG.sql "$job_name" "$file_name" "$table_name" "$log"
In other words, I'm gonna repeat that sqlldr command for another 3 CVs..
Since, the filename only distinctive by that CV.. That's why I don't want to issue that filename command again and again.
Thank you.
---------- Post updated at 03:37 PM ---------- Previous update was at 03:33 PM ----------
So, is that the only way to achive this i.e. by creating function?
I don't know it could be that difficult..
I thought I only need to change something so that the
$filename would reflect the
current value of
$cv.
Why can't it anyway? Anyone?