Date data type definition property

Indicates the data type to be used in the DBMS for attributes defined as Date in GeneXus.

Values

Scope

Available at the Data Store.
Data Store: iSeries

Description

When working with DB2 for iSeries as a DBMS, the attributes based on the Date data type in GeneXus are generated as characters in the database.

The Date data type definition property is offered at the Data Store level when the Data Store is DB2 for iSeries. It allows setting the format to use in the database for the attributes defined as Date in GeneXus. The possible values ​​are:

- Date: The data type in the database will be Date.
- Char(8): The data type in the database will be Character(8).

The default value is Char(8).

This property is not supported by RPG or Cobol (they would only accept the value Character). This implies that if you want to call some procedure generated in RPG/Cobol as stored procedures you cannot change the default value of the preference.

This property applies to all generators that access AS/400 (C/SQL, VB, VFP, Java, C#).

Notes:

• This applies only to the Date data type and not to the DateTime data type.
• The null value is 01/01/0001.

Runtime/Design time

This property applies only at design time.