Specifies whether DataWindow Designer should map DateTime and Time datatypes to the Oracle TimeStamp datatype.
O90 Oracle9i
O10 Oracle 10g
TimeStamp=value
TimeStamp=1
Oracle9i and later databases and the O90 and O10 interfaces support the Oracle timestamp datatype. This datatype includes the date and the time including milliseconds. The existing Oracle Date datatype does not include millisecond information. In a DataWindow object, both the Oracle Timestamp and Date datatypes are mapped to the DataWindow Designer DateTime datatype, which supports millisecond information.
If you use the O90 or O10 interface with an Oracle9i or higher server, DateTime and Time datatypes are mapped to the Oracle TimeStamp datatype by default. If you want DateTime and Time to be mapped to the Oracle Date datatype, set the TimeStamp database parameter to 0.
The TimeStamp database parameter does not apply to the O84 database interface. When you use the O84 interface, the DateTime and Time datatypes are always mapped to the Oracle Date datatype.
If you are using the O90or O10 interface with a database that uses only the TimeStamp datatype, DataWindow Designer handles DataWindow updates correctly. If you are using the O90 or O10 interface with a database that uses only the Oracle Date datatype, set the DbParameter TimeStamp to 0 to truncate millisecond information.
To set the TimeStamp value to treat DateTime and Time DataWindow datatypes as Oracle Date datatypes:
Database profile Clear the Map DateTime/Time to
Oracle Timestamp check box on the Syntax page
in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter="TimeStamp=0"
