NOTE: There were 19 observations read from the data set INFTEST1.HYBRIDTEST3. NOTE: The data set INFTEST1.HYBRIDTEST3 has 19 observations and 5 variables.ġ3? proc print data=inftest1.hybridtest3 NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: There were 19 observations read from the data set WORK.TEST3. NOTE: Table WORK.TEST3 created, with 19 rows and 5 columns. NOTE: PROCEDURE PRINT used (Total process time):ġ3? connect to informix(user=xxxxx pw=xxxxx server=xxxxx) NOTE: There were 19 observations read from the data set WORK.TEST2. NOTE: PROCEDURE SQL used (Total process time): NOTE: Table WORK.TEST2 created, with 19 rows and 5 columns. NOTE: DATA statement used (Total process time):Ĩ? create table work.test2 as select * from inftest1.class Stopped there were 0 observations and 5 variables. WARNING: The data set WORK.TEST1 may be incomplete. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE DATASETS used (Total process time):ĮRROR: Invalid sequence of commands for file. NOTE: Libref INFTEST1 was successfully assigned as follows:
NOTE: This session is executing on the Linux 2.6.32-131.6.1.el6.x86_64 (LINġ? libname inftest1 informix user=xxxxxxx pw=xxxxxxx server=xxxx Licensed to SAS INSTITUTE INC - TECH SUPPORT, Site 70143442.
NOTE: SAS (r) Proprietary Software 9.3 (TS1M2) NOTE: Copyright (c) 2002-2010 by SAS Institute Inc., Cary, NC, USA. sas93_1m2 -sasenv /saswork/rosric/acc_informix_4.10/sasenv_local -nodms Problem Scenario acc_informix_4.10]$ uname -a Release is the software release in which the problem is planned to be Operating System and Release Information Product Familyįor software releases that are not yet generally available, the Fixed
To work around this problem, install a non-hybrid driver (version 4.10 or later).
In this scenario, you can successfully use SAS/ACCESS Interface to Informix to write character data to Informix tables.
Accordingly, SAS/ACCESS Interface to Informix now accommodates this new generation of drivers.
Therefore, the drivers are no longer considered hybrids. With version 4.10, IBM began providing Informix ODBC drivers that are more in line with current ODBC specifications. SAS/ACCESS Interface to Informix relies on this driver and was originally engineered to accommodate these hybrid Informix ODBC drivers. 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.