RPG (IBM i / AS/400) · DB2 SQLCODE
What does SQLCODE -918 - Statements Blocked Until Rollback mean in RPG (IBM i / AS/400)?
A previous SQL statement failed in a way that leaves the current unit of work unusable, and DB2 requires an explicit ROLLBACK before it will accept any further SQL statements in that job or activation group.
A previous SQL statement failed in a way that leaves the current unit of work unusable, and DB2 requires an explicit ROLLBACK before it will accept any further SQL statements in that job or activation group.
Issue a ROLLBACK as soon as this SQLCODE appears, then decide whether the transaction can be safely retried from the beginning rather than resuming mid-stream.