Description of Transaction object properties – PB Docs 125

DBMS

String

The DBMS identifier for your connection.
For a complete list of the identifiers for the supported database
interfaces, see the online Help.

DBMS

Database

String

The name of the database to which you
are connecting.

Database Name

UserID

String

The name or ID of the user who connects
to the database.

User ID

DBPass

String

The password used to connect to the database.

Password

Lock

String

For those DBMSs that support the use
of lock values and isolation levels, the isolation level to use
when you connect to the database. For information about the lock
values you can set for your DBMS, see the description of the Lock
DBParm parameter in the online Help.

Isolation Level

LogID

String

The name or ID of the user who logs in
to the database server.

Login ID

LogPass

String

The password used to log in to the database
server.

Login Password

ServerName

String

The name of the server on which the database
resides.

Server Name

AutoCommit

Boolean

For those DBMSs that support it, specifies
whether PowerBuilder issues SQL statements
outside or inside the scope of a transaction. Values you can set
are:

• True

  PowerBuilder issues SQL statements outside the scope
  of a transaction; that is, the statements are not part of a logical
  unit of work (LUW). If the SQL statement succeeds,
  the DBMS updates the database immediately as if a COMMIT statement
  had been issued.

• False

  (Default) PowerBuilder issues SQL statements inside the
  scope of a transaction. PowerBuilder issues a BEGIN TRANSACTION statement
  at the start of the connection. In addition, PowerBuilder issues
  another BEGIN TRANSACTION statement after each COMMIT or ROLLBACK statement
  is issued.

For more information, see the AutoCommit description
in the online Help.

AutoCommit Mode

DBParm

String

Contains DBMS-specific connection parameters
that support particular DBMS features. For a description of each
DBParm parameter that PowerBuilder supports, see the chapter on setting
additional connection parameters in Connecting to Your Database.

DBPARM

SQLReturnData

String

Contains DBMS-specific information. For
example, after you connect to an Informix database and execute an
embedded SQL INSERT statement, SQLReturnData contains
the serial number of the inserted row.

—

SQLCode

Long

The success or failure code of the most
recent SQL operation. For details,
see “Error handling after
a SQL statement”.

—

SQLNRows

Long

The number of rows affected by the most
recent SQL operation. The database
vendor supplies this number, so the meaning may be different for
each DBMS.

—

SQLDBCode

Long

The database vendor’s error
code. For details, see “Error handling after
a SQL statement”.

—

SQLErrText

String

The text of the database vendor’s
error message corresponding to the error code. For details, see “Error handling after
a SQL statement”.

—