Installation Note 57841: SAS/ACCESS® Interface to Informix requires Informix client version 4.10.FC4 for SAS® 9.4 TS1M3
 |  |  |  |  |
Prior to version 4.10, the Informix ODBC driver provided by IBM for UNIX platforms was a "hybrid," which means that it was built on an older ODBC model using 32-bit data types. SAS/ACCESS Interface to Informix relies on this driver and was originally engineered to accommodate these hybrid Informix ODBC drivers.
With version 4.10, IBM began providing Informix ODBC drivers that are more in line with current ODBC specifications. Therefore, the drivers are no longer considered hybrids. Accordingly, SAS/ACCESS Interface to Informix now accommodates this new generation of drivers. Beginning with SAS® 9.4 TS1M3, the baseline version of the IBM Informix driver that SAS supports with SAS/ACCESS Interface to Informix is version 4.10. With SAS 9.4 TS1M2 and earlier versions of SAS, SAS/ACCESS Interface to Informix works with Informix versions prior to version 4.10.
Due to this change in the Informix ODBC driver, it is possible that problems will occur. See the two scenarios described below.
Problem Scenario 1: SAS 9.3 TS1M2 with Informix 4.10
See the Output tab for content relevant to this scenario.
In SAS releases earlier than SAS 9.4 TS1M3, SAS/ACCESS Interface to Informix expects that a hybrid Informix driver is used. However, if you use the Informix version 4.10 driver, then you might encounter the following problems:
- You can assign a SAS/ACCESS Interface to Informix LIBNAME statement, but DATASETS procedure code that references this libref does not yield a complete list of tables.
- You cannot successfully submit DATA step code that references this libref.
- You can submit SQL procedure code that references this libref, but Informix character data values are read in as missing values.
To work around this problem, install a hybrid driver (pre-4.10 version).
Problem Scenario 2: SAS 9.4 TS1M3 with Informix 3.50
See the Output tab for content relevant to this scenario.
In SAS 9.4 TS1M3 and later versions of SAS, SAS/ACCESS Interface to Informix works with the current (NOT hybrid) versions of the IBM provided Informix driver. If you use a hybrid Informix version 3.50 driver, problems such as the following might occur:
- You can successfully assign a SAS/ACCESS Interface to Informix libref and successfully submit DATA step code that references this libref, and you can submit PROC DATASETS code against this libref and get a complete list of Informix tables. However, when you submit DATA step code that references this libref to read from Informix tables, character data is read in as missing values.
- When you submit PROC SQL code that references this libref to read from Informix tables, character data is read in as missing values.
- When you try to read from Informix via PROC SQL explicit pass-through code, Informix character data is read in as missing values. In this scenario, you can successfully use SAS/ACCESS Interface to Informix to write character data to Informix tables.
To work around this problem, install a non-hybrid driver (version 4.10 or later).
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Solaris for x64 | 9.4_M3 | 9.4 TS1M3 | ||
| Linux for x64 | 9.4_M3 | 9.4 TS1M3 | ||||
| HP-UX IPF | 9.4_M3 | 9.4 TS1M3 | ||||
| 64-bit Enabled Solaris | 9.4_M3 | 9.4 TS1M3 | ||||
| 64-bit Enabled AIX | 9.4_M3 | 9.4 TS1M3 | ||||
Problem Scenario 1:
[sastac1@cumulus acc_informix_4.10]$ uname -a
Linux cumulus.unx.sas.com 2.6.32-131.6.1.el6.x86_64 #1 SMP Mon Jun 20 14:15:38 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
[sastac1@cumulus acc_informix_4.10]$ cat sasenv_local
export INFORMIXDIR=/TECHDBI/informix2/4.10.FC1
export ODBCINI=/saswork/rosric/acc_informix_4.10/odbc.ini
export LD_LIBRARY_PATH=$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH
[sastac1@cumulus acc_informix_4.10]$ ./sas93_1m2 -sasenv /saswork/rosric/acc_informix_4.10/sasenv_local -- -nodms
NOTE: Copyright (c) 2002-2010 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.3 (TS1M2)
Licensed to SAS INSTITUTE INC - TECH SUPPORT, Site 70143442.
NOTE: This session is executing on the Linux 2.6.32-131.6.1.el6.x86_64 (LIN
X64) platform.
.
.
.
NOTE: SAS initialization used:
real time 0.09 seconds
cpu time 0.03 seconds
1? libname inftest1 informix user=xxxxxxx pw=xxxxxxx server=xxxx;
NOTE: Libref INFTEST1 was successfully assigned as follows:
Engine: INFORMIX
Physical Name:
2? proc datasets library=inftest1;
Directory
Libref INFTEST1
Engine INFORMIX
Physical Name
User dbitest
DBMS
Member Member
# Type Type
1 DATA
3? quit;
NOTE: PROCEDURE DATASETS used (Total process time):
real time 2.69 seconds
cpu time 0.02 seconds
4? data work.test1;
5? set inftest1.class;
6? run;
ERROR: Invalid sequence of commands for file INFTEST1.CLASS.DATA.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEST1 may be incomplete. When this step was
stopped there were 0 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 26.99 seconds
cpu time 0.00 seconds
7? proc sql;
8? create table work.test2 as select * from inftest1.class;
NOTE: Table WORK.TEST2 created, with 19 rows and 5 columns.
9? quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 30.41 seconds
cpu time 0.00 seconds
10? proc print data=work.test2;
11? run;
The SAS System 1
10:44 Wednesday, May 4, 2016
Obs name sex age height weight
1 14 69.0 112.5
2 13 56.5 84.0
3 13 65.3 98.0
4 14 62.8 102.5
5 14 63.5 102.5
6 12 57.3 83.0
7 12 59.8 84.5
8 15 62.5 112.5
9 13 62.5 84.0
10 12 59.0 99.5
11 11 51.3 50.5
12 14 64.3 90.0
13 12 56.3 77.0
14 15 66.5 112.0
15 16 72.0 150.0
16 12 64.8 128.0
The SAS System 2
10:44 Wednesday, May 4, 2016
Obs name sex age height weight
17 15 67.0 133
18 11 57.5 85
19 15 66.5 112
NOTE: There were 19 observations read from the data set WORK.TEST2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.10 seconds
cpu time 0.00 seconds
12? proc sql;
13? connect to informix(user=xxxxx pw=xxxxx server=xxxxx);
14? create table work.test3 as
15? select * from connection to informix
16? (select * from class);
NOTE: Table WORK.TEST3 created, with 19 rows and 5 columns.
17? disconnect from informix;
18? quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 1:21.93
cpu time 0.01 seconds
19? proc print data=work.test3;
20? run;
The SAS System 1
10:49 Wednesday, May 4, 2016
Obs name sex age height weight
1 14 69.0 112.5
2 13 56.5 84.0
3 13 65.3 98.0
4 14 62.8 102.5
5 14 63.5 102.5
6 12 57.3 83.0
7 12 59.8 84.5
8 15 62.5 112.5
9 13 62.5 84.0
10 12 59.0 99.5
11 11 51.3 50.5
12 14 64.3 90.0
13 12 56.3 77.0
14 15 66.5 112.0
15 16 72.0 150.0
16 12 64.8 128.0
The SAS System 2
10:49 Wednesday, May 4, 2016
Obs name sex age height weight
17 15 67.0 133
18 11 57.5 85
19 15 66.5 112
NOTE: There were 19 observations read from the data set WORK.TEST3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.57 seconds
cpu time 0.02 seconds
10? data inftest1.hybridtest3;
11? set sashelp.class;
12? run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set INFTEST1.HYBRIDTEST3 has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 11.40 seconds
cpu time 0.00 seconds
13? proc print data=inftest1.hybridtest3;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 11.91 seconds
cpu time 0.01 seconds
14? run;
WARNING: During read: [Informix][Informix ODBC Driver]Data truncated. :
[Informix][Informix ODBC Driver]Data truncated.
The SAS System 1
11:32 Wednesday, May 4, 2016
Obs name sex age height weight
1 14 69.0 112.5
2 13 56.5 84.0
3 13 65.3 98.0
4 14 62.8 102.5
5 14 63.5 102.5
6 12 57.3 83.0
7 12 59.8 84.5
8 15 62.5 112.5
9 13 62.5 84.0
10 12 59.0 99.5
11 11 51.3 50.5
12 14 64.3 90.0
13 12 56.3 77.0
14 15 66.5 112.0
15 16 72.0 150.0
16 12 64.8 128.0
The SAS System 2
11:32 Wednesday, May 4, 2016
Obs name sex age height weight
17 15 67.0 133
18 11 57.5 85
19 15 66.5 112
NOTE: There were 19 observations read from the data set INFTEST1.HYBRIDTEST3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 10.33 seconds
cpu time 0.00 seconds
Problem Scenario 2:
[sastac1@cumulus acc_informix_3.5.0]$ uname -a
Linux cumulus.unx.sas.com 2.6.32-131.6.1.el6.x86_64 #1 SMP Mon Jun 20 14:15:38 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
[sastac1@cumulus acc_informix_3.5.0]$ cat sasenv_local
export INFORMIXDIR=/TECHDBI/informix2/3.50.FC1
export ODBCINI=/saswork/rosric/acc_informix_3.5.0/odbc.ini
export LD_LIBRARY_PATH=$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH
[sastac1@cumulus acc_informix_3.5.0]$ ./sas94_ts1m3 -sasenv /saswork/rosric/acc_informix_3.5.0/sasenv_local -- -nodms
NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.
WARNING: Unable to copy SASUSER registry to WORK registry. Because of this,
you will not see registry customizations during this session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M3)
NOTE: This session is executing on the Linux 2.6.32-131.6.1.el6.x86_64 (LIN
X64) platform.
.
.
.
NOTE: SAS initialization used:
real time 0.03 seconds
cpu time 0.02 seconds
1? libname inftest1 informix user=xxxxx password=xxxxx server=xxxxx;
NOTE: Libref INFTEST1 was successfully assigned as follows:
Engine: INFORMIX
Physical Name:
2? proc datasets library=inftest1;
NOTE: Due to the PRESERVE_TAB_NAMES=NO libname option setting, 6 table(s)
have not been displayed/returned.
Directory
Libref INFTEST1
Engine INFORMIX
Physical Name
User dbitest
DBMS
Member Member
# Name Type Type
1 AINP28A DATA TABLE
2 AMY1 DATA TABLE
3 CLASS DATA TABLE
4 CST DATA TABLE
5 CUSTOMERS DATA TABLE
6 DBCONNECTOR_LIN64 DATA TABLE
7 DEPT DATA TABLE
8 DEPTNAMES DATA TABLE
9 EMP DATA TABLE
10 EMPLINFO DATA TABLE
11 EMPLOYEES DATA TABLE
12 FITNESS1 DATA TABLE
13 GMAP17AK DATA TABLE
14 HEIKE DATA TABLE
15 HEIKE2 DATA TABLE
16 HEIKE3 DATA TABLE
17 HEIKE4 DATA TABLE
18 INFORMIX_NULL_TEST DATA TABLE
19 INFTEST DATA TABLE
20 INF_NULL_TEST DATA TABLE
21 INF_NULL_TEST2 DATA TABLE
22 INVOICE DATA TABLE
23 KAH DATA TABLE
24 KAH2 DATA TABLE
25 KAH3 DATA TABLE
26 MYTAB DATA TABLE
27 MYTESTTAB DATA TABLE
28 NEWPAYROLL DATA TABLE
29 NEWPRO3 DATA TABLE
30 NFDATA08 DATA TABLE
31 NFDATTIM DATA TABLE
32 NFDECIMAL DATA TABLE
33 NFDTTM2 DATA TABLE
34 NFMONEY DATA TABLE
35 NFSERIAL DATA TABLE
36 NFVARCHAR DATA TABLE
37 NULL_TEST DATA TABLE
38 ORD DATA TABLE
39 ORDERS DATA TABLE
40 PHILTAB DATA TABLE
41 PPLYHE14 DATA TABLE
42 ROSS_NULL_TEST DATA TABLE
43 R_BOOLEAN DATA TABLE
44 S0016096 DATA TABLE
45 SHIPPED DATA TABLE
46 SPECIALPRODUCTS DATA TABLE
47 SQL52 DATA TABLE
48 TEST123 DATA TABLE
49 TEST5 DATA TABLE
50 TEST5A DATA TABLE
51 TMP036X DATA TABLE
52 TMP051X DATA TABLE
53 TMP062X1 DATA TABLE
54 TMP145X DATA TABLE
55 TMP166X DATA TABLE
56 TMP195X DATA TABLE
57 TMP245X DATA TABLE
58 TMP368X DATA TABLE
59 TMP401X DATA TABLE
60 TMP409X1 DATA TABLE
61 TMP573X DATA TABLE
62 TMP619X DATA TABLE
63 TMP646X DATA TABLE
64 TMP777X DATA TABLE
65 TMP796X DATA TABLE
66 TMP865X DATA TABLE
67 XYZSALES DATA TABLE
3? quit;
NOTE: PROCEDURE DATASETS used (Total process time):
real time 17.46 seconds
cpu time 0.03 seconds
4? data work.test1;
5? set inftest1.class;
6? run;
NOTE: There were 19 observations read from the data set INFTEST1.CLASS.
NOTE: The data set WORK.TEST1 has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 8.40 seconds
cpu time 0.01 seconds
7? proc print data=work.test1;
8? run;
The SAS System 1
11:12 Wednesday, May 4, 2016
Obs name sex age height weight
1 14 69.0 112.5
2 13 56.5 84.0
3 13 65.3 98.0
4 14 62.8 102.5
5 14 63.5 102.5
6 12 57.3 83.0
7 12 59.8 84.5
8 15 62.5 112.5
9 13 62.5 84.0
10 12 59.0 99.5
11 11 51.3 50.5
12 14 64.3 90.0
13 12 56.3 77.0
14 15 66.5 112.0
15 16 72.0 150.0
16 12 64.8 128.0
The SAS System 2
11:12 Wednesday, May 4, 2016
Obs name sex age height weight
17 15 67.0 133
18 11 57.5 85
19 15 66.5 112
NOTE: There were 19 observations read from the data set WORK.TEST1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.44 seconds
cpu time 0.00 seconds
9? proc sql;
10? create table work.test2 as
11? select * from inftest1.class;
NOTE: Table WORK.TEST2 created, with 19 rows and 5 columns.
12? quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 42.62 seconds
cpu time 0.00 seconds
13? proc print data=work.test2;
14? run;
The SAS System 3
11:12 Wednesday, May 4, 2016
Obs name sex age height weight
1 14 69.0 112.5
2 13 56.5 84.0
3 13 65.3 98.0
4 14 62.8 102.5
5 14 63.5 102.5
6 12 57.3 83.0
7 12 59.8 84.5
8 15 62.5 112.5
9 13 62.5 84.0
10 12 59.0 99.5
11 11 51.3 50.5
12 14 64.3 90.0
13 12 56.3 77.0
14 15 66.5 112.0
15 16 72.0 150.0
16 12 64.8 128.0
The SAS System 4
11:12 Wednesday, May 4, 2016
Obs name sex age height weight
17 15 67.0 133
18 11 57.5 85
19 15 66.5 112
NOTE: There were 19 observations read from the data set WORK.TEST2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 4.03 seconds
cpu time 0.00 seconds
15? proc sql;
16? connect to informix(user=xxxxx password=xxxxx server=xxxxx);
17? create table work.test3 as
18? select * from connection to informix
19? (select * from class);
NOTE: Table WORK.TEST3 created, with 19 rows and 5 columns.
20? disconnect from informix;
21? quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 52.15 seconds
cpu time 0.01 seconds
22? proc print data=work.test3;
23? run;
The SAS System 5
11:12 Wednesday, May 4, 2016
Obs name sex age height weight
1 14 69.0 112.5
2 13 56.5 84.0
3 13 65.3 98.0
4 14 62.8 102.5
5 14 63.5 102.5
6 12 57.3 83.0
7 12 59.8 84.5
8 15 62.5 112.5
9 13 62.5 84.0
10 12 59.0 99.5
11 11 51.3 50.5
12 14 64.3 90.0
13 12 56.3 77.0
14 15 66.5 112.0
15 16 72.0 150.0
16 12 64.8 128.0
The SAS System 6
11:12 Wednesday, May 4, 2016
Obs name sex age height weight
17 15 67.0 133
18 11 57.5 85
19 15 66.5 112
NOTE: There were 19 observations read from the data set WORK.TEST3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.45 seconds
cpu time 0.00 seconds
26? data inftest1.hybridtest5;
27? set sashelp.class;
28? run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set INFTEST1.HYBRIDTEST5 has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 7.34 seconds
cpu time 0.01 seconds
29? proc print data=inftest1.hybridtest5;
30? run;
The SAS System 1
11:44 Wednesday, May 4, 2016
Obs name sex age height weight
1 Alfred M 14 69.0 112.5
2 Alice F 13 56.5 84.0
3 Barbara F 13 65.3 98.0
4 Carol F 14 62.8 102.5
5 Henry M 14 63.5 102.5
6 James M 12 57.3 83.0
7 Jane F 12 59.8 84.5
8 Janet F 15 62.5 112.5
9 Jeffrey M 13 62.5 84.0
10 John M 12 59.0 99.5
11 Joyce F 11 51.3 50.5
12 Judy F 14 64.3 90.0
13 Louise F 12 56.3 77.0
14 Mary F 15 66.5 112.0
15 Philip M 16 72.0 150.0
16 Robert M 12 64.8 128.0
The SAS System 2
11:44 Wednesday, May 4, 2016
Obs name sex age height weight
17 Ronald M 15 67.0 133
18 Thomas M 11 57.5 85
19 William M 15 66.5 112
NOTE: There were 19 observations read from the data set INFTEST1.HYBRIDTEST5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.01 seconds
cpu time 0.02 seconds
| Type: | Installation Note |
| Priority: | high |
| Date Modified: | 2016-11-18 14:14:47 |
| Date Created: | 2016-03-11 10:35:14 |