DTS parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (→‎Description: add link)
Line 16: Line 16:
==Description==
==Description==
<p>
<p>
Enables [[Adding a date-time stamp field#Overview of the date-time stamp feature|date/time stamp processing]] when set to 1. A system manager can reset <var>DTS</var> to zero to disable automatic date/time stamps. Turning off the date/time stamp feature does not imply that you cannot update any field, including the date/time stamp field; it simply stops automatic updates to the date/time stamp field.</p>
Enables [[Adding a date-time stamp field#Overview of the date-time stamp feature|date/time stamp processing]] when set to 1. As a system manager, you can reset <var>DTS</var> to zero to disable automatic date/time stamps. When DTS is zero, you can update a DTSFN field with values of your choosing.</p>


<table>
<table>
Line 30: Line 30:
</table>
</table>


<p>
<ul>
The <var>DTS</var> parameter may be reset only by a user with system manager privileges. In addition, the user must have file manager privileges for any DTS-enabled (<var>[[FOPT parameter|FOPT]]</var> X'10') files opened, either before or after <var>DTS</var> is reset to 0. Turning off the <var>DTS</var> parameter affects updates only to date/time stamp files, so no special restrictions were placed on the file with no date/time stamp.</p>
<li>You must be a system manager to reset the <var>DTS</var> parameter. You can reset <var>DTS</var> for your thread only.
<li>When <var>DTS</var> is reset to 0, any open files with the <var>[[FOPT_parameter|FOPT]]</var> parameter X'10' bit on must have been opened with file manager privileges.
<li>If the value of the <var>DTS</var> parameter is 0 on a thread, subsequent opens of <var>FOPT</var> X'10' files must obtain file manager privileges.
</ul>


<p class="note"><b>Note:</b> During <var>[[FLOD command|FLOD]]</var>/<var>[[FILELOAD command|FILELOAD]]</var>, the DTS field, if one is defined to the file, is not updated. This means that a new DTS field defined as part of a file reorganization will not have a value calculated during the reorganization.  Existing DTS fields are only added from TAPEI input, and they are not automatically updated by the DTS feature.</p>
<p class="note"><b>Note:</b> During <var>[[FLOD command|FLOD]]</var>/<var>[[FILELOAD command|FILELOAD]]</var>, the DTS field, if one is defined to the file, is not updated. This means that a new DTS field defined as part of a file reorganization will not have a value calculated during the reorganization.  Existing DTS fields are only added from TAPEI input, and they are not automatically updated by the DTS feature.</p>

Revision as of 20:02, 1 August 2017

Date time stamp updates (1=automatic, 0=bypassed)

Summary

Default value
1
Parameter type
User
Where set
Reset by system manager
Related products
All
Introduced
Model 204 V7.1

Description

Enables date/time stamp processing when set to 1. As a system manager, you can reset DTS to zero to disable automatic date/time stamps. When DTS is zero, you can update a DTSFN field with values of your choosing.

Value Behavior
1 For date/time stamp files, transactions participate in DTS updating. The date/time stamp field of an updated record is automatically updated at the beginning of COMMIT processing.

This is the default setting for the parameter.

0 Transactions do not participate in DTS updating. When a transaction does not participate in DTS processing, the date/time stamp field will not be updated on records that are themselves updated.
  • You must be a system manager to reset the DTS parameter. You can reset DTS for your thread only.
  • When DTS is reset to 0, any open files with the FOPT parameter X'10' bit on must have been opened with file manager privileges.
  • If the value of the DTS parameter is 0 on a thread, subsequent opens of FOPT X'10' files must obtain file manager privileges.

Note: During FLOD/FILELOAD, the DTS field, if one is defined to the file, is not updated. This means that a new DTS field defined as part of a file reorganization will not have a value calculated during the reorganization. Existing DTS fields are only added from TAPEI input, and they are not automatically updated by the DTS feature.

Usage

  • If DTS is 0, your user thread does no date/time stamp processing on any file. To turn DTS processing off for a file, you must stop the file and turn off the FOPT X'10' bit. This suspends date/time stamp processing for this file for all users.

    Currently, there is no feature that can suspend date/time processing for some files for some users.

  • DTS is not supported under Parallel Query Option. If you attempt a remote open of a data/time stamp file (FOPT X'10' included), the following message is issued:

    M204.1977: %F MAY NOT BE ACCESSED REMOTELY

See also