|  | Appendix: Model elements support for Informix servers
There is extensive support for Informix servers in InfoSphere Data
Architect. Most of them have been enhanced with IDA 7.5.1. Here is a
list on what all database elements supported in the tool for Informix,
including Informix Data types:
- Elements supported in the different models
- Schema
- User
- Role
- Table
- View
- Synonym (Alias)
- Distinct user defined type
- Stored Procedure
- Function
- Sequence
- Column
- Index
- Foreign Key
- Constraints
- Trigger
- Informix Data types supported
- Blob
- Boolean
- Byte
- Char
- Clob
- Date
- DateTime
- Decimal
- Double
- Float
- Int8
- Integer
- Interval
- LVarchar
- Money
- NChar
- NVarchar
- Numeric
- Serial
- Serial8
- Smallint
- Smallfloat
- Text
- Varchar
- Other user defined types that you have created
- Generation of DDL for all of the above elements
- Generation of delta DDL when changes are made to the physical
model and need to be synced up with the database. This generates
appropriate ALTER statements (for instances like addition of a new
column to a table, or changing the data type for a column to a
compatible data type, and so on), or a more complete set of statements
for managing the changes.
| |
|
