Checking SQL return codes from a Script file?

When you execute more than one SQL commands (a logical unit of work: UPDATE, INSERT, ...) in a Korn shell script, is there a way to check the *return codes* from each SQL command and backout the commands if one fails? If so, how can this be done in a script? Thanks! Lenny.