HomePage esProc Function Reference conj() cs.conj() ＜Previous |

cs.conj()

Read（1128） Label: split, cursor, union, multicursor,

Description：

Attach the action of splitting each of the records to a cursor and unioning the result members and return the original cursor.

Syntax：

cs.conj(…)

Note：

Attach a computation to cursor cs. The function computes expression x over each of the records in cursor cs, splits them into a sequence or a record sequence, unions the result members or records, and returns the original cursor cs.

 

This is a delayed function.

Parameter：

cs

A cursor/multicursor

x

An expression that returns a record sequence (or a table sequence)

Return value：

Cursor

Example：

 

A

 

1

=demo.cursor("select * from GYMNASTICSWOMEN")

Return a cursor, whose data is as follows:

2

=A1.conj(create(ID,NAME,COUNTRY,SUBJECT,SCORES).record([ID,NAME,

COUNTRY,"VAULT",VAULT,ID,NAME,COUNTRY,"UNEVENBARS",

UNEVENBARS,ID,NAME,COUNTRY,"BALANCEBEAM",

BALANCEBEAM,ID,NAME,COUNTRY,"FLOOR",FLOOR]))

Attach a computation to cursor A1 on which a column-to-row transposition on the cursor’s VAULT, UNEVENBARS, BALANCEBEAM and FLOOR fields will be performed and return the original cursor A1.

3

=A1.fetch()

 

Fetch data from cursor A1 on which A2’s computation is already executed (it would be better to fetch data in batches when data amount is huge):