The syntax for setting a Redrive query band is:
SET QUERY_BAND = 'redrive=off;' FOR SESSION; SET QUERY_BAND = 'redrive=on;' FOR SESSION;
The Redrive capability is assigned to a session at logon time. Once a session is enabled with Redrive, you can use the Redrive query band to toggle Redrive protection on and off during the life of the session.
Redrive set to OFF disables Redrive protection for subsequent SQL requests in the session. When Redrive is off, there is no automatic Teradata Database recovery of submitted SQL requests after a database failure, and any recovery is controlled by the application.
Redrive set to ON enables Redrive protection for subsequent SQL requests in the session.
- Teradata Vantage™ - Database Administration, B035-1093
- The RedriveProtection and RedriveDefaultParticipation DBS Control fields in Teradata Vantage™ - Database Utilities , B035-1102