Description:
Save the fragmentation information file stored in the memory as a new file.
Syntax:
ifx_savefrag(ifxconn, file)
Note:
The external library 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.
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 |