Previous Topic Next topic Print topic

Micro Focus Visual COBOL 2.3 Update 2 for Eclipse (UNIX) > Programming > Data Access > Database Connectors for Visual COBOL > Database Connectors Reference > Configuration Variables > 4GL_ILLEGAL_DATA configuration variable

4GL_ILLEGAL_DATA configuration variable

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

4GL_ILLEGAL_DATA determines how COBOL data considered illegal by the database is converted before being stored in the database.

The default value is NULL. This causes all illegal data (except key fields) to be converted to null before it is stored.

The value CONVERTED causes the following conversions to occur:

Illegal LOW-VALUES Minimum possible value (0 or 99999...)

Minimum possible date value (01/01/01)

Illegal HIGH-VALUES Maximum possible value (99999...)

Maximum possible date value (database dependent)

Illegal SPACES Zero (or 01/01/01 for a date field)

Illegal data in key fields is always converted, regardless of the value of this variable.

Parent topic: Configuration Variables
Previous Topic Next topic Print topic