ifx_savefrag()

Description:

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

Syntax:

ifx_savefrag(ifxconn, file)

Note:

The function 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.

Parameters:

ifxconn

An ifxconn object

file

A fragmentation information file, which can be the same file as fragfile or not.

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