This is common list of assumptions we have for all drivers:

1. Indexed columns are created as NOT NULL and should have a default value assigned to.

2. Tables are created with the table names with uppercase letters in Flex2SQL, ORAFlex and DB2Flex.

3. Partial Overlaps are created as a physical column if it is an indexed column only, otherwise it will be handled logically at run time.

4. Date formats:

• Flex2SQL for Oracle: 01/01/0001 is the default DATE value for the empty date fields.
• Flex2SQL for MS SQL Server: 01/01/1753 is the default DATE value for the empty date fields.
• Flex2SQL for MySQL: 01/01/0001 is the default DATE value for the empty date fields.
• Flex2SQL for PostgreSQL: 01/01/0001 is the default DATE value for the empty date fields.

This entry was posted on Monday, February 25th, 2008 at 5:12 pm and is filed under DB2, DBMS, Microsoft SQL Server, MySQL, Oracle, PostgreSQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.