DataBasic Reference > Statements and Intrinsic Functions > T > TRANSEND Statement

Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

TRANSEND Statement (DataBasic) (m618703+transend_s.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

TRANSEND Statement

Commits a transaction.

Syntax

TRANSEND {transaction-information} [THEN statement(s) ELSE statement(s)]

Syntax Elements

transaction-information
Optional text to be saved in the transaction-end record. It can be used to identify a particular transaction or iteration of a repetitive transaction. transaction-information can be text within double quotes or a variable.

If you are using Transaction Logging, transaction-information can be used when listing a clean log or during a TL-RESTORE.

You can use transaction-information only if Transaction Logging is installed and enabled.  transaction-information is not used in Transaction Handling.

statement(s) Either a THEN or an ELSE clause (or both). A statement must be included. The THEN clause is executed if the commit is successful. The ELSE clause is executed if the transaction end fails. One cause of such a failure would be when no transaction is active.

Operation

If no transaction-information parameter is supplied, the file-name and item-id containing the program performing the transaction along with the time and date is substituted.

Item locks that are released within a transaction boundary are held until successful execution of the TRANSEND statement.

Comments

Text is only written to the clean log if there is something in the transaction. So if you do TRANSTART then TRANSEND with nothing between, the TRANSTART/TRANSEND is not written to the log.

RealityV15.0Comment on this topic