UNIX for Dummies Questions & Answers

#!/bin/ksh

Folder_Name=$1
Workflow_Name=$2

Log_Dir=/home/parm_file
Log_File=parm_file_log.log

echo "Running" > $Log_Dir/$Log_File
echo " " >>  $Log_Dir/$Log_File


Parm_Dir=/ParmFiles/$Folder_Name
Parm_File=$Workflow_Name.parm
touch $Parm_Dir/$Parm_File

echo "Calling SQL"  >> $Log_Dir/$Log_File
echo " " >>  $Log_Dir/$Log_File        

echo "SQLPLUS Cmd"  >> $Log_Dir/$Log_File
echo "  " >> $Log_Dir/$Log_File  

sqlplus -s USR/PW@DB  <<EOF >$Log_Dir/test.dat
     
     set term off
     set head off
     set trims on
     set pages 0
     set feedback off
         set linesize 1000
          
             
     SELECT session_name || '|' || mapping_name || '|' || parm_name || '|'|| parm_val FROM spasupa.v_parm_ref_table where FOLDER_NAME = '$Folder_Name' and WORKFLOW_NAME = '$Workflow_Name';
     /
     exit;                      
         EOF
###### The script exits right here. Anyway I can fix that? :wall:         

echo "SQL Complete"  >> $Log_Dir/$Log_File
echo "  " >> $Log_Dir/$Log_File      

echo "Write Parm"  >> $Log_Dir/$Log_File
echo "  " >> $Log_Dir/$Log_File  

file="$Log_Dir/test.dat"

while read line
do
     echo "$line"
done <"$file"

Running
 
Creating Parm File wf_m_Test_Parm_File.parm  in  /gfs/ParmFiles/DevWorkArea-SPASUPA
  
Calling SQL
 
SQLPLUS Cmd

$ sh parm_test.sh blah blah...

$ parm_test.sh blah blah...