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

Table 10 Transaction and cursor behavior
Application action SQL/MX behavior AUTOCOMMIT
Not applicable When any open statement reaches
end of data or end of cursor, SQL/MX
closes all other open statements. ON
The application must explicitly rollback
or commit the transaction. All open
statements are closed at that time. Not applicable OFF
Timestamp values with fraction
The SQLFractionValue attribute indicates whether the fraction value for SQL_C_TIMESTAMP data
type must be in nanoseconds or microseconds. If set to 9, the fraction value is in nanoseconds. If
set to SQL_DEFAULT, not specified, or set to a value other than 9, the fraction value is in
microseconds.
Table 11 includes a set of sample values and expected values in the column of an SQL/MX table
in microseconds.
Table 11 Sample values inserted from an application and expected values in microsecond
Expected value in the column of
SQL/MX table
Column type Fraction value in the application
0.987654 timestamp(6) or time(6) 987654
0.087654 timestamp(6) or time(6) 87654
0.007654 timestamp(6) or time(6) 7654
0.000654 timestamp(6) or time(6) 654
0.000054 timestamp(6) or time(6) 54
0.000004 timestamp(6) or time(6) 4
0.98765 timestamp(5) or time(5) 987654
0.08765 timestamp(5) or time(5) 87654
0.00765 timestamp(5) or time(5) 7654
0.00065 timestamp(5) or time(5) 654
0.00005 timestamp(5) or time(5) 54
0.00000 timestamp(5) or time(5) 4
0.9876 timestamp(4) or time(4) 987654
0.0876 timestamp(4) or time(4) 87654
0.0076 timestamp(4) or time(4) 7654
0.0006 timestamp(4) or time(4) 654
0.0000 timestamp(4) or time(4) 54
0.0000 timestamp(4) or time(4) 4
0.987 timestamp(3) or time(3) 987654
0.087 timestamp(3) or time(3) 87654
0.007 timestamp(3) or time(3) 7654
0.000 timestamp(3) or time(3) 654
42 Compatibility and considerations