DBTASKID function

Returns an INTEGER value that uniquely identifies a database’s transaction.

Syntax


DBTASKID ( `integer-expression` \| `logical-name` \| `alias` )

integer-expression

The sequence number of a database the ABL session is connected to. For example, DBTASKID(1) returns information on the first database the ABL session is connected to, DBTASKID(2) returns information on the second database the ABL session is connected to, etc. If you specify a sequence number that does not correspond to a database the ABL session is connected to, the DBTASKID function returns the Unknown value (?).

logical-name or alias

A character expression that evaluates to the logical name or alias of a database that is connected to the current ABL session. If the character expression does not evaluate to the logical name or alias of a connected database, DBTASKID returns the Unknown value (?).

Note: You must enclose all character strings in quotes.

Notes

If the application is not in a transaction, DBTASKID returns the Unknown value (?).

If the client is connected to two databases and both databases participate in the transaction, DBTASKID does not necessarily return the same value for each database. The value DBTASKID returns for a database is for that database only.

DBTASKID does not support Progress databases prior to Progress Version 8. DBTASKID returns the Unknown value (?) for DataServers, Version 7 Progress databases, and the temp-table database.

DBTASKID is designed for database replication. When you create a log record for a transaction, you can call DBTASKID and store the transaction ID. When you load the transaction, you can group log records by transaction ID. For more information on database replication, see OpenEdge Data Management: Database Administration, and the reference entry for the RAW-TRANSFER statement.