Stops a request. This API is called from a control break signal handler in an application. The control break signal handler can be the default, installed by sqleisig - Install Signal Handler, or a routine supplied by the programmer and installed using an appropriate operating system call.
Authorization
None
Required Connection
None
Version
sqlenv.h
C API Syntax
/* File: sqlenv.h */
/* API: Interrupt */
/* ... */
SQL_API_RC SQL_API_FN
sqleintr (
void);
/* ... */
|
Generic API Syntax
/* File: sqlenv.h */
/* API: Interrupt */
/* ... */
SQL_API_RC SQL_API_FN
sqlgintr (
void);
/* ... */
|
API Parameters
None
REXX API Syntax
INTERRUPT |
Examples
call SQLDBS 'INTERRUPT'
Usage Notes
No database manager APIs should be called from an interrupt handler except sqleintr. However, the system will not prevent it.
Any database transaction in a state of committing or rollback cannot be interrupted.
An interrupted database manager request returns a code indicating that it was interrupted.
The following table summarizes the effect of an interrupt operation on
other APIs:
| Database Activity | Action |
|---|---|
| BACKUP | Utility cancelled. Data on media may be incomplete. |
| BIND | Binding cancelled. Package creation rolled back. |
| COMMIT | None. COMMIT completes. |
| CREATE DATABASE/CREATE DATABASE AT NODE/ADD NODE/DROP NODE VERIFY | After a certain point, these APIs are not interruptible. If the interrupt call is received before this point, the database is not created. If the interrupt call is received after this point, it is ignored. |
| DROP DATABASE/DROP DATABASE AT NODE | None. These APIs complete. |
| EXPORT/IMPORT/RUNSTATS | Utility cancelled. Database updates rolled back. |
| FORCE APPLICATION | None. FORCE APPLICATION completes. |
| LOAD | Utility cancelled. Data in table may be incomplete. |
| PREP | Precompile cancelled. Package creation rolled back. |
| REORGANIZE TABLE | Utility cancelled. Table is left in its previous state. |
| RESTORE | Utility cancelled. DROP DATABASE performed. Not applicable to table space level restore. |
| ROLLBACK | None. ROLLBACK completes. |
| Directory Services | Directory left in consistent state. Utility function may or may not be performed. |
| SQL Data Definition statements | Database transactions are set to the state existing prior to invocation of the SQL statement. |
| Other SQL statements | Database transactions are set to the state existing prior to invocation of the SQL statement. |
See Also
sqleisig - Install Signal Handler.