Skip to content

DF_DATABASE_MAP_DFDATE_TO_SQLTYPE

Determines which SQL data type the DataFlex Date 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: "date", "datetime"
  • IBM DB2: "date"

  • See Type Mappings for all possible types.

Syntax

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

Driver Configuration Keyword

MAP_DFDATE_TO_SQLTYPE

Remarks

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