Hp Integrity NonStop H-Series Bedienungsanleitung PDF herunterladen (Seite 42)

Table 10 Transaction and cursor behavior

Application actionSQL/MX behaviorAUTOCOMMIT

Not applicableWhen any open statement reaches

end of data or end of cursor, SQL/MX

closes all other open statements.

The application must explicitly rollback

or commit the transaction. All open

statements are closed at that time.

Not applicableOFF

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 tableColumn typeFraction value in the application

0.987654timestamp(6) or time(6)987654

0.087654timestamp(6) or time(6)87654

0.007654timestamp(6) or time(6)7654

0.000654timestamp(6) or time(6)654

0.000054timestamp(6) or time(6)54

0.000004timestamp(6) or time(6)4

0.98765timestamp(5) or time(5)987654

0.08765timestamp(5) or time(5)87654

0.00765timestamp(5) or time(5)7654

0.00065timestamp(5) or time(5)654

0.00005timestamp(5) or time(5)54

0.00000timestamp(5) or time(5)4

0.9876timestamp(4) or time(4)987654

0.0876timestamp(4) or time(4)87654

0.0076timestamp(4) or time(4)7654

0.0006timestamp(4) or time(4)654

0.0000timestamp(4) or time(4)54

0.0000timestamp(4) or time(4)4

0.987timestamp(3) or time(3)987654

0.087timestamp(3) or time(3)87654

0.007timestamp(3) or time(3)7654

0.000timestamp(3) or time(3)654

42 Compatibility and considerations

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 61 62

Keine Kommentare

Hp Integrity NonStop H-Series Bedienungsanleitung Seite 42