Owner's manual

If not specified, the default is SYSTEM_DEFAULT.
Set the SQL Interval Behaviour property using the MXODSN property.
• The following example describes when the value of SQL Interval Behaviour is set to
SYSTEM_DEFAULT, the behavior of the drivers is same as in earlier releases of SQL/MX. In
this example, zeroes are suffixed in the following way:
For example,
create table interval_frac
(
ID2S interval day to second,
ID2S0 interval day to second (0),
ID2S1 interval day to second (1),
ID2S2 interval day to second (2),
ID2S3 interval day to second (3),
ID2S4 interval day to second (4)
)
For the above DDL, when you insert values for all columns as 11 22:33:44.1 and 02
11:21:12.1234 binding to valid datatypes, the values are inserted as follows:
Table 16 SQL Interval Behaviour property set to SYSTEM_DEFAULT
ID2S4ID2S3ID2S2ID2S1ID2S0ID2S
11
22:33:44.1000
11
22:33:44.100
11
22:33:44.10
11 22:33:44.111 22:33:4411
22:33:44.100000
11
22:33:44.1234
11
22:33:44.123
11
22:33:44.12
11 22:33:44.111 22:33:4411
22:33:44.123400
• The following example describes when the SQL Interval Behaviour property is set to
MSDN_DEFAULT. In this example, zeroes are prefixed in the following way:
For example,
create table interval_frac
(
ID2S interval day to second,
ID2S0 interval day to second (0),
ID2S1 interval day to second (1),
ID2S2 interval day to second (2),
ID2S3 interval day to second (3),
ID2S4 interval day to second (4)
)
For the above DDL, when you insert values for all columns as 11 22:33:44.1 and 02
11:21:12.1234 binding to valid datatypes, the following values are inserted:
Table 17 SQL Interval Behaviour property set to MSDN_DEFAULT
ID2S4ID2S3ID2S2ID2S1ID2S0ID2S
11
22:33:44.0001
11
22:33:44.001
11
22:33:44.01
11 22:33:44.111 22:33:4411
22:33:44.000001
11
22:33:44.1234
11
22:33:44.123
11
22:33:44.12
11 22:33:44.111 22:33:4411
22:33:44.001234
NOTE: In the above examples, the SQL Fraction Precision Value is set to
SYSTEM_DEFAULT (microseconds).
SQL Interval Behaviour property 47