#!/bin/bash
##**** definition of variables ****
DB2PATH=/bin/db2
DBNAME=mydb
SchemaName=customer
declare -A tables
tables=( [REQUEST]=REQ [RESPONS]=RES [METHOD]=MTH )

for t in "${!tables[@]}"
do
key=${tables[$t]}

$DB2PATH -x "SELECT HIGHVALUE as LastHighValue FROM SYSCAT.DATAPARTITIONS
WHERE TABSCHEMA='$SchemaName' AND TABNAME='$t' AND
DATAPARTITIONNAME=$key "
done

SELECT HIGHVALUE as LastHighValue FROM SYSCAT.DATAPARTITIONS
WHERE TABSCHEMA='customer' AND TABNAME='METHOD' AND DATAPARTITIONNAME=MTH
SELECT HIGHVALUE as LastHighValue FROM SYSCAT.DATAPARTITIONS
WHERE TABSCHEMA='customer' AND TABNAME='RESPONS' AND DATAPARTITIONNAME=RES
SELECT HIGHVALUE as LastHighValue FROM SYSCAT.DATAPARTITIONS
WHERE TABSCHEMA='customer' AND TABNAME='REQUEST' AND DATAPARTITIONNAME=REQ