Shell Programming and Scripting

get_table_id 
if [ ${HMAX_TBL_ID} = ${GMAX_TBLI_D} ]
 then   
   echo -e "All table ids are processed"
else
   echo "Do some processing"  
fi

##define start_load function##
start_load()
#some processing
get_table_id
#some more processing
############ Main section#################

if ${option} = 'ALL' then

start_load ${tab_name1} 
start_load ${tab_name2}

fi

get_tbl_id_list()
{
        TABLE_NAME=$1
        LOADER_ID=$2

        LAST_PROCESSED_TABLEID=`nzsql -q -A -t -c "select max(last_processed_tableid) from tab_pqr where tbl_name='${TABLE_NAME}' and status_flag='S'"

        if [ $? -ne 0 ]
        then
                echo -e "Error While getting the last processed tableid"
                exit 1;
        fi

        HMAX_TBL_ID=`psql -U ${PG_USER} -h ${PG_HOST} -d ${PG_DB} -p ${PG_PASS} -A -t -c "select stp_ctr_tbl_id('ARIB', 'GET')"`

        if [ $? -ne 0 ]
        then
                echo -e " Error while getting the maximun table id processed in Hadoop "
        fi

        if [ ${HMAX_TBL_ID} = ${LAST_PROCESSED_TABLEID} ]
         then   
          echo -e "All table ids are processed"
        else
        psql -U ${PG_USER} -h ${PG_HOST} -d ${PG_DB} -p ${PG_PASS} -t -c "select distinct tbl_id from tbl_ctr_hdr where tbl_id between ${LAST_PROCESSED_TABLEID}+1 and ${HMAX_TBL_ID}" | sed '/^$/d' > ${TBL_ID_FILE}

           if [ $? -ne 0 ]
            then
                 echo -e " Error while getting the list of Table ids"
           fi
        fi
}

migrate_tables
{
TAB_NAME=$1
loader_id=BD

 echo -e " loader ids that are processing ... 
 
 get_tbl_id_list ${TAB_NAME} ${loader_id}
 
 ##some more processing##
 }
 
#########################Calling function to load data in table#####################
tab_name=$1 
#some checks and other processing
if [ ${tab_name} = 'ALL' ] 
	then
	   echo -e " Loading tab_abc table have started"
	     migrate_tables 'tab_abc'
       
	   if [ $? -ne 0 ]
		 then
			echo -e "Error While processing 'tab_abc' using ALL option"
			exit 1;
		fi
	   
	    echo -e "Loading tab_xyz has started"
	       migrate_tables 'tab_xyz'
 
		if [ $? -ne 0 ]
		 then
			echo -e "Error While processing tab_xyz using ALL option "
			exit 1;

		fi
fi