DF_FIELD_DEFAULT_VALUE¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Use this attribute to get or set the default value for a given column. Setting the default value can only be done during a structure_start or during table creation. If this attribute is not set, it is defaulted to the driver default. See Mertech.cfg

Syntax

Set_Attribute DF_FIELD_DEFAULT_VALUE of {FileNumber} {FieldNumber} to {variable}
Get_Attribute DF_FIELD_DEFAULT_VALUE of {FileNumber} {FieldNumber} to {variable}

Parameter	Description
FileNumber	Number of the file
FieldNumber	Number of the field
variable	Variable for the default value of the field

Example

open Customer
String sDefault
Handle hFile
Integer iColumn

Move "California" to sDefault
Move Customer.File_Number to hFile
Move 3 to iColumn

Structure_Start hFile "ORA_DRV"
   Set_Attribute DF_FIELD_DEFAULT_VALUE of hFile iColumn to sDefault
Structure_End hFile DF_STRUCTEND_OPT_NONE "." 0

Get_Attribute DF_FIELD_DEFAULT_VALUE of hFile iColumn to sDefault