MX Release 3.2.1 (H06.26+, J06.15+)

Table 23 Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values

in Nanosecond (continued)

Expected Value in Column of the

SQL/MX TableColumn Type

Value Specified in the Fraction of the

Client Program

0.000timestamp(3) or time(3)4321

0.98timestamp(2) or time(2)987654321

0.08timestamp(2) or time(2)87654321

0.00timestamp(2) or time(2)7654321

0.00timestamp(2) or time(2)654321

0.00timestamp(2) or time(2)54321

0.00timestamp(2) or time(2)4321

0.9timestamp(1) or time(1)987654321

0.0timestamp(1) or time(1)87654321

0.0timestamp(1) or time(1)7654321

0.0timestamp(1) or time(1)654321

0.0timestamp(1) or time(1)54321

0.0timestamp(1) or time(1)4321

If a value of the SQLFractionValue property is not specified in the ODBCDSN file (or if it is equal

to SYSTEM_DEFAULT or another value different from 9) and when a timestamp struct value is

retrieved using a C/C++ program from a column with type time or timestamp, the fraction field

selects the SYSTEM_DEFAULT values, which are listed in Table 24.

Table 24 SYSTEM_DEFAULT Values Retrieved Using a C/C++ Program

Value in the Fraction of the Client

ProgramColumn Type

Value in the Column of the SQL/MX

Table

987654timestamp(6) or time(6)0.987654

87654timestamp(6) or time(6)0.087654

7654timestamp(6) or time(6)0.007654

654timestamp(6) or time(6)0.000654

54timestamp(6) or time(6)0.000054

4timestamp(6) or time(6)0.000004

98765timestamp(5) or time(5)0.98765

8765timestamp(5) or time(5)0.08765

765timestamp(5) or time(5)0.00765

65timestamp(5) or time(5)0.00065

5timestamp(5) or time(5)0.00005

0timestamp(5) or time(5)0.00000

9876timestamp(4) or time(4)0.9876

876timestamp(4) or time(4)0.0876

76timestamp(4) or time(4)0.0076

7timestamp(4) or time(4)0.0007

44 ODBC/MX Conformance