SET_AUTOMATIC_NUMERIC_DATATYPE_REMAPPING¶

Applies to: SQLFlex

This command toggles off and on the automatic numeric data type remapping built into SQLFlex. When adding or creating smaller numeric columns during a restructure, SQLFlex will change the type to a more specific data type i.e. smallint or tinyint since they are handled more efficiently by the server. Sending false to this command will force SQl to keep the column as a numeric field, preserving the length and precision. Passing true will leave the remapping up to the driver.

Syntax

SET_AUTOMATIC_NUMERIC_DATATYPE_REMAPPING to {variable}

Parameter	Description
variable	Boolean variable enabling or disabling remapping

Example

Structure_Start hFile "SQL_DRV"
    Create_Field hFile

    SET_AUTOMATIC_NUMERIC_DATATYPE_REMAPPING to False

    Set_Attribute DF_FIELD_NAME   of hFile iColumn to "Transaction_Count"
    Set_Attribute DF_FIELD_TYPE   of hFile iColumn to DF_BCD
    Set_Attribute DF_FIELD_LENGTH of hFile iColumn to 1
Structure_End hFile DF_STRUCTEND_OPT_NONE "." 0