Even though DMSII does not have a date data type, most DMSII sites use several common methods to store dates. This section includes ways to decode these types of date representations into a relational database date data type.
The DATABridge Client supports the following DMSII date encoding methods:
Choosing the SQL Data Type of the Relational Database Column
Regardless of the original DMSII date structure, the resulting relational database column has a sql_type of 12 (smalldatetime) in the case of SQL Server and a sql_type of 10 (date) in the case of Oracle.
To make the Client map a DMS item to a column that is a date data type, you must set the bit DIOPT_Clone_as_Date (2) in the di_options column of the corresponding DMS_ITEMS entry using the script.user_layout.dataset user script.
SQL Server supports the multiple date data type. You can make the Client generate different types of dates by using the script.user_layout.dataset user script to set the following bits in the di_options column of the corresponding DMS_ITEMS table entry:
For an example script, see Changing SQL Data Types.