FastUnloadTask (Recordset function): Difference between revisions
No edit summary |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{Template:Recordset:FastUnloadTask subtitle}} | {{Template:Recordset:FastUnloadTask subtitle}} | ||
This method performs unloads using <var class="product">[[Fast/Unload]]</var> where | This method performs unloads using <var class="product">[[Fast/Unload]]</var> where | ||
the <var class="product">Fast/Unload</var> output is [[#See also|processed programmatically]] as it is received. | the <var class="product">Fast/Unload</var> output is [[#See also|processed programmatically]] as it is received. | ||
| Line 7: | Line 6: | ||
output: it avoids potentially large quantities of data from being | output: it avoids potentially large quantities of data from being | ||
moved to and from CCATEMP. | moved to and from CCATEMP. | ||
Its disadvantage is that, since <var class="product"> | Its disadvantage is that, since <var class="product">SOUL</var> processing is likely to be | ||
slower than <var class="product">Fast/Unload</var> processing, using <var>FastUnloadTask</var> is likely to tie | slower than <var class="product">Fast/Unload</var> processing, using <var>FastUnloadTask</var> is likely to tie | ||
up a <var class="product">Fast/Unload</var> task much longer than using <var>FastUnload</var>, which sends its output to | up a <var class="product">Fast/Unload</var> task much longer than using <var>FastUnload</var>, which sends its output to a <var>Stringlist</var>. | ||
a <var>Stringlist</var>. | |||
<p class="note"><b>Note:</b> The <code>[[FastUnload (Recordset function)#asynch|Asynch=True]]</code> argument of the <var>FastUnload</var> method provides for complete background execution of a Fast/Unload request.</p> | |||
<var>FastUnloadTask</var> returns a <var>[[FastUnloadTask class|FastUnloadTask]]</var> object | <var>FastUnloadTask</var> returns a <var>[[FastUnloadTask class|FastUnloadTask]]</var> object | ||
| Line 16: | Line 16: | ||
The <var>FastUnloadTask</var> function is only available to customers licensed for the | The <var>FastUnloadTask</var> function is only available to customers licensed for the | ||
<var class="product">Fast/Unload | <var class="product">[[Fast/Unload SOUL Interface]]</var>. | ||
The <var>FastUnloadTask</var> function also requires at least one <var>FastUnload</var> task to be | The <var>FastUnloadTask</var> function also requires at least one <var>FastUnload</var> task to be available in the Online in which it is running, which means that the | ||
available in the Online in which it is running, which means that the | |||
<var>[[FUNTSKN parameter|FUNTSKN]]</var> system parameter must be set to 1 or higher. | <var>[[FUNTSKN parameter|FUNTSKN]]</var> system parameter must be set to 1 or higher. | ||
==Syntax== | ==Syntax== | ||
| Line 44: | Line 41: | ||
<tr><th><var>AllMessages</var></th> | <tr><th><var>AllMessages</var></th> | ||
<td>A <var>[[Boolean enumeration]]</var>, providing functionality similar to the <var>$Funload</var> <var>ALLMSG</var> parameter: if <var>True</var>, all messages that would go in the <var class="product">Fast/Unload</var> report are sent to the report dataset, report <var>Stringlist</var>, or FUNAUDIT. Informational messages ordinarily suppressed by <var class="product">Fast/Unload | <td>A <var>[[Boolean enumeration]]</var>, providing functionality similar to the <var>$Funload</var> <var>ALLMSG</var> parameter: if <var>True</var>, all messages that would go in the <var class="product">Fast/Unload</var> report are sent to the report dataset, report <var>Stringlist</var>, or FUNAUDIT. Informational messages ordinarily suppressed by <var class="product">Fast/Unload SOUL Interface</var> are included by this setting. | ||
<p> | <p> | ||
<var>AllMessages</var> is the [[Notation conventions for methods#Named parameters|required name]] for the parameter. The parameter itself is an optional parameter, and it defaults to <var>False</var>. That is, many informational messages are suppressed from the report output.</p></td></tr> | <var>AllMessages</var> is the [[Notation conventions for methods#Named parameters|required name]] for the parameter. The parameter itself is an optional parameter, and it defaults to <var>False</var>. That is, many informational messages are suppressed from the report output.</p></td></tr> | ||
| Line 61: | Line 58: | ||
A value of 0 for <var>MaxTime</var> means that the request will never timeout. | A value of 0 for <var>MaxTime</var> means that the request will never timeout. | ||
<p> | <p> | ||
<var>MaxTime</var> is the required name for the parameter. The parameter itself is an optional parameter, and it defaults to the setting of the <var>[[FUNMAXT parameter|FUNMAXT]]</var> system parameter. <var>FUNMAXT</var> is described in the [ | <var>MaxTime</var> is the required name for the parameter. The parameter itself is an optional parameter, and it defaults to the setting of the <var>[[FUNMAXT parameter|FUNMAXT]]</var> system parameter. <var>FUNMAXT</var> is also described in the [[Fast/Unload SOUL Interface#FUNMAXT|FUNMAXT]] section of the [[Fast/Unload SOUL Interface]] page. </p> | ||
<p> | <p class="note"> | ||
'''Note:''' A request can timeout through no fault of its own if all the <var class="product"> | '''Note:''' A request can timeout through no fault of its own if all the <var class="product">Fast/Unload</var> tasks are taken up by other long-running requests.</p></td></tr> | ||
</table> | </table> | ||
==Examples== | ==Examples== | ||
See the [[FastUnloadTask class#FastUnloadTask example|examples for the FastUnloadTask class]]. | See the [[FastUnloadTask class#FastUnloadTask example|examples for the <var>FastUnloadTask</var> class]]. | ||
==See also== | ==See also== | ||
<ul> | |||
<li>The <var class="product">[[Fast/Unload]]</var> wiki pages. | |||
</ul> | |||
The following functions provide interaction with the task created by <var>FastUnloadTask</var>: | The following functions provide interaction with the task created by <var>FastUnloadTask</var>: | ||
<ul> | <ul> | ||
| Line 82: | Line 84: | ||
{{Template:Recordset:FastUnloadTask footer}} | {{Template:Recordset:FastUnloadTask footer}} | ||
[[Category:Fast/Unload | [[Category:Fast/Unload SOUL Interface]] | ||
Latest revision as of 16:13, 13 October 2016
Initiate asynch Recordset unload using Fast/Unload User Language Interface (Recordset class)
[Requires Fast/Unload Soul Interface]
This method performs unloads using Fast/Unload where the Fast/Unload output is processed programmatically as it is received.
The FastUnloadTask approach has this advantage over the FastUnload method which has a Stringlist output: it avoids potentially large quantities of data from being moved to and from CCATEMP. Its disadvantage is that, since SOUL processing is likely to be slower than Fast/Unload processing, using FastUnloadTask is likely to tie up a Fast/Unload task much longer than using FastUnload, which sends its output to a Stringlist.
Note: The Asynch=True argument of the FastUnload method provides for complete background execution of a Fast/Unload request.
FastUnloadTask returns a FastUnloadTask object that can be used to retrieve output from Fast/Unload.
The FastUnloadTask function is only available to customers licensed for the Fast/Unload SOUL Interface.
The FastUnloadTask function also requires at least one FastUnload task to be available in the Online in which it is running, which means that the FUNTSKN system parameter must be set to 1 or higher.
Syntax
%fastUnloadTask = recordset:FastUnloadTask( [Input=] input, - [[Parameters=] string], - [AllMessages= boolean], - [ReportToStringlist= boolean], - [MaxTime= number])
Syntax terms
| %fastUnloadTask | A reference to an instance of a FastUnloadTask object. |
|---|---|
| recordset | A reference to an instance of a Recordset object. |
| Input | A Stringlist object that contains the Fast/Unload FUEL program for the unload. Input is the allowed name for the parameter. |
| Parameters | A string that contains the parameters that are to be passed to Fast/Unload. Parameters is the allowed name for the parameter.
This is an optional parameter; if it is not specified, no parameters are passed to Fast/Unload. |
| AllMessages | A Boolean enumeration, providing functionality similar to the $Funload ALLMSG parameter: if True, all messages that would go in the Fast/Unload report are sent to the report dataset, report Stringlist, or FUNAUDIT. Informational messages ordinarily suppressed by Fast/Unload SOUL Interface are included by this setting.
AllMessages is the required name for the parameter. The parameter itself is an optional parameter, and it defaults to False. That is, many informational messages are suppressed from the report output. |
| ReportToStringlist | A Boolean enumeration value:
|
| MaxTime | A numeric value that indicates the maximum number of seconds after initiation of the request that the request is given to complete. If the request has not even started running in a Fast/Unload task, or if the task is running, but hasn't completed after the timeout period, the request is cancelled (resulting in a return code 32 from Fast/Unload).
A value of 0 for MaxTime means that the request will never timeout. MaxTime is the required name for the parameter. The parameter itself is an optional parameter, and it defaults to the setting of the FUNMAXT system parameter. FUNMAXT is also described in the FUNMAXT section of the Fast/Unload SOUL Interface page. Note: A request can timeout through no fault of its own if all the Fast/Unload tasks are taken up by other long-running requests. |
Examples
See the examples for the FastUnloadTask class.
See also
- The Fast/Unload wiki pages.
The following functions provide interaction with the task created by FastUnloadTask:
- GetNextRecord: retrieve the Fast/Unload task's output, one record at a time
- Report: retrieve the Fast/Unload task's report into a Stringlist, after the task is done
- ReturnCode: retrieve the Fast/Unload task's return code, after the task is done
- State: retrieve the state of the Fast/Unload task