DB_TRANS_OPEN action

The action establishes a new Connection to a database.

If the timeoutSec_Int parameter is set to a non-zero value, all commands that take longer will be aborted, and the extended error information will return the USER_EXPIR_TIME error in the _ERR_NR_TRANS_EX variable. This behavior is currently implemented only for the PostgreSQL database.

DB_TRANS_OPEN dbObjIdent, handleIdent_Int, retCodeIdent_Int [TIMEOUT timeoutSec_Int]

dbObjIdent	in	Reference to an object of Database type.
handleIdent_Int	out	Identifier - the unique number (handle) of a Connection.
retCodeIdent_Int	out	Return code identifier.
timeoutSec_Int	in	Identifier - command timeout in seconds.

The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.
Note: The maximum number of connections configured on the Database object can be limited by the Maximum connections parameter, with a value of 0 disabling the limitation. If the D2000 DBManager process consumes all connections, subsequent calls to DB_TRANS_OPEN attempting to establish a connection will return the error DBM_MAX_CONNECTIONS in the variable _ERR_NR_TRANS_EX.

Identifier for a number (handle) of the Connection, is used for: 

• the following operations of CONNECT type to a table (DB_, PG_, SQL_).
• the actions 
  • DB_TRANS_COMMIT
  • DB_TRANS_ROLLBACK
  • DB_TRANS_CLOSE

 Return code describes the action success (__ERR_NO_ERROR).

Database transactions.

DB_TRANS_COMMIT
DB_TRANS_ROLLBACK
DB_TRANS_CLOSE

DB_CONNECT
DB_DELETE
DB_DISCONNECT
DB_INSERT
DB_INSUPD
DB_READ
DB_READ_BLOB
DB_UPDATE
DB_UPDATE_BLOB

PG_CONNECT
PG_DISCONNECT
PG_READ
PG_INSERT
PG_DELETE
PG_UPDATE

SQL_CONNECT
SQL_DISCONNECT
SQL_EXEC_DIRECT
SQL_EXEC_PROC

SQL_PREPARE
SQL_BINDIN
SQL_FETCH
SQL_FREE

All database related actions.