Hp Integrity NonStop H-Series Manuel d'utilisateur télécharger pdf (Page 48)

SQL Datetime Retrieval property

The SQL Datetime Retrieval specifies how the SQL/MP Datetime data type is retrieved from

the drivers. The SQL Datetime Retrieval has two values:

• SYSTEM_DEFAULT — Year is set to 0001.

• MSDN_DEFAULT — Year is set to 1900.

If not specified, the default is SYSTEM_DEFAULT. This property is applicable only when SQL/MP

Datetime datatype is bound to SQL/MX datatypes such as DATE or TIMESTAMP.

Set the SQL Datetime Retrieval property using the MXODSN property.

• If the value of SQL Datetime Retrieval is set to SYSTEM_DEFAULT, the behavior of the

drivers is the same as in earlier releases of SQL/MX.

For example,

1. Create a table in SQL/MP with Datetime column as month to day.

2. Insert the data 12–31 into the table using SQL/MX or SQL/MP.

3. Retrieve the column data from the driver by binding to DATE. The retrieved value is

0001-12-31.

• If the value of SQL Datetime Retrieval is set to MSDN_DEFAULT, there is a change in

the behavior of the driver when compared to earlier releases of SQL/MX.

For example,

1. Create a table in SQL/MP with Datetime column as month to day.

2. Insert the data 12–31 into the created table using SQL/MX or SQL/MP.

3. Retrieve the column data from the driver by binding to DATE. The retrieved value is

1900-12-31.

48 Compatibility and considerations

1 2 ... 43 44 45 46 47 48 49 50 51 52 53 ... 61 62

Pas de commentaire

Hp Integrity NonStop H-Series Manuel d'utilisateur Page 48