Previous Topic Next topic Print topic


INS_NULL

Restriction: This topic applies to Windows environments only.

Specifies whether null character data is to be inserted as null values, or blanks. The correct syntax is:

INS_NULL = { Y | N | NULLABLE };

If INS_NULL is set to NULLABLE, the null character data is imported as a NULL if the field is defined to allow null values, and as a space if the field is defined as NOT NULL.

If INS_NULL is set to N, then empty character fields are imported as a space.

If INS_NULL is set to Y (default), then a null character value is imported as a NULL. If the field is defined as NOT NULL, an error is returned if a null value is encountered.

INS_NULL is an optional Batch Import command.

For example:

INS_NULL = N;

will import null characters as spaces.

Previous Topic Next topic Print topic