Script to generate a template OrderBy.txt file for SAP R3load import when using splits on DB2LUW

generate_orderby_import.sh

#!/usr/bin/sh
SID=$1
#cd /migration/$SID/exp/010715/ABAP/DATA
list=$(ls -la *.WHR | awk -F ' ' '{print $9}' | sed -e 's/\.WHR//g')
prev_table=""
for l in $list
do
  table=$(echo $l | sed -e "s/-.*//g")
  tableu=$(echo $table | tr '[a-z]' '[A-Z]')
  if (test "$prev_table" != "$table") then
    echo
    echo "[""$tableu""]"
    echo "jobNum=1"
    echo "loadArgs=-loadprocedure fast LOAD_FORCED:COMPRESS_ALL:DEF_CRT -merge_bck"
  fi
   echo $l
   prev_table=$table
done

Remove -nolog as caused an issue with some split BW tables. (SAP no longer recommend this option)