T.new( A/cs,x:C,…;wi,... )

Description:

Retrieve specified fields from a cluster composite table according to key values of a cluster table or a cluster cursor and return a cluster multicursor.

Syntax:

T.new(A/cs,x:C,…;wi,…)

Note:

The function retrieves specified fields x,... from cluster composite table T according to key values of cluster in-memory table A or cluster cursor cs; parameter A/cs is ordered by their keys.

Parameters:

T

A cluster table

A/cs

A cluster in-memory table /cluster cursor

x

Field values

C

Column alias

wi

Filtering condition; separate multiple conditions, which should be met at the same time, by comma(s)

Return value:

A cluster multicursor

Example:

 

A

 

1

=file("emp10.ctx",["192.168.0.118:8281"])

 

2

=A1.open()

Open a cluster composite table

3

=file("emp11.ctx",["192.168.0.119:8281"]).open().memory()

Open a cluster memory table

4

=A2.new(A3,NAME,GENDER).fetch()

Retrieve specified fields from A2’s cluster composite table accroding to the key values of A3’s memory table

5

=file("emp12.ctx",["192.168.0.110:8281"]).open().cursor()

Return a cluster cursor

6

=A2.new(A5,NAME:NAME,GENDER:GENDER).fetch()

Retrieve specified fields from A2’s cluster composite table accroding to the key values of A5’s cursor