Fast/Unload with the Sir2000 Field Migration Facility: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
m (more conversion cleanup) |
||
| Line 1: | Line 1: | ||
<!-- Page name: Fast/Unload with the Sir2000 Field Migration Facility--> | <!-- Page name: Fast/Unload with the Sir2000 Field Migration Facility--> | ||
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">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>LAI</var> operation.</li> | ||
<li>The UNLOAD field statement, if it references a RELATED field, | |||
<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 < | |||
causes | <li>If <code>UAI SORT <i>field_R</i></code> or <code>HASH <i>field_R</i></code> | ||
and | 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 | 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]] | [[Fast/Unload overview#WIKFUN$$topics|Fast/Unload topics]] | ||
Revision as of 16:29, 23 February 2015
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:
- The ADD, CHANGE, and DELETE statements may not be issued for a RELATED field.
- 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.
- 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.
- If
UAI SORT field_RorHASH field_Rcauses 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.