Two configuration parameters, timestamp_ms_support and timestamp_format, are available to allow the DCO to insert, update, delete, and select Sybase DATETIME datatypes with the millisecond portion mapped to an Oracle TIMESTAMP column. The following sections describe the parameters and their use.
Specifies the value of the timestamp_ms_support parameter.
timestamp_ms_support
0 is off (default). 1 is on.
Specifies the Oracle timestamp format to be used by non-ASE clients.
timestamp_format
MON DD YYYY HH:MM:SSAM (default) provides the date and time in seconds, and the milliseconds portion contains 000 (zeros). MON DD YYYY HH:MS:SS.FFAM provides the date and time in milliseconds.
When you use the new configuration parameter timestamp_ms_support, consider the following conditions:
When timestamp_ms_support equals 0, Sybase TIME and DATETIME datatype is accessible, but the millisecond portion of an Oracle TIMESTAMP contains 000 (zeros).
When timestamp_ms_support equals 1, Sybase TIME and DATETIME datatype is able to insert, update, delete, or select the millisecond portion of an Oracle TIMESTAMP.
When DCO 12.6 interoperates with ASE/CIS, the version must be 12.5.1 ESD#2 or later to use the timestamp_ms_support configuration option. This is due to changes that were made in ASE/CIS 12.5.1.
When DCO 12.6 interoperates with an application other than ASE/CIS, the timestamp_format configuration setting must include the milliseconds (...SS.FF) if the millisecond portion of the time is desired, and the timestamp_ms_support parameter must be equal to 1.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
