Adding a date-time stamp field - Revision history

ELowell: /* Overview of the date-time stamp feature */

2016-02-01T22:05:34Z

Overview of the date-time stamp feature

← Older revision		Revision as of 22:05, 1 February 2016
Line 12:		Line 12:
	The date-time stamp (DTS) feature in <var class="product">Model 204</var> can track when records are modified. Except for <var>DELETE RECORD(S)</var> processing, all other updates are captured, including those made by BATCH204 and ONLINE jobs. From <var class="product">Model 204</var> V7.4 onwards, updates performed by IFAM applications are also captured.</p>		The date-time stamp (DTS) feature in <var class="product">Model 204</var> can track when records are modified. Except for <var>DELETE RECORD(S)</var> processing, all other updates are captured, including those made by BATCH204 and ONLINE jobs. From <var class="product">Model 204</var> V7.4 onwards, updates performed by IFAM applications are also captured.</p>
	<p>		<p>
	The default date-time stamp string uses the operating system timestamp value, in this format: <code>CCYYMMDDHHMMSSMMM</code>. If your site prefers a different field value or a different data format, ~~consult the appropriate Rocket Model 204~~ [[~~:Category: Installation\|installation page]] in order to customize the date-~~time stamp field ~~name and to activate the date-~~time stamp ~~feature~~.</p>		The default date-time stamp string uses the operating system timestamp value, in this format: <code>CCYYMMDDHHMMSSMMM</code>. If your site prefers a different field value or a different data format, see [[DEFINE FIELD command#Date/time stamp field\|Date/time stamp field]].</p>

	<p>Also of note:</p>		<p>Also of note:</p>

ELowell: /* Overview of the date-time stamp feature */

2016-02-01T21:35:10Z

Overview of the date-time stamp feature

← Older revision		Revision as of 21:35, 1 February 2016
Line 12:		Line 12:
	The date-time stamp (DTS) feature in <var class="product">Model 204</var> can track when records are modified. Except for <var>DELETE RECORD(S)</var> processing, all other updates are captured, including those made by BATCH204 and ONLINE jobs. From <var class="product">Model 204</var> V7.4 onwards, updates performed by IFAM applications are also captured.</p>		The date-time stamp (DTS) feature in <var class="product">Model 204</var> can track when records are modified. Except for <var>DELETE RECORD(S)</var> processing, all other updates are captured, including those made by BATCH204 and ONLINE jobs. From <var class="product">Model 204</var> V7.4 onwards, updates performed by IFAM applications are also captured.</p>
	<p>		<p>
	The default date-time stamp string uses the operating system timestamp value, in this format: <code>CCYYMMDDHHMMSSMMM</code>. If your site prefers a different field value or a different data format, consult ~~your~~ Rocket Model 204 installation ~~guide~~ in order to customize the date-time stamp field name and to activate the date-time stamp feature.</p>		The default date-time stamp string uses the operating system timestamp value, in this format: <code>CCYYMMDDHHMMSSMMM</code>. If your site prefers a different field value or a different data format, consult the appropriate Rocket Model 204 [[:Category: Installation\|installation page]] in order to customize the date-time stamp field name and to activate the date-time stamp feature.</p>

	<p>Also of note:</p>		<p>Also of note:</p>

JAL: misc cleanup

2015-04-17T21:37:49Z

misc cleanup

← Older revision		Revision as of 21:37, 17 April 2015
Line 1:		Line 1:
	<p>		<p>
	You can add a <var class="term">date-time stamp</var> field to some of your files to keep track of when records in the file were last modified. This is done by setting the X'10' bit <var>[[FOPT parameter\|FOPT]]</var> for the files in which you want the timestamps, and by designating a date-time stamp fieldname, which can be done with the <var>[[DTSFN parameter\|DTSFN]]</var> parameter. When a file's <var>FOPT</var> X'10' bit is set, the date-time stamp field is updated for each record that was updated in a transaction. Applications can then use the data in the date-time stamp field to find and process all the records that were changed.</p>		You can add a <var class="term">date-time stamp</var> field to some of your files to keep track of when records in the file were last modified. This is done by setting the X'10' bit <var>[[FOPT parameter\|FOPT]]</var> for the files in which you want the timestamps, and by designating a date-time stamp fieldname, which can be done with the <var>[[DTSFN parameter\|DTSFN]]</var> parameter. When a file's <var>FOPT</var> X'10' bit is set, the date-time stamp field is updated for each record that was updated in a transaction. Applications can then use the data in the date-time stamp field to find and process all the records that were changed.</p>
	<p>An application that processes these records can track the date-time stamp field values that have been processed to date, or it may take another action, including updating the date-time stamp field.</p>
	<p>		<p>
	~~The~~ date-time stamp ~~feature works only in files created in V7R1.0~~ or ~~later~~.</p>		An application that processes these records can track the date-time stamp field values that have been processed to date, or it may take another action, including updating the date-time stamp field.</p>
	<p>		<p>
			The date-time stamp feature works only in files created in V7R1.0 or later.
	(Under V6R1.0, DTS enabled files can be opened, and DTS fields read like any other, but no automatic updates to DTS fields will take place.)</p>		(Under V6R1.0, DTS enabled files can be opened, and DTS fields read like any other, but no automatic updates to DTS fields will take place.)</p>
	<p class="note"><b>Note:</b> There is no support in PQO/204 for the date/time stamp feature.</p>		<p class="note"><b>Note:</b> There is no support in PQO/204 for the date/time stamp feature.</p>
Line 10:		Line 10:
	==Overview of the date-time stamp feature==		==Overview of the date-time stamp feature==
	<p>		<p>
	The date-time stamp (DTS) feature in <var class="product">Model 204</var> can track when records are modified. </p>		The date-time stamp (DTS) feature in <var class="product">Model 204</var> can track when records are modified. Except for <var>DELETE RECORD(S)</var> processing, all other updates are captured, including those made by BATCH204 and ONLINE jobs. From <var class="product">Model 204</var> V7.4 onwards, updates performed by IFAM applications are also captured.</p>
	<p>		<p>
	Except for DELETE RECORD(S) processing, all other updates are captured, including those made by BATCH204 and ONLINE jobs. From V7R4.0 onwards, updates performed by IFAM applications are also captured.</p>		The default date-time stamp string uses the operating system timestamp value, in this format: <code>CCYYMMDDHHMMSSMMM</code>. If your site prefers a different field value or a different data format, consult your Rocket Model 204 installation guide in order to customize the date-time stamp field name and to activate the date-time stamp feature.</p>

	~~<p>~~The default date-time stamp string uses the operating system timestamp value, in this format: <code>CCYYMMDDHHMMSSMMM</code>.
	If your site prefers a different field value or a different data format, consult your Rocket Model 204 installation guide in order to customize the date-time stamp field name and to activate the date-time stamp feature.</p>

	<p>Also of note:</p>		<p>Also of note:</p>
Line 21:		Line 18:
	<li>The DTS feature is implemented on a file-by-file basis.</li>		<li>The DTS feature is implemented on a file-by-file basis.</li>

	<li>Precision and accuracy of the date-time stamp is to the millisecond when you use the date-time stamp feature as delivered. To ensure optimal searching using the date-time stamp field, define it as ORDERED CHARACTER. (The length of this field value is 17 bytes.)</li>		<li>Precision and accuracy of the date-time stamp is to the millisecond when you use the date-time stamp feature as delivered. To ensure optimal searching using the date-time stamp field, define it as <var>ORDERED CHARACTER</var>. (The length of this field value is 17 bytes.)</li>

	<li>While it should not be updated directly, you can read and display the date-time stamp as you can any other field. ~~User Language~~ and IFAM can both be used to find and display date-time stamp field data.</li>		<li>While it should not be updated directly, you can read and display the date-time stamp as you can any other field. SOUL and IFAM can both be used to find and display date-time stamp field data.</li>

	<li>The date-time stamp field is updated at the beginning of commit processing when a new record is stored or an existing record is updated: changes, inserts, or deletes to fields or fieldgroups.</li>		<li>The date-time stamp field is updated at the beginning of commit processing when a new record is stored or an existing record is updated: changes, inserts, or deletes to fields or fieldgroups.</li>
Line 36:		Line 33:
	Since the date-time stamp field is a normal <var class="product">Model 204</var> field, all methods of extraction may be used.</p>		Since the date-time stamp field is a normal <var class="product">Model 204</var> field, all methods of extraction may be used.</p>

	===Date-time stamp field in ~~User Language~~===		===Date-time stamp field in SOUL===
	<p>		<p>
	The date-time stamp field can be:</p>		The date-time stamp field can be:</p>
	<ul>		<ul>
	<li>Read and printed either as a field name reference or through a $function.</li>		<li>Read and printed either as a field name reference or through a $function.</li>
	<li>Searched in normal FIND statements.</li>		<li>Searched in normal <var>FIND</var> statements.</li>
	<li>Assigned to %variables or other fields.</li>		<li>Assigned to %variables or other fields.</li>
	<li>Printed as supported for all <var class="product">Model 204</var> fields, including a PAI statement.</li>		<li>Printed as supported for all <var class="product">Model 204</var> fields, including a <var>PAI</var> statement.</li>
	</ul>		</ul>

	===Date-time stamp field and OPEN processing===		===Date-time stamp field and OPEN processing===
	<p>		<p>
	If the specified date-time stamp field name is not defined in a date-time stamp file, an OPEN command is rejected. If the date-time stamp field name is DATE.TIMESTAMP, for example, the following messages are issued:</p>		If the specified date-time stamp field name is not defined in a date-time stamp file, an <var>[[OPEN FILE command\|OPEN]]</var> command is rejected. If the date-time stamp field name is <code>DATE.TIMESTAMP</code>, for example, the following messages are issued:</p>
	<p class="code">> OPEN DTSFILE		<p class="code"><b>> OPEN DTSFILE</b>
	<b></b>*** 1 M204.1265: NO SUCH FIELD NAME. FIELD = DATE.TIMESTAMP		<b></b>*** 1 M204.1265: NO SUCH FIELD NAME. FIELD = DATE.TIMESTAMP
	<b></b>*** M204.2730: DATE/TIME STAMP FILE, BUT DTSFN NOT DEFINED IN FILE		<b></b>*** M204.2730: DATE/TIME STAMP FILE, BUT DTSFN NOT DEFINED IN FILE
Line 56:		Line 53:
	</p>		</p>
	<p>		<p>
	If you do not set the <var>DTSFN</var> system parameter, files with the <var>[[FOPT parameter\|FOPT]]</var> X'10' bit cannot be opened. An <var>[[OPEN ~~FILE command\|OPEN]]~~</var> command will not be processed and the following message is issued:</p>		If you do not set the <var>DTSFN</var> system parameter, files with the <var>[[FOPT parameter\|FOPT]]</var> X'10' bit cannot be opened. An <var>OPEN</var> command will not be processed, and the following message is issued:</p>
	<p class="code">M204.2729: DATE/TIME STAMP FILE, BUT DTSFN UNSPECIFIED IN RUN		<p class="code">M204.2729: DATE/TIME STAMP FILE, BUT DTSFN UNSPECIFIED IN RUN
	</p>		</p>
Line 91:		Line 88:
	If there is no <var>COMMIT</var> in the first request or if the file is not closed after the first request, then the date-time stamp field is not updated.</p>		If there is no <var>COMMIT</var> in the first request or if the file is not closed after the first request, then the date-time stamp field is not updated.</p>
	<p>		<p>
	If the same ~~User Language~~ requests are executed as separate procedures, the date-time stamp field is updated. </p>		If the same SOUL requests are executed as separate procedures, the date-time stamp field is updated. </p>

	==Suspending date-time stamp updates==		==Suspending date-time stamp updates==
Line 101:		Line 98:
	A user with system manager privileges can exclude date-time stamp files from DTS processing, suspending DTS updates for that user's thread. The user's thread does no date-time stamp processing on any file.</p>		A user with system manager privileges can exclude date-time stamp files from DTS processing, suspending DTS updates for that user's thread. The user's thread does no date-time stamp processing on any file.</p>
	<p>		<p>
	To suspend DTS updates, reset the <var>[[DTS parameter\|DTS]]</var> parameter to 0. When DTS=0, the user can update any field, including the date-time stamp field, without automatically updating the date-time stamp field.</p>		To suspend DTS updates, reset the <var>[[DTS parameter\|DTS]]</var> parameter to 0. When <code>DTS=0</code>, the user can update any field, including the date-time stamp field, without automatically updating the date-time stamp field.</p>
	<p>		<p>
	To reset the <var>DTS</var> parameter, ~~the user~~ must have system manager privileges. ~~The user~~ must also have file manager privileges for any DTS-enabled files opened, either before or after DTS is reset to 0.</p>		To reset the <var>DTS</var> parameter, you must have system manager privileges. You must also have file manager privileges for any DTS-enabled files opened, either before or after <var>DTS</var> is reset to 0.</p>
	<p class="note"><b>Note:</b> Automatic date-time stamp field updates are still performed for updates made to the files by other user threads with <var>DTS</var> set to 1.</p>		<p class="note"><b>Note:</b> Automatic date-time stamp field updates are still performed for updates made to the files by other user threads with <var>DTS</var> set to 1.</p>

	===Suspending all updates for a file===		===Suspending all updates for a file===
	<p>		<p>
	To disable all date-time stamp processing for a specific file, turn off the <var>FOPT</var> parameter X'10' bit on the command line or ~~by using~~ the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>		To disable all date-time stamp processing for a specific file, turn off the <var>FOPT</var> parameter X'10' bit on the command line, or use the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>

			==See also==
			<p>
			For system management considerations of DTS fields, see [[Setting up the date-time stamp field]]. </p>

	[[Category:Model 204 files]]		[[Category:Model 204 files]]

JAL at 20:10, 23 July 2014

2014-07-23T20:10:44Z

Show changes

Dme: /* Suspending all updates for a file */

2014-05-10T01:59:07Z

Suspending all updates for a file

← Older revision		Revision as of 01:59, 10 May 2014
Line 79:		Line 79:
	<p>To disable all date-time stamp processing for a specific file, turn off the <var>[[FOPT parameter\|FOPT]]</var> parameter X'10' bit on the command line or by using the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>		<p>To disable all date-time stamp processing for a specific file, turn off the <var>[[FOPT parameter\|FOPT]]</var> parameter X'10' bit on the command line or by using the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>

	~~[[Category:File management]]~~
	[[Category:Model 204 files]]		[[Category:Model 204 files]]

Dme: Undo revision 69263 by DmeWiccan (talk)

2014-05-09T22:47:07Z

Undo revision 69263 by DmeWiccan (talk)

← Older revision		Revision as of 22:47, 9 May 2014
Line 79:		Line 79:
	<p>To disable all date-time stamp processing for a specific file, turn off the <var>[[FOPT parameter\|FOPT]]</var> parameter X'10' bit on the command line or by using the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>		<p>To disable all date-time stamp processing for a specific file, turn off the <var>[[FOPT parameter\|FOPT]]</var> parameter X'10' bit on the command line or by using the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>

	[[Category:~~Model 204 files~~]]		[[Category:File management]]
	[[Category:Model 204 files]]		[[Category:Model 204 files]]

DmeWiccan: Automatically generated page update

2014-05-09T22:45:33Z

Automatically generated page update

← Older revision		Revision as of 22:45, 9 May 2014
Line 79:		Line 79:
	<p>To disable all date-time stamp processing for a specific file, turn off the <var>[[FOPT parameter\|FOPT]]</var> parameter X'10' bit on the command line or by using the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>		<p>To disable all date-time stamp processing for a specific file, turn off the <var>[[FOPT parameter\|FOPT]]</var> parameter X'10' bit on the command line or by using the [[Creating a file with FILEMGMT#Defining file organization\|File Management Subsystem facility]]. Turning off this bit disables date-time stamp updates made by all users of that file.</p>

	[[Category:~~File management~~]]		[[Category:Model 204 files]]
	[[Category:Model 204 files]]		[[Category:Model 204 files]]

Dme at 22:26, 9 May 2014

2014-05-09T22:26:46Z

← Older revision		Revision as of 22:26, 9 May 2014
Line 80:		Line 80:

	[[Category:File management]]		[[Category:File management]]
			[[Category:Model 204 files]]

Dme at 13:32, 9 May 2014

2014-05-09T13:32:01Z

← Older revision		Revision as of 13:32, 9 May 2014
Line 1:		Line 1:
	<p>You can add a <var class="term">date-time stamp</var> field to some of your files to keep track of when records in the file were last modified. This is done by setting the X'10' bit <var>[[FOPT parameter\|FOPT]]</var> for the files in which you want the timestamps, and by designating a date-time stamp fieldname, which can be done with the <var>[[DTSFN pararameter\|DTSFN]]</var> parameter. When a file's <var>FOPT</var> X'10' bit is set, the date-time stamp field is updated for each record that was updated in a transaction. ~~You~~ can then use the data in the date-time stamp field ~~in your applications~~ to find and process all the ~~rows of data~~ that were changed.</p>		<p>You can add a <var class="term">date-time stamp</var> field to some of your files to keep track of when records in the file were last modified. This is done by setting the X'10' bit <var>[[FOPT parameter\|FOPT]]</var> for the files in which you want the timestamps, and by designating a date-time stamp fieldname, which can be done with the <var>[[DTSFN pararameter\|DTSFN]]</var> parameter. When a file's <var>FOPT</var> X'10' bit is set, the date-time stamp field is updated for each record that was updated in a transaction. Applications can then use the data in the date-time stamp field to find and process all the records that were changed.</p>
	<p>An application that processes these records can track the date-time stamp field values that have been processed to date, or it may take another action, including updating the date-time stamp field.</p>		<p>An application that processes these records can track the date-time stamp field values that have been processed to date, or it may take another action, including updating the date-time stamp field.</p>
	<p>The date-time stamp feature works only in files created in V7R1.0 or later.</p>		<p>The date-time stamp feature works only in files created in V7R1.0 or later.</p>

Dme at 13:30, 9 May 2014

2014-05-09T13:30:58Z

← Older revision		Revision as of 13:30, 9 May 2014
Line 1:		Line 1:
	<p>You can add a <var class="term">date-time stamp</var> field to some of your files to keep track of when records in the file were last modified. This is done by setting the X'10' bit <var>[[FOPT parameter\|FOPT]]</var> for the files in which you want the timestamps, and by designating a date-time stamp fieldname, which can be done with the <var>[[DTSFN pararameter\|DTSFN]]</var> parameter. When a file's <var>FOPT</var> X'10' bit is set, the date-time stamp field is updated for each record that was updated in a transaction. You can then use the data in the date-time stamp field in ~~an end-user written application~~ to find and process all the rows of data that were changed.</p>		<p>You can add a <var class="term">date-time stamp</var> field to some of your files to keep track of when records in the file were last modified. This is done by setting the X'10' bit <var>[[FOPT parameter\|FOPT]]</var> for the files in which you want the timestamps, and by designating a date-time stamp fieldname, which can be done with the <var>[[DTSFN pararameter\|DTSFN]]</var> parameter. When a file's <var>FOPT</var> X'10' bit is set, the date-time stamp field is updated for each record that was updated in a transaction. You can then use the data in the date-time stamp field in your applications to find and process all the rows of data that were changed.</p>
	<p>An application that processes these records can track the date-time stamp field values that have been processed to date, or it may take another action, including updating the date-time stamp field.</p>		<p>An application that processes these records can track the date-time stamp field values that have been processed to date, or it may take another action, including updating the date-time stamp field.</p>
	<p>The date-time stamp feature works only in files created in V7R1.0 or later.</p>		<p>The date-time stamp feature works only in files created in V7R1.0 or later.</p>