Skip to content

DF_DATABASE_DEFAULT_DEFAULT_ASCII

Sets up the default value that will be used when an ASCII column is created.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 5 and higher.

Type

String, temporary

Access

Read/Write

Values

Any valid default value for an ASCII column.

Syntax

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

Driver Configuration Keyword

Default_Default_Ascii

Remarks

Sets up the default value that will be used when an ASCII column is created. Columns can be created during conversion or within a restructure operation.

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_DEFAULT_DEFAULT_ASCII of iDriver hDatabase to sAttribValue
    Showln "Default Ascii: " sAttribValue
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.