Fast/Unload with the Sir2000 Field Migration Facility: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (link repair)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<!-- Page name: Fast/Unload with the Sir2000 Field Migration Facility-->
<!-- Page name: Fast/Unload with the Sir2000 Field Migration Facility-->
<p></p>
For the most part, the presence of a file which has been modified
For the most part, the presence of a file which has been modified
with the <var class="product">Sir2000 Field Migration Facility</var> has no effect on <var class="product">Fast/Unload</var> processing.
with the <var class="product">[[Media:SirFieldNew|Sir2000 Field Migration Facility]]</var> has no effect on <var class="product">Fast/Unload</var> processing.
The exceptions are as follows:
The exceptions are as follows:
<ol>
<ol>
<li>The ADD, CHANGE, and DELETE statements may not be issued for a
<li>The <var>ADD</var>, <var>CHANGE</var>, and <var>DELETE</var> statements may not be issued for a
RELATED field.
<var>RELATED</var> field.</li>
<li>When doing an unload with UAI, the <var class="product">Fast/Unload</var> output contains all of
 
<li>When doing an unload with <var>UAI</var>, the <var class="product">Fast/Unload</var> output contains all of
the <var class="product">Sir2000 Field Migration Facility</var> definitions, which can be used to recreate them during the
the <var class="product">Sir2000 Field Migration Facility</var> definitions, which can be used to recreate them during the
<var class="product">Fast/Reload</var> LAI operation.
<var class="product">[[Fast/Reload]]</var> <var>[[Fast/Reload statements#The LAI statement|LAI]]</var> operation.</li>
<li>The UNLOAD field statement, if it references a RELATED field,
 
will cause the other of the pair of RELATED fields to be unloaded.
<li>The <var>UNLOAD <i>field</i></var> statement, if it references a <var>RELATED</var> field,
causes the other of the pair of <var>RELATED</var> fields to be unloaded.
This ensures that if a partial record is unloaded, both occurrences
This ensures that if a partial record is unloaded, both occurrences
of a RELATED pair of fields are always unloaded.
of a <var>RELATED</var> pair of fields are always unloaded.</li>
<li>If <b><i>UAI SORT field_R</i></b> or <b><i>HASH field_R</i></b>
 
causes <b><i>field_R</i></b> to be implicitly unloaded (see [[#uaif1|UAI SORT or HASH and field unload order]]),
<li>If <code>UAI SORT <i>field_R</i></code> or <code>HASH <i>field_R</i></code>
and <b><i>field_R</i></b> is a RELATED field, then any UNLOAD field statement
causes <i>field_R</i> to be implicitly unloaded (see [[Fast/Unload Extraction Language (FUEL)#uaif1|UAI SORT or HASH and field unload order]]),
causes the other field of the RELATED
and <i>field_R</i> is a <var>RELATED</var> field, then any <var>UNLOAD <i>field</i></var> statement
pair to also be implicitly unloaded, after <b><i>field_R</i></b>.
causes the other field of the <var>RELATED</var>
pair to also be implicitly unloaded, after <i>field_R</i>.
</ol>
</ol>
==See also==
==See also==
[[Fast/Unload overview#WIKFUN$$topics|Fast/Unload topics]]
{{Template:Fast/Unload topic list}}

Latest revision as of 16:13, 19 February 2016

For the most part, the presence of a file which has been modified with the Sir2000 Field Migration Facility has no effect on Fast/Unload processing. The exceptions are as follows:

  1. The ADD, CHANGE, and DELETE statements may not be issued for a RELATED field.
  2. When doing an unload with UAI, the Fast/Unload output contains all of the Sir2000 Field Migration Facility definitions, which can be used to recreate them during the Fast/Reload LAI operation.
  3. The UNLOAD field statement, if it references a RELATED field, causes the other of the pair of RELATED fields to be unloaded. This ensures that if a partial record is unloaded, both occurrences of a RELATED pair of fields are always unloaded.
  4. If UAI SORT field_R or HASH field_R causes field_R to be implicitly unloaded (see UAI SORT or HASH and field unload order), and field_R is a RELATED field, then any UNLOAD field statement causes the other field of the RELATED pair to also be implicitly unloaded, after field_R.

See also

Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=Fast/Unload_with_the_Sir2000_Field_Migration_Facility&oldid=82858"