Skip to content

DF_DRIVER_MAP_DFDATETIME_TO_SQLTYPE

Determines which SQL data type the DataFlex DateTime data type is mapped to.

Level

Database

Supported by

  • Microsoft SQL Server
  • IBM DB2 Drivers, revision 6 and higher

Type

Integer, temporary

Access

Read/Write

Values

{DataType} must be a string constant or variable and can be one of:

  • Microsoft SQL Server: "datetime", "datetime2"
  • IBM DB2: "timestamp"

  • See Type Mappings for all possible types.

Syntax

Use cli.pkg
Get_Attribute DF_DRIVER_MAP_DFDATETIME_TO_SQLTYPE of {driverNumber} to {StringVariable}
Set_Attribute DF_DRIVER_MAP_DFDATETIME_TO_SQLTYPE of {driverNumber} to {DataType}

Driver Configuration Keyword

MAP_DFDATETIME_TO_SQLTYPE

Remarks

See the Type Mappings topic in the Connectivity book for details.