Description:
Generate a multicursor using a unicursor.
Syntax:
cs.cursor@m(n)
Note:
The function generates a multicursor using a unicursor cs. It fetches data from cs and parallelly allocates them to n subcursors.
Parameter:
|
cs |
A unicursor. |
|
n |
The number of subcursors, whose default value is 【Default Number of Subcursors in a Multicursor】configured in the designer. When esProc is integrated into a third-party application, the default number of subcursors is cursorParallelNum value set up in raqsoftConfig.xml. When n =0, the function generates a buffer cursor, to which retrieval threads buffer data to it. This often happens when cursor data is being appended to a composite table. |
Return value:
Unicursor/Multicursor/Buffer cursor
Example:
|
|
A |
|
|
1 |
=demo.cursor("select * from EMPLOYEE") |
|
|
2 |
=A1.cursor@m(3) |
Generate a multicursor. |
|
|
A |
|
|
1 |
=demo.cursor("select EID,NAME,GENDER,DEPT, SALARY from employee") |
|
|
2 |
=A1.cursor@m(0) |
Generate a buffer cursor. |
|
3 |
=file("emp.ctx").open() |
Open a composite table file. |
|
4 |
=A3.append(A2) |
Append data of cursor A2 to emp.ctx, during which the retrieval threads buffers data when cursor data is outputting. |