Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Beginning in Version 7 of the SAS/ACCESS Interface to Informix, you can
no longer query an Informix table containing a column defined with
DATETIME precision.  You will receive the following error message:

  ERROR:  SAS/ACCESS does not support Informix DATATEIME (precision) to
  (precision).  Delete the column or extend it to YEAR to DAY if you
  want to read and display the column within SAS.

A circumvention is to use the EXTEND function in the SQL Passthrough
procedure to convert the precision of the DATETIME field.  For example,

   proc sql;
    connect to informix(database=dbprod);
    select * from connection to informix
      (select name, age, extend(hiremonth, year to month) as hiredate
           from informixtab);
   quit;

The DATETIME column was automatically extended in Version 6.12 and no
error message was given.


A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005027

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: