Description:
Generate a multicursor from a sequence.
Syntax:
A.cursor@m(n)
Note:
The function generates a multicursor using sequence A.
Parameter:
|
A |
A sequence |
|
n |
Number of subcursors; by default the value is【Default subcursor count in a multicursor】configured in the designer; when integrating esProc in a third-party application, its default value is cursorParallelNum value configured in raqsoftConfig.xml file |
Option:
|
@p |
Assume the sequence is ordered by the 1st field and records having same 1st field value won’t be put into two segments |
Return value:
Multicursor
Example:
|
|
A |
|
|
1 |
=demo.query("select CLASS,STUDENTID,SUBJECT,SCORE from SCORES") |
Return a sequence. |
|
2 |
=A1.cursor@m() |
Generate a multicursor from A1’s sequence; as parameters are absent, use value of【Default subcursor count in a multicursor】as the default number of subcursors. |
|
3 |
=demo.query("select CLASS,STUDENTID,SUBJECT,SCORE from SCORES").sort(CLASS) |
Return a sequence ordered by the 1st field. |
|
4 |
=A1.cursor@mp(3) |
Generate a multicursor having three subcursors; with @p option, the segmentation won’t put records having same CLASS value in two segments. |