|SAS/ACCESS Software for Relational Databases: Reference|
Every column in a table has a name and a data type. The data type tells Informix how much physical storage to set aside for the column and the form in which the data is stored. Informix data types fall into three categories: types for character data, types for numeric data, and types for abstract values such as dates. Each of these types is described in the following sections.
This section describes how the LIBNAME statement and the SQL Procedure Pass-Through Facility treat each of these types during input operations.
|NULL and Default Values|
If you do not indicate a default value for a column, the default value is NULL. You can specify the keywords NOT NULL after the data type of the column when you create a table to prevent NULL values from being stored in the column.
|LIBNAME Statement Data Conversions|
The following table shows the default SAS variable formats that the LIBNAME statement applies to Informix data types during input operations. You can override these default data types by using the DBTYPE= data set option on a specific data set.
|Informix Column Type||Default SAS Format|
NLS support required
NLS support required
|*Only supported by
**If the Informix field qualifier specifies either HOUR, MINUTE, SECOND, or FRACTION as the largest unit, the value is converted to a SAS TIME value. All others, such as YEAR, MONTH, or DAY, are converted to a SAS DATETIME value.
The following table shows the default Informix data types that the LIBNAME statement applies to SAS variable formats during output operations.
|SAS Variable Format||Informix Data Type|
|w. with SAS format name of NULL||FLOAT|
|w.d with SAS format name of NULL||FLOAT|
|all other numerics||FLOAT|
||DATETIME YEAR TO FRACTION(5)|
|time.||DATETIME HOUR TO FRACTION(5)|
|SQL Procedure Pass-Through Facility Data Conversions|
The SQL Procedure Pass-Through Facility uses the same default conversion formats as the LIBNAME statement. See LIBNAME Statement Data Conversions for the conversion tables.
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.