Select one of the following items to indicate how the ILE RPG program will
be allowed to use records containing null-capable fields from externally
described database files.
- *CMDDFT
- The default currently set on your host system. Not necessarily the
installation defaults.
- *NO
- Select *NO if you do not want the ILE RPG program to process records with
null-value fields from externally described files. If you attempt to
retrieve a record containing null values, no data in the record is accessible
to the ILE RPG program and a data-mapping error occurs.
- *INPUTONLY
- Select *INPUTONLY if you want the ILE RPG program to read records with
null-capable fields containing null values from externally described
input-only database files. When a record containing null values is
retrieved, no data mapping errors occur and the database default values are
placed into any fields which contain null values. The program cannot do
any of the following:
- use null-capable key fields
- create or update records containing null-capable fields
- determine whether a null-capable field is actually null while the program
is running
- set a null-capable field to be null.
- *USRCTL
- Select *USRCTL if you want the ILE RPG program to read, write and update
records with null values from externally described database files.
Records with null keys can be retrieved using keyed operations. The
program can determine whether a null-capable field is actually null, and it
can set a null-capable field to be null for output or update. The
programmer is responsible for ensuring that fields containing null values are
used correctly within the program.
- *YES
- Same as *INPUTONLY.
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.