DTS parameter: Difference between revisions
| 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. System managers can reset <var>DTS</var> to | Enables [[Adding a date-time stamp field#Overview of the date-time stamp feature|date/time stamp processing]] when set to 1. System managers can reset <var>DTS</var> to 0 to disable automatic date/time stamps. When DTS is 0, if you have file manager privileges, you can update a DTSFN field with values of your choosing.</p> | ||
<table> | <table> | ||
| Line 32: | Line 32: | ||
<ul> | <ul> | ||
<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>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> | <li>When you are resetting <var>DTS</var> 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, or the RESET DTS will fail. | ||
<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. | <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, or the OPEN FILE <var class="term">filename</var> will fail. | ||
</ul> | </ul> | ||
Revision as of 21:44, 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. System managers can reset DTS to 0 to disable automatic date/time stamps. When DTS is 0, if you have file manager privileges, 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 you are resetting DTS to 0, any open files with the FOPT parameter X'10' bit on must have been opened with file manager privileges, or the RESET DTS will fail.
- If the value of the DTS parameter is 0 on a thread, subsequent opens of FOPT X'10' files must obtain file manager privileges, or the OPEN FILE filename will fail.
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