{{indexmenu_n>40}}
===== DB Adapter - variables =====

===== Predefined variables ======


  * **LastExecutionStartDate**: Last start time from current job,
  * **LastExecutionStartDateSerial**: From LastExecutionStartDate the date formatted as Interger: yyyyMMdd,
  * **LastExecutionStartTimeSerial**: Formatted by LastExecutionStartDate the time as Interger: HHmm,
  * **LastExecutionEndDate**: The time of the last completion of the current job,
  * **LastExecutionEndDateSerial**: From LastExecutionEndDate the date formatted as an interger: yyyyMMdd,
  * **LastExecutionEndTimeSerial**: The LastExecutionStartDat formats the time as Interger: HHmm,
  * **ExecuteEventId**: For the Web service, the URI of the request.
  * **ExecuteEventId**: For web service, the URI of the request.
  * **MaxRowsPerInsert**: Deprecated and incorrectly defined, corresponds to SqlMaxInsertSize.
  * **SqlMaxInsertSize**: Only for MS-SQL server, the number of characters for an insert statement. E.g. the default value 1024 stands for splitting the insert statement before its length exceeds 1024 characters.
  * **sqlcommandtimeout**: Define a Timeout for an SQL statement.
  * **dontuseupdatetransaction**: Do not issue an update statement.
  * **DontCheckCommitCount**: Do not consider the number of commits.

Variables in the backend job step can contain placeholders according to [[en:prozessdefinition:repositorien:kontainerisierer:mask|]], which are evaluated at runtime. 

This does not apply to:
  * eBiss.DbAdapter.ConnectionString and. 
  * eBiss.DbAdapter.ConnectionType.


Used Variables:
  * eBiss.DbAdapter.ConnectionString: the connection string
  * eBiss.DbAdapter.ConnectionType: the db type (in .NET connection type format), e.g. '**IBM.Data.DB2.DB2Connection**', '**System.Data.SqlClient.SqlConnection**'.
  * eBiss.DbAdapter.TraceSql: if this flag is set to true, you will get an extended tracing including full connection string.
  * eBiss.DbAdapter.MsSqlReadPast: If you set the Boolean variable to true, than **WITH(READPAST)** is appended to the SELECT. If the variable is of **type=Text**, then you can freely define the value attached to the SELECT, e. g. = "WITH (NOLOCK)".((If the variable is defined with **type=Text** and set to **MsSqlReadPast = 'WITH(NOLOCK)'** the result will be **SELECT ... WITH(NOLOCK)**.))
  * eBiss.DbAdapter.Execute.Afterconnect.1: **EXEC** is executed as the first statement.