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