Shell Programming and Scripting

This might have been covered above.
The original statement contains too many quotes and as others have pointed out unnecessary "print" and "echo" commands. Remember that quotes act in pairs, though in this case it has no adverse effect.

Can be simplified as:

Code:

cv="CV09"
file_name="CP99978_${cv}.TXT"

Now does this actually help:

In this test code we will try four values of ${cv}.

Code:

for cv in "2007" "2008" "2009" "2010"
do
          file_name="CP99978_${cv}.TXT"
          echo "${file_name}"
done

CP99978_2007.TXT
CP99978_2008.TXT
CP99978_2009.TXT
CP99978_2010.TXT

---------- Post updated at 01:31 ---------- Previous update was at 00:57 ----------

My attempt to rearrange the original post follows this quote from the O/P:



Some inspired guesswork here. Could be wrong. Untested. Check before use. Any likely typos from the original such as "CV09" and "crispadm/admcrisp" (not absolute path) are carried forward verbatim.
The idea is to illustrate parameter substitution in shell with no attempt to check the Oracle commands. I have attempted to get the line continuation characters correct "\" to make some sense of the Oracle commands. I now think that there are two commands.


FINAL FINAL ATTEMPT AT REARRANGING

Code:

job_name="load_didrnge.sh"
table_name="DIDRNGE"
for cv in "CV000" "CV001" "CV09"
do
    file_name="/tmw/oradata14/CP99978_${cv}.TXT"
    log="/tmw/oradata14/monthly_log/CP99978_${cv}.TXT.log"
    bad="/tmw/oradata14/monthly_log/CP99978_${cv}.TXT.bad"
    #
    sqlldr crispadm/admcrisp data="${file_name}" \
        control="/home/oracle9/dba_area/adslmpr.ctl" \
        log="${log}" \             
        bad="${bad}" \
        errors=5000000 skip=1
    #
    sqlplus /home/oracle9/dba_area/general/PROCEDURE_TRACKING_LOG.sql \
        "${job_name}" "${file_name}" "${table_name}" "${log}"
done

Guessed at sqlplus to run the second program.
Not happy that ${log} appears on both command lines, but without knowledge of the correct syntax or intentions we'll leave it to the author to decide.