Skip to content

DF_DATABASE_MAP_DFTEXT_TO_SQLTYPE

Determines which SQL data type the DataFlex Text 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:
  • "varchar"
  • "text"
  • "varchar(max)"

  • "nvarchar(max)"

  • IBM DB2:

  • "varchar"
  • "long varchar"
  • "clob"
  • "vargraphic"
  • "long vargraphic"

  • "DBCLOB"

  • See Type Mappings for all possible types.

Syntax

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

Driver Configuration Keyword

MAP_DFTEXT_TO_SQLTYPE

Remarks

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