Shell Programming and Scripting

HMAX_TBL_ID=`psql -U ${PG_USER} -h ${PG_HOST} -d ${PG_DB} -p ${PG_PASS} -t -c "select stp_ctr_fetch_module_tbl_id('ATTRIB', 'GET')"` | sed -e 's/^[ \t]*//'

        echo -e "This is max table id in ${HMAX_TBL_ID} "

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


  psql -U ${PG_USER} -h ${PG_HOST} -d ${PG_DB} -p ${PG_PASS} -t -c "select distinct tbl_id from tbl_ctr_module_tbl where tbl_id between ${LAST_PROCESSED_TABLEID} and ${HMAX_TBL_ID}" | sed '/^$/d' > ${TBL_ID_FILE}

stp_ctr_fetch_module_tbl_id('ATTRIB', 'GET')

$ cat x
a="  1234"
print "Before: [$a]"
typeset -i a   # make it an integer.
print "After: [$a]"

b="  1234"
print "Before: [$b]"
b=$(print $b)
print "After: [$b]"


$ ./x
Before: [  1234]
After: [1234]
Before: [  1234]
After: [1234]
$