This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.2)
DatabaseLink Transactions and Result Sets
DatabaseLink supports SQL transactions and result sets. These features, useful for advanced users, help to maintain integrity of the data stored in your database as well as increasing efficiency.
SQLBeginTransaction mark the beginning of an SQL transaction
SQLCommitTransaction commit a transaction, making the changes permanent
SQLRollbackTransaction revert changes since the beginning of the transaction
SQLSetSavepoint mark a savepoint in a transaction
Result Sets
SQLResultSetOpen make a result set from an SQL query
SQLResultSetRead read from a result set (shifts the current position)
SQLResultSetCurrent, SQLResultSetTake read from a result set (without shifting)
SQLResultSetGoto, SQLResultSetShift change position in a result set