1. OUT=` db2 -es +o "your sql statement" `
2. echo DB2 return code is ${?}
3. echo DB2 sqlstate is ${OUT}

The –ec switch is interpreted as display sqlcode; to display sqlstate use –es.