FastUnload (Recordset function): Difference between revisions
mNo edit summary |
mNo edit summary |
||
Line 19: | Line 19: | ||
<tr><th>%number</th> | <tr><th>%number</th> | ||
<td>A numeric value, as follows: <ul> <li>For asynchronous requests, the request number. Request numbers are assigned serially, starting at 1. <li>For synchronous requests, the return code from <var class="product">Fast/Unload</var>. | <td>A numeric value, as follows: <ul> <li>For asynchronous requests, the request number. Request numbers are assigned serially, starting at 1. <li>For synchronous requests, the return code from <var class="product">Fast/Unload</var>. | ||
If the request is cancelled because the timeout period (<var>MaxTime</var> parameter, or FUNMAXT system parameter) is exceeded, the return code is 32. </ul> | If the request is cancelled because the timeout period (<var>MaxTime</var> parameter, or [[FUNMAXT parameter|FUNMAXT]] system parameter) is exceeded, the return code is 32. </ul> | ||
</td></tr> | </td></tr> | ||
<tr><th>recordset</th> | <tr><th>recordset</th> | ||
Line 71: | Line 71: | ||
<td>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 <var class="product">Fast/Unload</var> 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 <var class="product">Fast/Unload</var>). | <td>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 <var class="product">Fast/Unload</var> 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 <var class="product">Fast/Unload</var>). | ||
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. | ||
This is an optional parameter, and it defaults to the setting of the FUNMAXT system parameter. | This is an optional parameter, and it defaults to the setting of the [[FUNMAXT parameter|FUNMAXT]] system parameter. | ||
'''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. | '''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. | ||
Revision as of 15:13, 23 June 2012
Unload Recordset using Fast/Unload User Language Interface (Recordset class)
[Requires Fast/Unload Soul Interface]
This callable method performs synchronous or asynchronous
unloads using the Fast/Unload User Language Interface
of the record set data in the method object.
This method is only available to customers that are also licensed for the Fast/Unload User Language Interface, and it is only available in Sirius Mods version 6.7 and later.
The FastUnload 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. For more information about Fast/Unload User Language Interface environmental considerations, see the Fast/Unload Reference Manual.
Syntax
[%number =] recordset:FastUnload( [Input=] input, [Output=] output, - [[Report=] report], [[Parameters=] string], - [AllMessages= boolean], [Asynch= boolean], - [Notify= boolean], [MaxTime= number])
Syntax terms
%number | A numeric value, as follows:
|
---|---|
recordset | A reference to an instance of a Recordset object. |
Input | A Stringlist object that contains the Fast/Unload FUEL program for the unload, or a string that contains the DD name of the dataset which contains the FUEL program.
This is a name allowed parameter. |
Output | A Stringlist object that is to receive the unloaded data, or a string that contains the DD name that is to receive the unloaded data.
If the request is asynchronous, and this parameter is a Stringlist object, the request is cancelled. This is a name allowed parameter. |
Report | A Stringlist object that is to receive the Fast/Unload report, or a string containing the DD name that is to receive the report.
If the request is asynchronous, and this parameter is a Stringlist object, the request is cancelled. This is an optional parameter. If it is not specified, the report goes to FUNAUDIT; if there is no FUNAUDIT, the report goes to the Model 204 audit trail. This is a name allowed parameter. |
Parameters | A string that contains the parameters that are to be passed to Fast/Unload.
This is an optional parameter; if it is not specified, no parameters are passed to Fast/Unload. This is a name allowed parameter. |
AllMessages | A Boolean value.
If True, all messages are sent to the Fast/Unload report destination specified by the Report argument. Informational messages ordinarily suppressed by the Fast/Unload User Language Interface are included by this setting. This is an optional parameter, and it defaults to False. That is, many informational messages are suppressed from the report output by default. This is a name required parameter. |
Asynch | A Boolean value:
This parameter is optional, and it defaults to False. This is a name required parameter. |
Notify | A Boolean value:
This is an optional parameter, and it defaults to False. This is a name required parameter. |
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. This is an optional parameter, and it defaults to the setting of the FUNMAXT system parameter. 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. This is a name required parameter. |
Usage notes
- Any errors in the method parameter list, or any environmental errors that would prevent the request from being run, result in the request being cancelled.
Example
In the following example, the FastUnload method uses Fast/Unload to do a PAI unload
to a Stringlist of all the records in file sirFiled
,
and then it displays the Stringlist:
b %rs is object recordSet in file sirFiled %listi is object stringList %listo is object stringList %rc is float find records to %rs end find %listi = new text to %listi FOR EACH RECORD PUT '*' OUTPUT PAI END FOR end text %listo = new %rc = %rs:fastUnload(%listi, %listo, parameters='NEBUFF=10') %listo:print end