ifx_conn()

Read(235) Label: create database connection,

Description:

Create Informix database connection.

Syntax:

ifx_conn(url; fragfile)

ifx_conn(driver,url; fragfile)

Note:

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