Skip to content

DF_DATABASE_MAP_DFBINARY_TO_SQLTYPE

Determines which SQL data type the DataFlex Binary 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:
  • "varbinary(max)"
  • "image"
  • "binary"

  • IBM DB2:

  • "Long varchar for bit data"
  • "Varchar for bit data"
  • "char for bit data"
  • "blob"

  • See Type Mappings for all possible types.

Syntax

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

Driver Configuration Keyword

MAP_DFBINARY_TO_SQLTYPE

Remarks

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