Description:
Create Informix database connection.
Syntax:
ifx_conn(url; fragfile)
ifx_conn(driver,url; fragfile)
Note:
The external library function (See External Library Guide) connects to the external Informix database. The format of the parameter url is the same as that of the JDBC URL.
Parameter:
|
driver |
Name of JDBC driver for connecting to Informix database; the format is com.informix.jdbc.IfxDriver |
|
url |
The URL to connect to Informix server |
|
fragfile |
Fragmentation information file that records the fields and every field’s max and min values in each fragmented file |
Return value:
Ifxconn object
Example:
|
|
A |
|
|
1 |
="d:/frag.txt" |
A fragmentation information file. |
|
2 |
=ifx_conn("com.informix.jdbc.IfxDriver","jdbc:informix-sqli://192.168.0.3:9088/tpch:informixserver=tpch&user=informix&pwd=informix";A1) |
Connect to Informix database and get the fragmentation information as a file handle. |
|
3 |
=ifx_conn("com.informix.jdbc.IfxDriver","jdbc:informix-sqli://192.168.0.3:9088/tpch:informixserver=tpch&user=informix&pwd=informix";"d:/frag.txt") |
Connect to Informix database and get the fragmentation information as a file. |