[ODBC Drivers]
	IBM INFORMIX ODBC DRIVER=Installed
	[IBM INFORMIX ODBC DRIVER]
	Driver=/extra/informix/lib/cli/iclit09b.so
	Setup=/extra/informix/lib/cli/iclit09b.so
	APILevel=1
	ConnectFunctions=YYY
	DriverODBCVer=03.51
	FileUsage=0
	SQLLevel=1
	smProcessPerConnect=Y
	       

				
	[ODBC Data Sources]
	Infdrv1=IBM INFORMIX ODBC DRIVER
	Infdrv2=IBM INFORMIX ODBC DRIVER
	;
	; Define ODBC Database Driver's Below - Driver Configuration Section
	;
	[Infdrv1]
	Driver=/extra/informix/lib/cli/iclit09b.so
	Description=IBM INFORMIX ODBC DRIVER
	Database=stores_demo
	LogonID=odbc
	pwd=odbc
	Servername=ids_server1
	[Infdrv2]
	Driver=/extra/informix/lib/cli/iclis09b.so
	Description=IBM INFORMIX ODBC DRIVER
	Database=stores_demo
	LogonID=odbc
	pwd=odbc
	Servername=ids_server2
	CursorBehavior=0
	CLIENT_LOCALE=en_us.8859-1
	DB_LOCALE=en_us.8859-1
	TRANSLATIONDLL=/extra/informix/lib/esql/igo4a304.so
	;
	; UNICODE connection Section
	;
	[ODBC]
	;uncomment the below line for UNICODE connection
	;UNICODE=UCS-4
	;
	; Trace file Section
	;
	Trace=0
	TraceFile=/tmp/odbctrace.out
	InstallDir=/extra/informix
	TRACEDLL=idmrs09a.so
	       

				
	[stores7]
	Driver=/usr3/370uc1/lib/cli/iclit09b.so
	Description=IBM INFORMIX ODBC DRIVER
	Database=stores7
	LogonID=informix
	pwd=password
	Servername=irk1150
	;
	; UNICODE connection Section
	;
	[ODBC]
	;uncomment the below line for UNICODE connection
	UNICODE=UCS-2
	;
	; Trace file Section
	;
	Trace=0
	TraceFile=/tmp/odbctrace.out
	InstallDir=/usr3/370uc1
	TRACEDLL=idmrs09a.so
			

			
	informix@irk:/usr3/370uc1$ cat $INFORMIXDIR
	/usr3/csdk370
			

			
	informix@irk:/usr3/370uc1$ cat INFORMIXSQLHOSTS | grep irk1150
	irk1150 onsoctcp irk.bedfont.uk.ibm.com 9089
			

				
	informix@irk:/usr3/370uc1$ iusql -v stores7 
	+---------------------------------------+
	| Connected!                            |
	|                                       |
	| sql-statement                         |
	| help [tablename]                      |
	| quit                                  |
	|                                       |
	+---------------------------------------+
	SQL> SELECT dbinfo('version', 'major') version FROM systables WHERE tabid=1
	+--------+
	| version|
	+--------+
	| 11     |
	+--------+

	SQLRowCount returns -1
	1 rows fetched
	SQL>
			

				
	informix@irk:/usr3/370uc1$ grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UCS-4
	informix@irk:/usr3/370uc1$ iusql -v stores7 
	[unixODBC][
	[unixODBC][
	[ISQL]ERROR: Could not SQLDriverConnect
	informix@irk:/usr3/370uc1$
			

				
	$ grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UTF-8
	$ 
	$ pwd
	/usr3/datadirect/samples/demo
	$ ./demoodbc -uid informix -pwd password stores7 
	./demoodbc DataDirect Technologies, Inc. ODBC Sample Application.
	./demoodbc: will connect to data source 'stores7' as user 'informix/password'.

	First Name      Last Name       Hire Date            Salary
	----------      ---------       ---------            ------
	Tyler           Bennett         2077-06-01           32000 
	John            Rappl           2087-07-15           47000 
	George          Woltman         2082-08-07           53500 
	Adam            Smith           2088-01-15           18000 
	...
	...
	SQLFetch returns: SQL_NO_DATA_FOUND

	$
	

				
	$ grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UCS-2
	$ ./demoodbc -uid informix -pwd password stores7 
	./demoodbc DataDirect Technologies, Inc. ODBC Sample Application.
	./demoodbc: will connect to data source 'stores7' as user 'informix/password'.
	SQLConnect: Failed...
	SQLSTATE = 365
	NATIVE ERROR = 0
	MSG = 523 364

	SQLConnect: Retrying Connect.
	SQLConnect: Failed...
	SQLConnect: Retrying Connect.
	SQLConnect: Failed...
	SQLConnect: Retrying Connect.
	No connection could be established.
	$

				
	$ uname -a
	AIX portland 3 5 005929BA4C00
	$ grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UCS-2
	$ echo $INFORMIXDIR
	/usr2/support/products/SDK-3.70.UC1
	$ iusql -v stores7 informix password
	+---------------------------------------+
	| Connected!                            |
	|                                       |
	| sql-statement                         |
	| help [tablename]                      |
	| quit                                  |
	|                                       |
	+---------------------------------------+
	SQL> select tabid from systables where tabname='systables'
	+------------+
	| tabid      |
	+------------+
	| 1          |
	+------------+

	SQLRowCount returns -1
	1 rows fetched
	SQL> quit
	$
			

				
		
	$ echo $INFORMIXDIR
	/usr2/support/products/SDK-3.70.UC1
	$ cat $ODBCINI
	[stores7]
	Driver=/usr2/support/products/SDK-3.70.UC1/lib/cli/iclit09b.so
	Description=IBM INFORMIX ODBC DRIVER
	Database=stores7
	LogonID=informix
	pwd=password
	Servername=gholmes1150
	;
	; UNICODE connection Section
	;
	[ODBC]
	;uncomment the below line for UNICODE connection
	UNICODE=UTF-8
	;
	; Trace file Section
	;
	Trace=0
	TraceFile=/tmp/odbctrace.out
	InstallDir=/usr2/support/products/SDK-3.70.UC1
	TRACEDLL=idmrs09a.so
	$
			

				
	$ uname -a
	SunOS gholmes 5.9 Generic_122300-17 sun4u sparc SUNW,Ultra-5_10
	$ which iusql
	/usr/local/bin/iusql
	$ ldd /usr/local/bin/iusql
			libodbc.so.1 =>  /usr/local/lib/libodbc.so.1
			libiconv.so.2 =>         /usr/local/lib/libiconv.so.2
			libodbcinst.so.1 =>      /usr/local/lib/libodbcinst.so.1
			libltdl.so.7 =>  /usr/local/lib/libltdl.so.7
			libreadline.so.4 =>      /usr/local/lib/libreadline.so.4
			libcurses.so.1 =>        /usr/lib/libcurses.so.1
			libdl.so.1 =>    /usr/lib/libdl.so.1
			libthread.so.1 =>        /usr/lib/libthread.so.1
			libc.so.1 =>     /usr/lib/libc.so.1
			libgcc_s.so.1 =>         /usr/local/lib/libgcc_s.so.1
			/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1
	$ grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UCS-2
	$ iusql -v stores7
	+---------------------------------------+
	| Connected!                            |
	|                                       |
	| sql-statement                         |
	| help [tablename]                      |
	| quit                                  |
	|                                       |
	+---------------------------------------+
	SQL> quit
	$
	

				
	$ pwd
	/usr3/datadirect/samples/demo

	$ ldd demoodbc
			libodbc.so =>    /usr3/datadirect/lib/libodbc.so
			libCrun.so.1 =>  /usr/lib/libCrun.so.1
			libm.so.1 =>     /opt/SUNWspro/lib/libm.so.1
			libw.so.1 =>     /usr/lib/libw.so.1
			libthread.so.1 =>        /usr/lib/libthread.so.1
			libc.so.1 =>     /usr/lib/libc.so.1
			libsocket.so.1 =>        /usr/lib/libsocket.so.1
			libdl.so.1 =>    /usr/lib/libdl.so.1
			libIXicu20.so =>         /usr3/datadirect/lib/libIXicu20.so
			libodbcinst.so =>        /usr3/datadirect/lib/libodbcinst.so
			libnsl.so.1 =>   /usr/lib/libnsl.so.1
			libposix4.so.1 =>        /usr/lib/libposix4.so.1
			libmp.so.2 =>    /usr/lib/libmp.so.2
			libaio.so.1 =>   /usr/lib/libaio.so.1
			libmd5.so.1 =>   /usr/lib/libmd5.so.1
			/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1
			/usr/platform/SUNW,Ultra-5_10/lib/libmd5_psr.so.1

	$ grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UTF-8
	$ ./demoodbc -uid informix -pwd password  stores7
	./demoodbc DataDirect Technologies, Inc. ODBC Sample Application.
	./demoodbc: will connect to data source 'stores7' as user 'informix/password'.

	First Name    Last Name     Hire Date     Salary    Dept           
	----------    ---------     ---------     ------    ----           
	Tyler         Bennett       2077-06-01    32000     D101           
	John          Rappl         2087-07-15    47000     D050           
	George        Woltman       2082-08-07    53500     D101           
	…
	…
				

				
./iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.51.0001.0908

Enter ODBC connect string (? shows list): dsn=stores7;uid=informix;pwd=ximrofni
Driver:  3.50.0000 3.50.U    

SQL>select tabid from systables where tabid=1

tabid      
-----------
1          

 result set 1 returned 1 rows.


SQL>
SQL>quit

Have a nice day.#     
# grep UNICODE $ODBCINI
;uncomment the below line for UNICODE connection
UNICODE=UCS-4
#
			
				

				
	# uname -a
	HP-UX nanook B.11.11 U 9000/800 2812716602 unlimited-user license
	# grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UCS-2
	# iusql -v stores7 informix password
	+---------------------------------------+
	| Connected!                            |
	|                                       |
	| sql-statement                         |
	| help [tablename]                      |
	| quit                                  |
	|                                       |
	+---------------------------------------+
	SQL> quit
	#
				

				
	# grep UNICODE $ODBCINI
	; UNICODE connection Section
	;uncomment the below line for UNICODE connection
	UNICODE=UTF-8

	# pwd
	/usr3/products/DataDirect/samples/demo
	# ./demoodbc -uid informix -pwd password stores7
	./demoodbc DataDirect Technologies, Inc. ODBC Sample Application.
	./demoodbc: will connect to data source 'stores7' as user 'informix/password'.

	First Name    Last Name     Hire Date     Salary    Dept           
	----------    ---------     ---------     ------    ----           
	Tyler         Bennett       2077-06-01    32000     D101           
	John          Rappl         2087-07-15    47000     D050           
	George        Woltman       2082-08-07    53500     D101           
	…
	…
				

				
	informix@irk:~$ cat test.c
/*   ----- test.c ------ */

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <signal.h>
#include "sql.h"
#include "sqlext.h"

#define BUFFER_LEN      10
#define ERRMSG_LEN      200

SQLINTEGER CheckError (	SQLRETURN       rc,
        		SQLSMALLINT     handleType,
			SQLHANDLE       handle,
			SQLCHAR*        errmsg)
{
	SQLRETURN       retcode = SQL_SUCCESS;
	SQLSMALLINT     errNum = 1;
	SQLCHAR	    sqlState[6];
	SQLINTEGER      nativeError;
	SQLCHAR	    errMsg[ERRMSG_LEN];
	SQLSMALLINT     textLengthPtr;
	 
	if ((rc != SQL_SUCCESS) && (rc != SQL_SUCCESS_WITH_INFO))
	{
		while (retcode != SQL_NO_DATA)
		{
			retcode = SQLGetDiagRec (handleType, handle, errNum, sqlState, 
						&nativeError, errMsg, ERRMSG_LEN, 
						&textLengthPtr);
			if (retcode == SQL_INVALID_HANDLE)
			{
				fprintf (stderr, "SQL_INVALID_HANDLE!\n");
				return 1;
			}
			if (( retcode == SQL_SUCCESS) || 
			    ( retcode == SQL_SUCCESS_WITH_INFO))
				fprintf (stderr, "ERROR: %d:  %s : %s \n", 
				                 (int)nativeError, sqlState, errMsg);
				errNum++;
		}
		fprintf (stderr, "%s\n", errmsg);
		return 1; 
	}
	else
	return 0;
}

int main (long argc, char* argv[])
{
	SQLHDBC     hdbc;
	SQLHENV     henv;
	SQLHSTMT    hstmt;

	SQLCHAR     dsn[100]; 
	SQLRETURN   rc = 0;
	SQLINTEGER         in;

	SQLCHAR         sname[15+1];
	SQLLEN          lcode = 0;
	SQLLEN          lsname = 0;

	if (argc != 2)
	{
		fprintf (stdout, "Please specify a DSN!\n");
    	return(1);
	}
	else
	sprintf((char *) dsn,  "%s", (char *)argv[1]);

	fprintf (stdout, "Connecting to DSN : %s\n", dsn);

	rc = SQLAllocHandle (SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
	if (rc != SQL_SUCCESS)
	{
		fprintf (stdout, "SQLAllocHandle failed\n");
		return ;
	}

	rc = SQLSetEnvAttr (henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);
	if (CheckError (rc, SQL_HANDLE_ENV, henv, (SQLCHAR *) "SQLSetEnvAttr failed\n"))
	return ;

	rc = SQLAllocHandle (SQL_HANDLE_DBC, henv, &hdbc);
	if (CheckError (rc, SQL_HANDLE_ENV, henv, (SQLCHAR *) "SQLAllocHandle failed\n"))
	return ;

	rc = SQLConnect (hdbc, dsn, SQL_NTS, (SQLCHAR *) "", SQL_NTS, 
			(SQLCHAR *) "", SQL_NTS);
	if (CheckError (rc, SQL_HANDLE_DBC, hdbc, (SQLCHAR *) "SQLConnect failed\n"))
	return ;
	fprintf (stdout, "Connected to %s\n",dsn);

	rc = SQLAllocHandle (SQL_HANDLE_STMT, hdbc, &hstmt );
	if (CheckError (rc, SQL_HANDLE_DBC, hdbc, (SQLCHAR *) "SQLAllocHandle failed\n"))
	return ;

	rc = SQLPrepare (hstmt,  (SQLCHAR *) "SELECT FIRST 3 tabname FROM systables;", 
			SQL_NTS);
	if (CheckError (rc, SQL_HANDLE_STMT, hstmt, (SQLCHAR *) "SQLPrepare failed\n"))
	return ;

	rc = SQLExecute (hstmt);
	if (CheckError (rc, SQL_HANDLE_STMT, hstmt, (SQLCHAR *) "SQLExecute failed\n"))
	return ;

	rc = SQLBindCol (hstmt, 1, SQL_C_CHAR, &sname, sizeof(sname), &lsname);
	if (CheckError (rc, SQL_HANDLE_STMT, hstmt, (SQLCHAR *) "SQLBind failed\n"))
	return ;

	while ((rc = SQLFetch(hstmt))!=SQL_NO_DATA_FOUND) 
	fprintf (stdout, "TABNAME = %s\n", sname); 

	SQLFreeStmt (hstmt, SQL_CLOSE);
	SQLFreeHandle (SQL_HANDLE_STMT, hstmt);
	SQLDisconnect (hdbc);

	SQLFreeHandle (SQL_HANDLE_DBC, hdbc);
	SQLFreeHandle (SQL_HANDLE_ENV, henv);
}
	/*   ----- test.c ------ */
	

				
	informix@irk:~$ cc test.c -lodbc -o test
	informix@irk:~$ ldd test
			linux-gate.so.1 =>  (0xb8072000)
			libodbc.so.1 => /usr/local/lib/libodbc.so.1 (0xb7ff1000)
			libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7e8e000)
			libltdl.so.7 => /usr/lib/libltdl.so.7 (0xb7e85000)
			libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7e81000)
			libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7e68000)
			/lib/ld-linux.so.2 (0xb8073000)
	informix@irk:~$ ./test stores7
	Connecting to DSN : stores7
	Connected to stores7
	TABNAME = systables
	TABNAME = syscolumns
	TABNAME = sysindices
	informix@irk:~$
				

				
	[ODBC]
	; Trace file Section
	;
	Trace=Yes
	TraceFile=/tmp/odbctrace.out
				

				
	; Trace file Section
	;
	Trace=1
	TraceFile=/tmp/odbctrace.out
	InstallDir=/usr2/support/products/SDK-3.70.UC1
	TRACEDLL=idmrs09a.so
				

				
	ppid=0010303e,pid=00000001         EXIT SQLPrepare
	 SQLHSTMT        0x20154AA8
	 SQLCHAR *       select tabname from systables where tabid=1;
	 SQLINTEGER      45 with return code 0 (SQL_SUCCESS)

	ppid=0010303e,pid=00000001         EXIT SQLPrepareW
	 SQLHSTMT        0x20154AA8
	 SQLWCHAR        select tabname from systables where tabid=1;
	 SQLINTEGER      -3 with return code 0 (SQL_SUCCESS)

	ppid=0010303e,pid=00000001         ENTER SQLExecute
	 SQLHSTMT        0x20154AA8

	ppid=0010303e,pid=00000001         EXIT SQLExecute
	 SQLHSTMT        0x20154AA8 with return code 0 (SQL_SUCCESS)

	ppid=0010303e,pid=00000001         ENTER SQLNumResultCols
	 SQLHSTMT        0x20154AA8
	 SQLSMALLINT *   804399056

	ppid=0010303e,pid=00000001         EXIT SQLNumResultCols
	 SQLHSTMT        0x20154AA8
	 SQLSMALLINT *   804399056 with return code 0 (SQL_SUCCESS)
				

				
