Fast/Unload with the Sir2000 Field Migration Facility: Difference between revisions
Jump to navigation
Jump to search
m (add template) |
m (link repair) |
||
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">[[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> | ||
Line 9: | Line 9: | ||
<li>When doing an unload with <var>UAI</var>, 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> <var>LAI</var> operation.</li> | <var class="product">[[Fast/Reload]]</var> <var>[[Fast/Reload statements#The LAI statement|LAI]]</var> operation.</li> | ||
<li>The <var>UNLOAD <i>field</i></var> statement, if it references a <var>RELATED</var> field, | <li>The <var>UNLOAD <i>field</i></var> statement, if it references a <var>RELATED</var> field, |
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:
- 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_R
orHASH 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
- Fast/Unload overview
- Fast/Unload invocation
- Fast/Unload program parameters
- Fast/Unload Extraction Language (FUEL)
- Fast/Unload standard #functions
- Fast/Unload BLOB/CLOB processing considerations
- Fast/Unload datetime processing considerations
- Fast/Unload DATESTAT analysis
- Fast/Unload job statistics
- Fast/Unload SOUL Interface
- Fast/Unload with an external sort package
- Fast/Unload with DBCS data
- Fast/Unload customer-written assembler #function packages
- Fast/Unload user exits or filters
- Fast/Unload with Model 204 file groups
- Fast/Unload with Model 204 fieldgroups
- Fast/Unload with the Sir2000 Field Migration Facility
- Fast/Unload floating point arithmetic and numeric conversion
- Fast/Unload program return codes
- Fast/Unload installation
- Fast/Unload customization of defaults
- Fast/Unload SMF record format
- Fast/Unload release notes
- Fast/Unload messages