ifx_setfrag()

Description:

Set the fragmentation information of a specified table.

Syntax:

ifx_setfrag (ifxconn, table, fieldName, min1, min2,....)

Note:

The external library function (See External Library Guide) sets the fragmentation information of the specified table. If the parameters after parameter fieldname are absent, then delete the specified table’s fragmentation information stored in the IfxConn object. The the number of the values of parameter min is the number of fragmented files the specified table has.

Parameter:

ifxconn

An ifxconn object

table

A table being fragmented

fieldName

Fragmented field

min

The minimum value in a fragmented file; can be omitted and can have multiple values

Return value:

Table sequence/null

Example:

 

A

 

1

="d:/frag1.txt"

Create and save a fragmentation information file.

2

=ifx_conn("com.informix.jdbc.IfxDriver","jdbc:informix-sqli:192.168.0.7:8000/tpch:informixserver=tramsserver&user=informix&pwd=informix";A1)

Connect to Informix database.

3

=ifx_takefrag(A2,"orders")

Extract fragmentation information of the orders table.

4

=ifx_setfrag(A2,"orders","o_orderkey",1,400000000)

Set fragmentation information of the orders table.

5

=ifx_setfrag(A2,"orders","o_orderkey")

Delete the fragmentation information.