close()

Read(2232) Label: close,

Here’s how to use close() function.

cs.close()

Description:

Close a cursor.

Syntax:  

cs.close()

Note:  

The function clears the file handles and database connections used by cursors and their root cursors. By default, all of them will be closed automatically when fetch operation finishes.

Parameter:

cs

A cursor

Example:

 

A

 

1

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

Return a cursor of retrieved data.

2

=A1.fetch(10)

Retrieve some records.

3

=A1.close()

Close the cursor.

Related function:

cs.fetch()

db.cursor()

db.close()

Description:

Close a datasource connection.

Syntax:

db.close()

Note:

Close a database connection. By default, data will be committed before closing the database.

Parameter:

db

Database connection, which supports esproc-JDBC source

Example:

 

A

 

1

=connect("demo")

 

2

>A1.close()

Close the connection to database demo.

Note:

connect and close must be used in pairs; otherwise, the connection cannot be closed.

Related function:

connect()

db.error()

db.commit()

db.rollback()

qvm.close()

Description:

Close QVM.

Syntax:

qvm.close()

Note:

The function closes QVM.

Parameter:

qvm

The QVM object

Example:

 

A

 

1

=Qconnect("http://54.213.221.123:8080/qvs":"aws-qvs",30,300)

Request QVA through QVS to access QVM and return a QVM object.

2

=A1.exec("qtc01/imp_txt.splx";100)

Execute SPL script file.

3

>A1.close()

Close QVM.

T.close()

Description:

Close a composite table.

Syntax:

T.close()

Note:

The function closes an entity table and its attached tables in a composite table. The operation is not a necessity when there isn’t a write operation.

Parameter:

T

A composite table

Example:

 

A

 

1

=connect("demo").cursor("select EID,NAME,GENDER,SALARY  from employee")

Return a single cursor.

2

=file("emp.ctx")

Generate a composite table

3

=A2.create(#EID,NAME,GENDER,SALARY)

Create A2’s base table.

4

=A3.append(A1)

Append data of A1’s cursor to the base table.

5

=A3.close()

Close the composite table.

T.close()

Description

Close a cluster table.

Syntax:

T.close()

Note:

The function closes a cluster table. It clears memory when T is a cluster in-memory table created by T.memory().

Parameter:

T

A cluster table

Example:

 

A

 

1

=file("dept.ctx":[1],["192.168.0.104:8281"])

 

2

=A1.open()

Open a cluster table.

3

=A2.attach(t1)

Return an existing attached table t1 in A2’ composite table.

4

=A2.memory(DEPTID,DEPTNAME;DEPTID<10)

Generate a cluster in-memory table from table t1.

5

=A2.close()

Close the cluster table and clear memory.

T.close()

Description:

Close a pseudo table.

Syntax:

T.close()

Note:

The function closes a pseudo table.

Parameter:

T

A pseudo table

Example:

 

A

 

1

=create(file).record(["STOCKRECORDS.ctx"])

 

2

=pseudo(A1)

Return a pseudo table object.

3

>A2.close()

Close the pseudo table.