SirDBA - Revision history

JAL: replace example section content with template

2018-02-09T20:19:39Z

replace example section content with template

JAL: link repair

2018-02-08T22:33:17Z

link repair

← Older revision		Revision as of 22:33, 8 February 2018
Line 229:		Line 229:
	<li>As values to check for field type mapping</li>		<li>As values to check for field type mapping</li>

	<li>To display the current date, as returned by the TIME SVC, modified by the SYSDATE parameter or ~~the~~ the Sir2000 User Language Tools APPDATE clock, as page headers in various end-user displays</li>		<li>To display the current date, as returned by the TIME SVC, modified by the SYSDATE parameter or the Sir2000 User Language Tools [[The Sir2000 APPDATE command#Setting clocks with the APPDATE command\|APPDATE clock]], as page headers in various end-user displays</li>
	</ul>		</ul>
	<p>		<p>
Line 255:		Line 255:
	<li><var class="product">[[Media:SirfieldNew.pdf\|Sir2000 Field Migration Facility]]</var> </li>		<li><var class="product">[[Media:SirfieldNew.pdf\|Sir2000 Field Migration Facility]]</var> </li>

	<li><var class="product">[[~~Media:Ul2krNew.pdf\|~~Sir2000 User Language Tools]]</var> </li>		<li><var class="product">[[Sir2000 User Language Tools]]</var> </li>
	</ul>		</ul>
	<!-- Note: all the above products embed the SCRIPT file COMDATE except Janus Web -->		<!-- Note: all the above products embed the SCRIPT file COMDATE except Janus Web -->

JAL: /* Datetime and format examples */ minor formatting

2018-01-29T21:47:59Z

Datetime and format examples: minor formatting

← Older revision		Revision as of 21:47, 29 January 2018
Line 485:		Line 485:
	</ul></td></tr>		</ul></td></tr>

	<tr><th>Wkday, DAY Month YYYY "A"T HH:MI</th>		<tr><th nowrap>Wkday, DAY Month YYYY "A"T HH:MI</th>
	<td>This is a format that would be quite unlikely in a file, but the value <code>Friday, 7 February 1998 AT 21:33</code> matches this format.		<td>This is a format that would be quite unlikely in a file, but the value <code>Friday, 7 February 1998 AT 21:33</code> matches this format.
	<p>Notes:</p>		<p>Notes:</p>

JAL: /* Datetime processing considerations */ typo

2018-01-24T21:52:35Z

Datetime processing considerations: typo

← Older revision		Revision as of 21:52, 24 January 2018
Line 221:		Line 221:
	==Datetime processing considerations==		==Datetime processing considerations==
	<p>		<p>
	This ~~sectioin~~ presents date processing issues, including usage of SirDBA past the year 1999, an explanation of its processing of dates, and any rules and restrictions you must follow to achieve correct results using date values with SirDBA.</p>		This section presents date processing issues, including usage of SirDBA past the year 1999, an explanation of its processing of dates, and any rules and restrictions you must follow to achieve correct results using date values with SirDBA.</p>
	<p>		<p>
	SirDBA uses dates in the following ways:</p>		SirDBA uses dates in the following ways:</p>

JAL: typo

2018-01-24T21:50:05Z

typo

← Older revision		Revision as of 21:50, 24 January 2018
Line 1:		Line 1:
	==Overview==		==Overview==
	SirDBA maps the fields in Model 204 files and groups onto standard data types, and it stores the mappings in a database file. When a field is selected from the <var class="product">SirDBA</var> field		SirDBA maps the fields in Model 204 files and groups onto standard data types, and it stores the mappings in a database file. When a field is selected from the <var class="product">SirDBA</var> field
	display, you are launched into [[SirPro]]'s string search facility to hunt for procedures that		display, you are launched into [[SirPro]]'s string search facility to hunt for procedures that reference the specified field name.
	reference the specified field name.

	<var class="product">SirDBA</var> is designed to assist in database conversions, and for conversions involving a large volume of changes to User Language code, when the changes are centered around Model 204 field names.		<var class="product">SirDBA</var> is designed to assist in database conversions, and for conversions involving a large volume of changes to User Language code, when the changes are centered around Model 204 field names.

	For Year 2000 conversion, <var class="product">SirDBA</var> goes to extra lengths to determine when a field		For Year 2000 conversion, <var class="product">SirDBA</var> goes to extra lengths to determine when a field contains date data. When it does, <var class="product">SirDBA</var> stores a datatype of DATETIME and a format
	contains date data. When it does, <var class="product">SirDBA</var> stores a datatype of DATETIME and a format
	specification of the datetime field.		specification of the datetime field.

Line 240:		Line 238:
	The representation of a date is determined by a <b>datetime format</b>. This value is a character string, composed of the concatenation of tokens (for example, "YYYY" for a four-digit year, and "MI" for minutes) and separator characters (for example, "/" in "MM/DD/YY" for two-digit month, day, and year separated by slashes).</p>		The representation of a date is determined by a <b>datetime format</b>. This value is a character string, composed of the concatenation of tokens (for example, "YYYY" for a four-digit year, and "MI" for minutes) and separator characters (for example, "/" in "MM/DD/YY" for two-digit month, day, and year separated by slashes).</p>
	<p>		<p>
	These datetime format strings are used in several Rocket Model 204 add-on products in addition to <var class="product">~~Fast/Unload~~</var>.		These datetime format strings are used in several Rocket Model 204 add-on products in addition to <var class="product">SirDBA</var>. The additional products using datetime format strings are: </p>
	The additional products using datetime format strings are: </p>
	<ul>		<ul>
	<li><var class="product">[[Media:~~JocliNew~~.pdf\|Janus Open Client]]</var> </li>		<li><var class="product">[[Fast/Unload]]</var> </li>

			<li><var class="product">[[Media:JoclrNew.pdf\|Janus Open Client]]</var> </li>

	<li><var class="product">[[Media:JosrvrNew.pdf\|Janus Open Server]]</var>		<li><var class="product">[[Media:JosrvrNew.pdf\|Janus Open Server]]</var>
Line 251:		Line 250:

	<li><var class="product">[[Janus Web Server]]</var> </li>		<li><var class="product">[[Janus Web Server]]</var> </li>

	~~<li><var class="product">[[Media:DbarNew.pdf\|SirDBA]]</var> </li>~~

	<li><var class="product">[[Release notes for Model 204 version 7.5#Former Sirius $functions\|Sirius Functions]]</var> </li>		<li><var class="product">[[Release notes for Model 204 version 7.5#Former Sirius $functions\|Sirius Functions]]</var> </li>
Line 260:		Line 257:
	<li><var class="product">[[Media:Ul2krNew.pdf\|Sir2000 User Language Tools]]</var> </li>		<li><var class="product">[[Media:Ul2krNew.pdf\|Sir2000 User Language Tools]]</var> </li>
	</ul>		</ul>
	<!-- Note: all the above products ~~imbed~~ the SCRIPT file COMDATE except Janus Web -->		<!-- Note: all the above products embed the SCRIPT file COMDATE except Janus Web -->
	<p>		<p>
	The rules for these <b>datetime format</b> strings are consistent throughout all these products, though certain uses of these strings might impose extra restrictions. For example, a leading blank may match an the <var>HH</var>, <var>DD</var>, and <var>MM</var> token in SirDBA, but it may not in some cases in other products.</p>		The rules for these <b>datetime format</b> strings are consistent throughout all these products, though certain uses of these strings might impose extra restrictions. For example, a leading blank may match an the <var>HH</var>, <var>DD</var>, and <var>MM</var> token in SirDBA, but it may not in some cases in other products.</p>
Line 311:		Line 308:

	<tr><th>NS </th>		<tr><th>NS </th>
	<td>Numeric datetime value containing the number seconds since January 1, 1900 at 12:00 AM. (This token is allowed only in the <var class="product">Sir2000 Field Migration Facility</var>.)</td></tr>		<td>Numeric datetime value containing the number of seconds since January 1, 1900 at 12:00 AM. (This token is allowed only in the <var class="product">Sir2000 Field Migration Facility</var>.)</td></tr>

	<tr><th>ND </th>		<tr><th>ND </th>

JAL: add converted SirDBA pdf info

2018-01-22T20:01:55Z

add converted SirDBA pdf info

Show changes

JALWiccan: Automatically generated page update

2016-02-02T21:16:55Z

Automatically generated page update

← Older revision		Revision as of 21:16, 2 February 2016
Line 21:		Line 21:
	The <var class="product">SirDBA</var> documentation is available in PDF format: <var class="book">[[Media:DbarNew.pdf\|Rocket M204 SirDBA User's Guide]]</var>		The <var class="product">SirDBA</var> documentation is available in PDF format: <var class="book">[[Media:DbarNew.pdf\|Rocket M204 SirDBA User's Guide]]</var>

	[[Category:~~Sirius Software products~~]]		[[Category:RKTools]]

JAL: link repair

2016-01-14T20:37:25Z

link repair

← Older revision		Revision as of 20:37, 14 January 2016
Line 19:		Line 19:

	==See also==		==See also==
	The <var class="product">SirDBA</var> documentation is available in PDF format: <var class="book">[~~http~~:~~//m204wiki.rocketsoftware.com/images/2/25/~~DbarNew.pdf Rocket M204 SirDBA User's Guide]</var>		The <var class="product">SirDBA</var> documentation is available in PDF format: <var class="book">[[Media:DbarNew.pdf\|Rocket M204 SirDBA User's Guide]]</var>

	[[Category:Sirius Software products]]		[[Category:Sirius Software products]]

JAL: RKTools replaces UL/SPF

2015-10-23T20:44:44Z

RKTools replaces UL/SPF

← Older revision		Revision as of 20:44, 23 October 2015
Line 4:		Line 4:
	reference the specified field name.		reference the specified field name.

	<var class="product">SirDBA</var> is part of the [[~~ULSPF \| UL/SPF~~]] family of products ~~from [[Sirius Software]]~~. As with all UL/~~SPF~~ products, <var class="product">SirDBA</var> ~~requires~~ the installation of the [[Sirius Mods]], with a version equal to or higher than the <var class="product">SirDBA</var> version.		<var class="product">SirDBA</var> is part of the <var class="product">[[RKTools]]</var> family of products. As with all <var class="product">RKTools</var> products, <var class="product">SirDBA</var> formerly required the installation of the <var class="product">[[Sirius Mods]]</var>, with a version equal to or higher than the <var class="product">SirDBA</var> version. As of Model 204 V7.5, however, the functions and facilities necessary to run RKTools are built into the Model 204 kernel.

	==Overview==		==Overview==

JAL: /* See also */

2013-09-27T17:50:02Z

← Older revision		Revision as of 17:50, 27 September 2013
Line 19:		Line 19:

	==See also==		==See also==
	The <var class="product">SirDBA</var> documentation is available in PDF format: <var class="book">[http://m204wiki.rocketsoftware.com/images/2/25/DbarNew.pdf Rocket ~~Model 204~~ SirDBA User's Guide]</var>		The <var class="product">SirDBA</var> documentation is available in PDF format: <var class="book">[http://m204wiki.rocketsoftware.com/images/2/25/DbarNew.pdf Rocket M204 SirDBA User's Guide]</var>

	[[Category:Sirius Software products]]		[[Category:Sirius Software products]]