Fast/Unload customization of defaults: Difference between revisions
(Automatically generated page update) |
m (add note re FUCUST$) |
||
(18 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
<!-- Page name: Fast/Unload customization of defaults--> | <!-- Page name: Fast/Unload customization of defaults--> | ||
< | <blockquote class="note"> | ||
In the descriptions below of the customization patches | <b>Note: In the descriptions below of the customization patches:</b> | ||
<ul> | |||
been done ( | <li>Each of the <var>VER</var> (<var>VERIFY</var>) commands presume that no prior patching has been done (that is, they require the particular byte to be all-zero). | ||
They are shown this way merely as a template and this is | They are shown this way merely as a template, and this is | ||
obviously wrong if you | obviously wrong if you have made a prior customization run. | ||
< | <p> | ||
If you are doing all your patches in one run, you can indeed | If you are doing all your patches in one run, you can indeed | ||
verify that the byte in question is all zero and then provide only | verify that the byte in question is all-zero, and then provide only | ||
the necessary REP commands after that one VER command. If you have | the necessary <var>REP</var> commands after that one <var>VER</var> command. If you have in fact made any prior runs, you must replace the zero-byte in the <var>VER</var> command with the logical <code>Or</code> of whatever flag bits you turned on in prior patches.</p></li> | ||
in fact made any prior runs, you must replace the zero-byte in the | |||
VER command with the logical | <li>If you are using <var class="product">Model 204</var> 7.6 or higher, you need to apply two zaps per patch: one for the Fast/Unload FUNLOAD load module, and one for the <var class="product">Model 204</var> Online load module. </li> | ||
in prior patches. | </ul> | ||
</blockquote> | |||
<div id="sort"></div> | <div id="sort"></div> | ||
Line 18: | Line 19: | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
<var class="product">Fast/Unload</var> communicates with an external sort package via a parameter list or <b>plist</b>. | |||
<var class="product">Fast/Unload</var> communicates with an external sort package via a parameter list | |||
or <b>plist</b>. | |||
There are two basic standards for sort parameter lists: | There are two basic standards for sort parameter lists: | ||
<ul> | <ul> | ||
<li>The 24-bit "old-fashioned" parameter list. | <li>The 24-bit "old-fashioned" parameter list. | ||
This is supported by virtually | This is supported by virtually all sort packages.</li> | ||
all sort packages. | |||
<li>The 31-bit extended parameter list. | <li>The 31-bit extended parameter list. | ||
This is supported by DFSORT, SYNCSORT, | This is supported by DFSORT, SYNCSORT, | ||
and several other "modern" sort packages. | and several other "modern" sort packages.</li> | ||
</ul> | </ul> | ||
You can use the SORTP parameter to | You can use the <var>SORTP</var> parameter to | ||
tell <var class="product">Fast/Unload</var> which type of parameter list to try to use. | tell <var class="product">Fast/Unload</var> which type of parameter list to try to use. | ||
Note, however, that <var class="product">Fast/Unload</var> makes no attempt | Note, however, that <var class="product">Fast/Unload</var> makes no attempt | ||
to verify that your sort package actually supports the requested type of plist. | to verify that your sort package actually supports the requested type of plist. | ||
The 31-bit extended parameter lists are more flexible and allow a greater | The 31-bit extended parameter lists are more flexible and allow a greater | ||
variety of | variety of <code>SORT</code> statements to be passed to the sort package. | ||
SORT statements to be passed to the sort package. | For this reason, the default value for <var>SORTP</var> is 31. | ||
For this reason, the default | |||
value for SORTP is 31. | |||
If you do not have a sort package that supports 31-bit | If you do not have a sort package that supports 31-bit | ||
extended parameter lists at your site, you may want to change the SORTP default. | extended parameter lists at your site, you may want to change the <var>SORTP</var> default. | ||
To do so, | To do so, apply the zap(s) below according to the product versions at your site. You may need to apply both: | ||
<p class="code"> | <ul> | ||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1200 00 | |||
REP 1200 80 | |||
</p></li> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 80 | REP 1200 80 | ||
</ | </p></li> | ||
</ul> | |||
<div id="sortout"></div> | <div id="sortout"></div> | ||
Line 53: | Line 60: | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
The parameter that controls the selection of the | The parameter that controls the selection of the | ||
destination data set for sorted output | destination data set for sorted output | ||
is set by <var class="product">Fast/Unload</var> by default to SORTOUTD. | is set by <var class="product">Fast/Unload</var> by default to <var>SORTOUTD</var>. | ||
Prior to version 4.1, the default was SORTOUT. | Prior to version 4.1, the default was <var>SORTOUT</var>. | ||
You can change this default setting to be either FUNOUT or SORTOUT. | You can change this default setting to be either <var>FUNOUT</var> or <var>SORTOUT</var>. | ||
These parameters are described in | These parameters are described in | ||
[[#foutprm|FUnout]] and [[#soutprm|SORTOut | SORTOUTD]]. | [[Fast/Unload program parameters#foutprm|FUnout]] and [[Fast/Unload program parameters#soutprm|SORTOut | SORTOUTD]]. | ||
< | <ul> | ||
To make FUNOUT the default at your site, | <li>To make <b>FUNOUT the default</b> at your site, apply one or both of the following zaps: | ||
apply the following | <ul> | ||
<p class="code" | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 20 | REP 1200 20 | ||
</ | </p></li> | ||
<p></ | |||
To make SORTOUT the default at your site, | <li>If you have <var class="product">Fast/Unload</var> version 4.7 or lower, apply this zap to the FUNLOAD load module: | ||
apply the following | <p class="code">* Be sure not to apply this zap to the Online load module | ||
<p class="code" | NAME FUNLOAD PTCH | ||
VER 1200 00 | |||
REP 1200 20 | |||
</p></li> | |||
</ul></li> | |||
<li>To make <b>SORTOUT the default</b> at your site, apply one or both of the following zaps: | |||
<ul> | |||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1214 00 | VER 1214 00 | ||
REP 1214 10 | REP 1214 10 | ||
</ | </p></li> | ||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or lower, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1214 00 | |||
REP 1214 10 | |||
</p></li> | |||
</ul></li> | |||
</ul> | |||
<div id="deferr"></div> | <div id="deferr"></div> | ||
==Default for ERROR clause on PUT statement== | ==Default for ERROR clause on PUT statement== | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
<var class="product">Fast/Unload</var> by default sets the <var>ERROR</var> clause to be the same as the <var>MISSING</var> clause on the <var>PUT</var> statement (except when <var>AS STRING</var> is | |||
<var class="product">Fast/Unload</var> by default sets the ERROR clause to be the same as the | specified, in which case <var>TRUNCATE</var> is the default for <var>ERROR</var>). | ||
MISSING clause on the PUT statement (except when AS STRING is | |||
specified, in which case TRUNCATE is the default for | If you want <var>CANCEL</var> to be the default for the <var>ERROR</var> clause at your site, apply the zap(s) below according to your product versions. You may need to apply both: | ||
< | <ul> | ||
If you want CANCEL to be the default for the ERROR clause at your site, | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
apply the | <p class="code">NAME ONLINE FUCUST$ | ||
<p class="code" | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 01 | REP 1200 01 | ||
</ | </p></li> | ||
This will be the default whether AS STRING is specified or not. | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | |||
REP 1200 01 | |||
</p></li> | |||
</ul> | |||
This will be the default whether <var>AS STRING</var> is specified or not. | |||
<div id="defmis"></div> | <div id="defmis"></div> | ||
Line 97: | Line 131: | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
<var class="product">Fast/Unload</var> by default sets the <var>MISSING</var> clause to be <code>-1</code> on the <var>PUT</var> statement (except when <var>AS STRING</var> is | |||
<var class="product">Fast/Unload</var> by default sets the MISSING clause to be -1 | specified, in which case blank fill is the default for <var>MISSING</var>). | ||
on the PUT statement (except when AS STRING is | |||
specified, in which case blank fill is the default for MISSING). | To make <code>0</code> the default for the <var>MISSING</var> clause at your site, | ||
< | apply the zap(s) below according to your product versions. You may need to apply both: | ||
<ul> | |||
apply the | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code"> | <p class="code">NAME ONLINE FUCUST$ | ||
VER 1200 00 | |||
REP 1200 10 | |||
</p></li> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 10 | REP 1200 10 | ||
</ | </p></li> | ||
This will not change the default if AS STRING is specified. | </ul> | ||
This will not change the default if <var>AS STRING</var> is specified. | |||
<div id="defchk"></div> | <div id="defchk"></div> | ||
==<b id="smfRecn"></b>SMF record number== | |||
If you use <var class="product">Fast/Unload</var> in a z/OS environment, you can choose to generate SMF records containing the complete set of [[Fast/Unload statistics]]. | |||
To enable this, you must customize Fast/Unload to contain an SMF record number in the range between X'80' and X'FF'. For example, the following zaps enable SMF statistics using record number X'E1'. You would apply one or both of the following zaps: | |||
<ul> | |||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1200 00 | |||
REP 1200 E1 | |||
</p></li> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | |||
REP 1200 E1 | |||
</p></li> | |||
</ul> | |||
See [[Fast/Unload SMF record format]] for more | |||
information about <var class="product">Fast/Unload</var> SMF records. | |||
==Default CHECK conditions and actions== | ==Default CHECK conditions and actions== | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
During an individual run of <var class="product">Fast/Unload</var>, you can use the | During an individual run of <var class="product">Fast/Unload</var>, you can use the | ||
CHECK statement to specify the conditions to check and | <var>CHECK</var> statement to specify the conditions to check and | ||
the action to take if a condition is found. | the action to take if a condition is found. | ||
The CHECK statement overrides the default checks, if any, | The <var>CHECK</var> statement overrides the default checks, if any, | ||
for the conditions it specifies. | for the conditions it specifies. | ||
The defaults shipped by Rocket Software are shown in | The defaults shipped by Rocket Software are shown in | ||
[[#chkdflt|CHECK statement defaults]]. | [[Fast/Unload Extraction Language (FUEL)#chkdflt|CHECK statement defaults]]. | ||
To change any of the defaults for CHECK at | To change any of the defaults for <var>CHECK</var> at | ||
your site, you can | your site, you can zap the defaults. | ||
Each of the defaults consists of a single byte, with the following values: | Each of the defaults consists of a single byte, with the following values: | ||
<table> | <table class="thJustBold"> | ||
<tr><th>0 or 1</th><td>IGNORE</td></tr> | <tr><th>0 or 1</th> | ||
<tr><th>2</th><td>WARN</td></tr> | <td><var>IGNORE</var></td></tr> | ||
<tr><th>3 or greater</th><td>CANCEL</td></tr> | |||
<tr><th>2</th> | |||
<td><var>WARN</var></td></tr> | |||
<tr><th>3 or greater</th> | |||
<td><var>CANCEL</var></td></tr> | |||
</table> | </table> | ||
The | The offsets for the six default bytes are: | ||
<table> | <table class="thJustBold"> | ||
<tr><th>X'1202'</th><td>BROKE-PHYS</td></tr> | <tr><th>X'1202'</th> | ||
<tr><th>X'1203'</th><td>BROK-LOGIC</td></tr> | <td><var>BROKE-PHYS</var></td></tr> | ||
<tr><th>X'1204'</th><td>DUPDT in <var class="product">Fast/Unload</var> run with neither UAI OINDEX nor UAI INV</td></tr> | |||
<tr><th>X'1205'</th><td>PROCS in <var class="product">Fast/Unload</var> run with no FOR EACH RECORD statement</td></tr> | <tr><th>X'1203'</th> | ||
<tr><th>X'1206'</th><td>INVIS in <var class="product">Fast/Unload</var> run with no FOR EACH RECORD statement</td></tr> | <td><var>BROK-LOGIC</var></td></tr> | ||
<tr><th>X'1207'</th><td>DUPDT in <var class="product">Fast/Unload</var> run with UAI OINDEX or UAI INV</td></tr> | |||
<tr><th>X'1204'</th> | |||
<td><var>DUPDT</var> in <var class="product">Fast/Unload</var> run with neither <var>UAI OINDEX</var> nor <var>UAI INV</var></td></tr> | |||
<tr><th>X'1205'</th> | |||
<td><var>PROCS</var> in <var class="product">Fast/Unload</var> run with no <var>FOR EACH RECORD</var> statement</td></tr> | |||
<tr><th>X'1206'</th> | |||
<td><var>INVIS</var> in <var class="product">Fast/Unload</var> run with no <var>FOR EACH RECORD</var> statement</td></tr> | |||
<tr><th>X'1207'</th> | |||
<td><var>DUPDT</var> in <var class="product">Fast/Unload</var> run with <var>UAI OINDEX</var> or <var>UAI INV</var></td></tr> | |||
</table> | </table> | ||
< | |||
Example customization of <var>[[FISTAT parameter|FISTAT]]</var> actions: | |||
<ol> | |||
<li>To unload any file, regardless of <var>FISTAT</var>, without affecting the <var class="product">Fast/Unload</var> return code, apply one or both of the following zaps: | |||
<ul> | <ul> | ||
<li> | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
the | <p class="code">NAME ONLINE FUCUST$ | ||
<p class="code" | |||
VER 1202 0303,0303,0003 | VER 1202 0303,0303,0003 | ||
REP 1202 0000,0000,0000 | REP 1202 0000,0000,0000 | ||
</ | </p></li> | ||
<li>To set the | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or higher, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1202 0303,0303,0003 | |||
REP 1202 0000,0000,0000 | |||
</p></li> | |||
</ul> | |||
<li>To set the <var class="product">Fast/Unload</var> return code to a minimum of <code>4</code> | |||
for <var class="product">Fast/Unload</var> runs where the file contains | for <var class="product">Fast/Unload</var> runs where the file contains | ||
definitions of either procedures or INVISIBLE fields that are | definitions of either procedures or <var>INVISIBLE</var> fields that are | ||
not unloaded: | not unloaded, apply one or both of the following zaps: | ||
<p class="code" | <ul> | ||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1202 0303,0303,0000 | VER 1202 0303,0303,0000 | ||
REP 1202 0303,0302,0200 | REP 1202 0303,0302,0200 | ||
</ | </p> | ||
</ul> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or higher, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1202 0303,0303,0000 | |||
REP 1202 0303,0302,0200 | |||
</p></li> | |||
</ul></li> | |||
</ol> | |||
<div id="dfcs"></div> | <div id="dfcs"></div> | ||
==CENTSPAN and SPANSIZE== | ==CENTSPAN and SPANSIZE== | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
If you want to change the default value of <var>[[Fast/Unload datetime processing considerations#CENTSPAN|CENTSPAN]]</var> used in <var class="product">Fast/Unload</var>, calculate the hexadecimal value (as a signed 2-byte | |||
If you want to change the default value of CENTSPAN used in | number), and place that value (<var class="term">vvvv</var>) into the following | ||
zap(s) according to your product versions. You may need to apply both: | |||
number) and place that value (< | <ul> | ||
zap: | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code" | <p class="code">NAME ONLINE FUCUST$ | ||
VER 1208 FFCE Change default CENTSPAN of -50 | VER 1208 FFCE Change default CENTSPAN of -50 | ||
REP 1208 vvvv to ... | REP 1208 vvvv to ... | ||
</ | </p></li> | ||
<p></ | |||
If you want to change the value of SPANSIZE used in | <li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | ||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
number | NAME FUNLOAD PTCH | ||
(< | VER 1208 FFCE Change default CENTSPAN of -50 | ||
<p class="code">< | REP 1208 vvvv to ... | ||
</p></li> | |||
</ul> | |||
If you want to change the value of <var>[[Fast/Unload datetime processing considerations#SPANSIZE|SPANSIZE]]</var> used in <var class="product">Fast/Unload</var>, calculate the hexadecimal value (as a 2-byte | |||
number — it must be between 1 and 100) and place that value | |||
(<var class="term">vvvv</var>) into the following | |||
zap(s) according to your product versions. You may need to apply both: | |||
<ul> | |||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 120A 005A Change SPANSIZE of 90 | |||
REP 120A vvvv to ... | |||
</p></li> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 120A 005A Change SPANSIZE of 90 | VER 120A 005A Change SPANSIZE of 90 | ||
REP 120A vvvv to ... | REP 120A vvvv to ... | ||
</ | </p></li> | ||
</ul> | |||
<div id="dfspgm"></div> | <div id="dfspgm"></div> | ||
==Default SORT program name== | ==Default SORT program name== | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
If you want to change the default name used for external sorts, | If you want to change the default name used for external sorts, | ||
calculate the hexadecimal value of the 8-character EBCDIC program | calculate the hexadecimal value of the 8-character EBCDIC program | ||
name, and place that value into the following zap: | name, and place that value into the following zap(s) according to your product versions. You may need to apply both: | ||
<p class="code" | <ul> | ||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 120C E2D6D9E3,404040 Change name from SORT | VER 120C E2D6D9E3,404040 Change name from SORT | ||
REP 120C vvvvvvvv,vvvvvv to ... | REP 120C vvvvvvvv,vvvvvv to ... | ||
</p> | |||
< | <p> | ||
For example, to change the name to XSORT, use the following zap: | For example, to change the name to <code>XSORT</code>, use the following zap: | ||
<p class="code" | </p> | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 120C E2D6D9E3,404040 Change name from SORT | VER 120C E2D6D9E3,404040 Change name from SORT | ||
REP 120C E7E2D6D9,E34040 to XSORT | REP 120C E7E2D6D9,E34040 to XSORT | ||
</ | </p> | ||
</li> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 120C E2D6D9E3,404040 Change name from SORT | |||
REP 120C vvvvvvvv,vvvvvv to ... | |||
</p> | |||
<p> | |||
For example, to change the name to <code>XSORT</code>, use the following zap: | |||
</p> | |||
<p class="code">NAME FUNLOAD PTCH | |||
VER 120C E2D6D9E3,404040 Change name from SORT | |||
REP 120C E7E2D6D9,E34040 to XSORT | |||
</p></li> | |||
</ul> | |||
<div id="cuslis"></div> | <div id="cuslis"></div> | ||
Line 206: | Line 344: | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
If you want to suppress the listing of FUEL programs by default at | If you want to suppress the listing of FUEL programs by default at | ||
your installation, you can use the following zap: | your installation, you can use the following zap(s) according to your product versions. You may need to apply both: | ||
<p class="code" | <ul> | ||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1214 00 Unzapped byte | VER 1214 00 Unzapped byte | ||
REP 1214 80 NOLIST is default | REP 1214 80 NOLIST is default | ||
</ | </p></li> | ||
<p></ | |||
Note that when the <var class="product">Fast/Unload SOUL Interface</var> is used, NOLIST is | <li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | ||
the default unless the ALLMSG parameter is specified. | <p class="code">* Be sure not to apply this zap to the Online load module | ||
NAME FUNLOAD PTCH | |||
VER 1214 00 Unzapped byte | |||
REP 1214 80 NOLIST is default | |||
</p></li> | |||
</ul> | |||
Note that when the <var class="product">Fast/Unload SOUL Interface</var> is used, <var>NOLIST</var> is the default unless the <var>[[Fast/Unload program parameters#ALlmsg|ALLMSG]]</var> parameter is specified. | |||
<div id="cusfst"></div> | <div id="cusfst"></div> | ||
Line 221: | Line 367: | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
If you want to change the default behavior of <var>[[FISTAT parameter|FISTAT]]</var> processing to | |||
If you want to change the default behavior of | be that performed by <code>FSTATS MINMAX</code>, use the following zap(s) according to your product versions. You may need to apply both: | ||
be that performed by FSTATS MINMAX, use the following zap: | <ul> | ||
<p class="code" | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1214 00 Unzapped byte | VER 1214 00 Unzapped byte | ||
REP 1214 20 MINMAX is default for FSTATS | REP 1214 20 MINMAX is default for FSTATS | ||
</ | </p></li> | ||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1214 00 Unzapped byte | |||
REP 1214 20 MINMAX is default for FSTATS | |||
</p></li> | |||
</ul> | |||
<div id="cusaber"></div> | <div id="cusaber"></div> | ||
Line 233: | Line 388: | ||
<!--Caution: <div> above--> | <!--Caution: <div> above--> | ||
If you want to change the default of the <var>[[Fast/Unload program parameters#ABENDERR|ABENDERR]]</var> parameter, use the following zap(s) according to your product versions. You may need to apply both: | |||
If you want to change the default of the ABENDERR parameter, | <ul> | ||
<li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | |||
<p class="code" | <p class="code">NAME ONLINE FUCUST$ | ||
VER 1216 0000 Old default was ABENDERR=0 | VER 1216 0000 Old default was ABENDERR=0 | ||
REP 1216 00vv New default is vv in hex | REP 1216 00vv New default is vv in hex | ||
</p> | |||
< | <p> | ||
For example, the following zap sets the default ABENDERR to 8: | For example, the following zap sets the default <var>ABENDERR</var> to 8: | ||
<p class="code" | </p> | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1216 0000 Old default was ABENDERR=0 | VER 1216 0000 Old default was ABENDERR=0 | ||
REP 1216 0008 New default is ABENDERR=8 | REP 1216 0008 New default is ABENDERR=8 | ||
</ | </p></li> | ||
<p></p> | |||
Note | <li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | ||
is always the default. | <p class="code">* Be sure not to apply this zap to the Online load module | ||
NAME FUNLOAD PTCH | |||
< | VER 1216 0000 Old default was ABENDERR=0 | ||
REP 1216 00vv New default is vv in hex | |||
</p> | |||
<p> | |||
For example, the following zap sets the default <var>ABENDERR</var> to 8: | |||
</p> | |||
<p class="code">NAME FUNLOAD PTCH | |||
VER 1216 0000 Old default was ABENDERR=0 | |||
REP 1216 0008 New default is ABENDERR=8 | |||
</p></li> | |||
</ul> | |||
<p class="note"><b>Note:</b> When the <var class="product">Fast/Unload SOUL Interface</var> is used, <code>ABENDERR=0</code> is always the default. </p> | |||
==<b id="dbcsenv"></b>DBCS environment== | |||
If your database files frequently | If your database files frequently | ||
contain DBCS data, you may want to tell <var class="product">Fast/Unload</var> to automatically | contain DBCS data, you may want to tell <var class="product">Fast/Unload</var> to automatically assume a specific DBCS environment. | ||
assume a specific DBCS environment. | |||
This way, you can avoid coding | This way, you can avoid coding | ||
the DBCS parameter on all your <var class="product">Fast/Unload</var> runs. | the <var>DBCS</var> parameter on all your <var class="product">Fast/Unload</var> runs. | ||
The distribution version of <var class="product">Fast/Unload</var> defaults to DBCS=NONE. | The distribution version of <var class="product">Fast/Unload</var> defaults to <code>DBCS=NONE</code>. | ||
===IBM DBCS environment=== | ===IBM DBCS environment=== | ||
To set an IBM default DBCS environment, apply one or both of the following zaps according to your product versions: | |||
To set an IBM default DBCS environment, apply the following zap | <ul> | ||
<p class="code" | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 02 | REP 1200 02 | ||
</ | </p></li> | ||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | |||
REP 1200 02 | |||
</p></li> | |||
</ul> | |||
===Fujitsu DBCS environment=== | ===Fujitsu DBCS environment=== | ||
To set a Fujitsu default DBCS environment, apply one or both of the following zaps according to your product versions: | |||
To set a Fujitsu default DBCS environment, apply the following zap | <ul> | ||
<p class="code" | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 04 | REP 1200 04 | ||
</ | </p></li> | ||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | |||
REP 1200 04 | |||
</p></li> | |||
</ul> | |||
===Hitachi DBCS environment=== | ===Hitachi DBCS environment=== | ||
To set a Hitachi default DBCS environment, apply one or both of the following zaps according to your product versions: | |||
To set a Hitachi default DBCS environment, apply the following zap | <ul> | ||
<p class="code">< | <li>If you have <var class="product">Model 204</var> version 7.6 or higher, apply this zap to the Online load module: | ||
<p class="code">NAME ONLINE FUCUST$ | |||
VER 1200 00 | |||
REP 1200 08 | |||
</p></li> | |||
<li>If you have <var class="product">Fast/Unload</var> version 4.7 or earlier, apply this zap to the FUNLOAD load module: | |||
<p class="code">* Be sure not to apply this zap to the Online load module | |||
NAME FUNLOAD PTCH | |||
VER 1200 00 | VER 1200 00 | ||
REP 1200 08 | REP 1200 08 | ||
</ | </p></li> | ||
</ul> | |||
==See also== | ==See also== | ||
{{Template:Fast/Unload topic list}} |
Latest revision as of 17:51, 9 February 2016
Note: In the descriptions below of the customization patches:
- Each of the VER (VERIFY) commands presume that no prior patching has been done (that is, they require the particular byte to be all-zero). They are shown this way merely as a template, and this is obviously wrong if you have made a prior customization run.
If you are doing all your patches in one run, you can indeed verify that the byte in question is all-zero, and then provide only the necessary REP commands after that one VER command. If you have in fact made any prior runs, you must replace the zero-byte in the VER command with the logical
Or
of whatever flag bits you turned on in prior patches.- If you are using Model 204 7.6 or higher, you need to apply two zaps per patch: one for the Fast/Unload FUNLOAD load module, and one for the Model 204 Online load module.
Sort parameter list
Fast/Unload communicates with an external sort package via a parameter list or plist. There are two basic standards for sort parameter lists:
- The 24-bit "old-fashioned" parameter list. This is supported by virtually all sort packages.
- The 31-bit extended parameter list. This is supported by DFSORT, SYNCSORT, and several other "modern" sort packages.
You can use the SORTP parameter to tell Fast/Unload which type of parameter list to try to use. Note, however, that Fast/Unload makes no attempt to verify that your sort package actually supports the requested type of plist.
The 31-bit extended parameter lists are more flexible and allow a greater
variety of SORT
statements to be passed to the sort package.
For this reason, the default value for SORTP is 31.
If you do not have a sort package that supports 31-bit extended parameter lists at your site, you may want to change the SORTP default. To do so, apply the zap(s) below according to the product versions at your site. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 80
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 80
Changing the default sort parameter
The parameter that controls the selection of the destination data set for sorted output is set by Fast/Unload by default to SORTOUTD. Prior to version 4.1, the default was SORTOUT. You can change this default setting to be either FUNOUT or SORTOUT. These parameters are described in FUnout and SORTOut | SORTOUTD.
- To make FUNOUT the default at your site, apply one or both of the following zaps:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 20
- If you have Fast/Unload version 4.7 or lower, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 20
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
- To make SORTOUT the default at your site, apply one or both of the following zaps:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1214 00 REP 1214 10
- If you have Fast/Unload version 4.7 or lower, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1214 00 REP 1214 10
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
Default for ERROR clause on PUT statement
Fast/Unload by default sets the ERROR clause to be the same as the MISSING clause on the PUT statement (except when AS STRING is specified, in which case TRUNCATE is the default for ERROR).
If you want CANCEL to be the default for the ERROR clause at your site, apply the zap(s) below according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 01
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 01
This will be the default whether AS STRING is specified or not.
Default for MISSING clause on PUT statement
Fast/Unload by default sets the MISSING clause to be -1
on the PUT statement (except when AS STRING is
specified, in which case blank fill is the default for MISSING).
To make 0
the default for the MISSING clause at your site,
apply the zap(s) below according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 10
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 10
This will not change the default if AS STRING is specified.
SMF record number
If you use Fast/Unload in a z/OS environment, you can choose to generate SMF records containing the complete set of Fast/Unload statistics. To enable this, you must customize Fast/Unload to contain an SMF record number in the range between X'80' and X'FF'. For example, the following zaps enable SMF statistics using record number X'E1'. You would apply one or both of the following zaps:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 E1
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 E1
See Fast/Unload SMF record format for more information about Fast/Unload SMF records.
Default CHECK conditions and actions
During an individual run of Fast/Unload, you can use the CHECK statement to specify the conditions to check and the action to take if a condition is found. The CHECK statement overrides the default checks, if any, for the conditions it specifies. The defaults shipped by Rocket Software are shown in CHECK statement defaults.
To change any of the defaults for CHECK at your site, you can zap the defaults. Each of the defaults consists of a single byte, with the following values:
0 or 1 | IGNORE |
---|---|
2 | WARN |
3 or greater | CANCEL |
The offsets for the six default bytes are:
X'1202' | BROKE-PHYS |
---|---|
X'1203' | BROK-LOGIC |
X'1204' | DUPDT in Fast/Unload run with neither UAI OINDEX nor UAI INV |
X'1205' | PROCS in Fast/Unload run with no FOR EACH RECORD statement |
X'1206' | INVIS in Fast/Unload run with no FOR EACH RECORD statement |
X'1207' | DUPDT in Fast/Unload run with UAI OINDEX or UAI INV |
Example customization of FISTAT actions:
- To unload any file, regardless of FISTAT, without affecting the Fast/Unload return code, apply one or both of the following zaps:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1202 0303,0303,0003 REP 1202 0000,0000,0000
- If you have Fast/Unload version 4.7 or higher, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1202 0303,0303,0003 REP 1202 0000,0000,0000
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
- To set the Fast/Unload return code to a minimum of
4
for Fast/Unload runs where the file contains definitions of either procedures or INVISIBLE fields that are not unloaded, apply one or both of the following zaps:- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1202 0303,0303,0000 REP 1202 0303,0302,0200
- If you have Fast/Unload version 4.7 or higher, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1202 0303,0303,0000 REP 1202 0303,0302,0200
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
CENTSPAN and SPANSIZE
If you want to change the default value of CENTSPAN used in Fast/Unload, calculate the hexadecimal value (as a signed 2-byte number), and place that value (vvvv) into the following zap(s) according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1208 FFCE Change default CENTSPAN of -50 REP 1208 vvvv to ...
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1208 FFCE Change default CENTSPAN of -50 REP 1208 vvvv to ...
If you want to change the value of SPANSIZE used in Fast/Unload, calculate the hexadecimal value (as a 2-byte number — it must be between 1 and 100) and place that value (vvvv) into the following zap(s) according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 120A 005A Change SPANSIZE of 90 REP 120A vvvv to ...
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 120A 005A Change SPANSIZE of 90 REP 120A vvvv to ...
Default SORT program name
If you want to change the default name used for external sorts, calculate the hexadecimal value of the 8-character EBCDIC program name, and place that value into the following zap(s) according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 120C E2D6D9E3,404040 Change name from SORT REP 120C vvvvvvvv,vvvvvv to ...
For example, to change the name to
XSORT
, use the following zap:NAME ONLINE FUCUST$ VER 120C E2D6D9E3,404040 Change name from SORT REP 120C E7E2D6D9,E34040 to XSORT
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 120C E2D6D9E3,404040 Change name from SORT REP 120C vvvvvvvv,vvvvvv to ...
For example, to change the name to
XSORT
, use the following zap:NAME FUNLOAD PTCH VER 120C E2D6D9E3,404040 Change name from SORT REP 120C E7E2D6D9,E34040 to XSORT
Setting NOLIST as default
If you want to suppress the listing of FUEL programs by default at your installation, you can use the following zap(s) according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1214 00 Unzapped byte REP 1214 80 NOLIST is default
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1214 00 Unzapped byte REP 1214 80 NOLIST is default
Note that when the Fast/Unload SOUL Interface is used, NOLIST is the default unless the ALLMSG parameter is specified.
Setting default FSTATS processing
If you want to change the default behavior of FISTAT processing to
be that performed by FSTATS MINMAX
, use the following zap(s) according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1214 00 Unzapped byte REP 1214 20 MINMAX is default for FSTATS
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1214 00 Unzapped byte REP 1214 20 MINMAX is default for FSTATS
Setting default ABENDERR
If you want to change the default of the ABENDERR parameter, use the following zap(s) according to your product versions. You may need to apply both:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1216 0000 Old default was ABENDERR=0 REP 1216 00vv New default is vv in hex
For example, the following zap sets the default ABENDERR to 8:
NAME ONLINE FUCUST$ VER 1216 0000 Old default was ABENDERR=0 REP 1216 0008 New default is ABENDERR=8
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1216 0000 Old default was ABENDERR=0 REP 1216 00vv New default is vv in hex
For example, the following zap sets the default ABENDERR to 8:
NAME FUNLOAD PTCH VER 1216 0000 Old default was ABENDERR=0 REP 1216 0008 New default is ABENDERR=8
Note: When the Fast/Unload SOUL Interface is used, ABENDERR=0
is always the default.
DBCS environment
If your database files frequently
contain DBCS data, you may want to tell Fast/Unload to automatically assume a specific DBCS environment.
This way, you can avoid coding
the DBCS parameter on all your Fast/Unload runs.
The distribution version of Fast/Unload defaults to DBCS=NONE
.
IBM DBCS environment
To set an IBM default DBCS environment, apply one or both of the following zaps according to your product versions:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 02
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 02
Fujitsu DBCS environment
To set a Fujitsu default DBCS environment, apply one or both of the following zaps according to your product versions:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 04
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 04
Hitachi DBCS environment
To set a Hitachi default DBCS environment, apply one or both of the following zaps according to your product versions:
- If you have Model 204 version 7.6 or higher, apply this zap to the Online load module:
NAME ONLINE FUCUST$ VER 1200 00 REP 1200 08
- If you have Fast/Unload version 4.7 or earlier, apply this zap to the FUNLOAD load module:
* Be sure not to apply this zap to the Online load module NAME FUNLOAD PTCH VER 1200 00 REP 1200 08
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