Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Set the SQL Interval Behaviour property using the ODBCDSN property.
• The following example describes when the value of SQL Interval Behaviour is set to
SYSTEM_DEFAULT, the behavior of the driver 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 27 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.1
11
22:33:44
11 22:33:44.100000
11
22:33:44.1234
11
22:33:44.123
11
22:33:44.12
11
22:33:44.1
11
22:33:44
11 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 values are inserted as follows:
Table 28 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.1
11 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.1
11 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