Description:
Create Informix database connection.
Syntax:
ifx_conn(url; fragfile)
ifx_conn(driver,url; fragfile)
Note:
The InformixCli 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. |