ifx_savefrag()

Description:

Save the fragmentation information file stored in the memory as a new file.

Syntax:

ifx_savefrag(ifxconn, file)

Note:

The external library function (See External Library Guide) saves the fragmentation information stored in the memory as a new file. The new file can be the same as the file fragfile created via ifx_conn(), or one saved in another name.

Parameter:

ifxconn

An ifxconn object

file

A fragmentation information file

Return value:

Table sequence

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)

Extract the fragmentation information of all specified tables.

4

=ifx_savefrag(A2,A1)

Save the fragmentation information stored in the memory as the file frag1.txt.

5

=ifx_savefrag(A2,"d:/frag2.txt")

Save the fragmentation information stored in the memory as another file frag2.txt.