informix@irk:/usr3/370uc1$ export SQLIDEBUG=2:/tmp/sqlitrace
informix@irk:/usr3/370uc1$ iusql test informix password
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select tabid from systables where tabname='systables';
+------------+
| tabid      |
+------------+
| 1          |
+------------+

SQLRowCount returns -1
1 rows fetched
SQL> quit
informix@irk:/usr3/370uc1$ ls -la /tmp/sqlitrace*
-rwxr-xr-x 1 informix informix 766 2011-06-02 09:50 /tmp/sqlitrace_28920_12100_8627490
informix@irk:/usr3/370uc1$ 

informix@irk:/usr3/370uc1$ sqliprint -o trace.txt /tmp/sqlitrace_28920_12100_8627490
informix@irk:/usr3/370uc1$
					

				

C->S (68)                               Time: 2011-06-02 09:50:06.84851
	SQ_PREPARE
		# values: 0
		CMD.....: "select tabid from systables where tabname='systables'; " [55]
		SQ_NDESCRIBE
		SQ_WANTDONE
		SQ_EOT

S->C (62)                               Time: 2011-06-02 09:50:06.85346
		SQ_DESCRIBE
			Stmt Type...........: 2
			Server Stmt Id......: 0
			Estimated Cost......: 0
			Size of output tuple: 4
			# output fields.....: 1
			Size of string table: 6
			0) Field 'tabid'
					Index into string table: 0
					Starting offset in tuple: 0
					Type....................: SERIAL; NOT NULLABLE
					Length : 4 (0x4)
		SQ_DONE