# Get schema from DB
db2 connect to CONCORD 
#db2 connect to CONCORD >/dev/null 2>&1
output=`db2 -x "select \"SCHEMA_VERSION\" from \"CONCORDDB\".\"PRODUCT\" where \"ID\"='lotuslive.symphony'"` 
db2 connect reset

# Parse schema number, or set to 0 if not found
trim() { echo $1; }
VERSION="$(trim $output )"
echo "Schema version number is $VERSION"
if ! [[ "$VERSION" =~ ^[0-9]+$ ]]
then
	echo "Get NON-NUMBER FOR SCHEMEMA version, SET IT TO ZERO "
	VERSION=0
fi
echo "update sql with version $VERSION"

DIRTY=0

while [ "" = "" ]
do
    ((VERSION++))
    if [ -f "fixup$VERSION.sql" ]
    then
        echo "applying fixup$VERSION.sql"
        dos2unix -n fixup$VERSION.sql fixup_tmp.sql
        mv -f fixup_tmp.sql fixup$VERSION.sql
        db2 -td@ -f fixup$VERSION.sql
        DIRTY=1
    else
        break
    fi
done

:
: