Skip to content

DF_DRIVER_MAP_DFASCII_TO_SQLTYPE

Determines which SQL data type the DataFlex ASCII 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:
  • "char"
  • "varchar"
  • "varchar(max)"
  • "nchar"
  • "nvarchar"
  • "nvarchar(max)"

  • IBM DB2:

  • "char"
  • "varchar"
  • "graphic"
  • "vargraphic"

  • See Type Mappings for all possible types.

Syntax

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

Driver Configuration Keyword

MAP_DFASCII_TO_SQLTYPE

Remarks

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