Amazon Redshift announces support for enhanced transaction controls inside stored procedures which enables you to automatically commit the statements inside the procedure. This new NONATOMIC mode can be used for those applications that would like to handle exceptions inside a stored procedure more smoothly. In addition, the NONATOMIC mode helps prevent disruptions in applications due to an error inside a stored procedure.
Source:: Amazon AWS