Transaction control functions

Defines
#define	sqlo_autocommit_on(_dbh)   sqlo_set_autocommit(_dbh, SQLO_ON)
	A macro used to set autocommit on.
#define	sqlo_autocommit_off(_dbh)   sqlo_set_autocommit(_dbh, SQLO_OFF)
	A macro used to set autocommit off.
Functions
int	sqlo_commit (sqlo_db_handle_t dbh)
	Commit.
int	sqlo_rollback (sqlo_db_handle_t dbh)
	Rollback.
int	sqlo_set_autocommit (sqlo_db_handle_t dbh, int on)
	sqlo_set_autocommit
int	sqlo_autocommit (sqlo_db_handle_t dbh)
	sqlo_autocommit

---

Define Documentation

#define sqlo_autocommit_off

(

_dbh

)

sqlo_set_autocommit(_dbh, SQLO_OFF)

A macro used to set autocommit off.

executes sqlo_set_autocommit( dbh, SQLO_OFF )

Parameters:

_dbh

I - A database handle.

See also:

sqlo_set_autocommit

Since:

Version 2.3.2

Definition at line 1252 of file sqlora.h.

#define sqlo_autocommit_on

(

_dbh

)

sqlo_set_autocommit(_dbh, SQLO_ON)

A macro used to set autocommit on.

executes sqlo_set_autocommit( dbh, SQLO_ON )

Parameters:

_dbh

I - A database handle.

See also:

sqlo_set_autocommit

Since:

Version 2.3.2

Definition at line 1239 of file sqlora.h.

---

Function Documentation

int sqlo_autocommit

(

sqlo_db_handle_t

dbh

)

sqlo_autocommit

Returns the state of the autocommit flag. Either SQLO_ON or SQLO_OFF

Parameters:

dbh

I - A database handle.

Returns:

• SQLO_ON
• SQLO_OFF
• SQLO_INVALID_DB_HANDLE

See also:

sqlo_set_autocommit

Since:

Version 2.3.2

int sqlo_commit

(

sqlo_db_handle_t

dbh

)

Commit.

Execute a commit on this database.

Parameters:

dbh

I - A database handle.

Returns:

• SQLO_SUCCESS
• < 0 on error

int sqlo_rollback

(

sqlo_db_handle_t

dbh

)

Rollback.

Execute a rollback on this database.

Parameters:

dbh

I - A database handle.

Returns:

• SQLO_SUCCESS
• < 0 on error

Examples:

ex16.c.

int sqlo_set_autocommit	(	sqlo_db_handle_t	dbh,
		int	on
	)

sqlo_set_autocommit

Set autocommit on the attached server on or off.

Autocommit is off by default.

Note:

If you change the setting, it is valid until you detach from the server (sqlo_server_detach or sqlo_finish). If you stay attached and change the session via sqlo_session_end and sqlo_session_begin, the autocommit setting is the same as before.

Parameters:

	dbh	I - A database handle.
	on	I - SQLO_ON or SQLO_OFF

Returns:

• SQLO_SUCCESS
• SQLO_INVALID_DB_HANDLE

See also:

sqlo_autocommit

Since:

Version 2.3.2

---