String
Current date
Purpose
The SetZeroTimeStamp parameter determines the date portion of the value that is output to the RDBMS for a mapped property or method that returns a zero
On SQL Server, a JADE TimeStamp value is mapped to a DATETIME value. If the JADE TimeStamp value is zero, the value of the date portion of the DATETIME value depends on the setting for the SetZeroTimeStamp parameter as shown in the following table.
Value | Result |
---|---|
<default> | The date portion of the DATETIME value set to the current date. |
<basedate> | The date portion of the DATETIME value set to the RDBMS base date. For SQL Server, the base date is 1/01/1900. |
<null> | The column is set to null. |
The SetZeroTimeStamp parameter is not created or updated by the RPS Manager application.
Parameter is read when …
The Datapump application is started.
Applicable to database role or subrole…
RPS node only, or a primary SDS node when extracting RPS data.