HP Integrity NonStop H-Series - Manual (Page 47)

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
ID2S4 ID2S3 ID2S2 ID2S1 ID2S0 ID2S
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 following values are inserted:
Table 17 SQL Interval Behaviour property set to MSDN_DEFAULT
ID2S4 ID2S3 ID2S2 ID2S1 ID2S0 ID2S
11
22:33:44.0001 11
22:33:44.001 11
22:33:44.01 11 22:33:44.1 11 22:33:44 11
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:44 11
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