FMNIMSIN control statements
You use the FMNIMSIN control statements to specify:
- If the Load is to run in a BMP or DLI region.
- Whether to use a static PSB, or if FM/IMS is to generate a dynamic PSB to load the IMS data.
- How the data is to be loaded.
- Load checkpoint frequency.
Each line in FMNIMSIN starts with a $$FILEM and the first line contains
the parameter ILB to specify that FM/IMS is performing a Load.
$$FILEM ILB REGNTYPE=DLI,
$$FILEM PSBTYPE=DYNAMIC,
$$FILEM DBDDSN=FMN.IMS.IVP.DBDLIB,
. . .
. . .
The LOADTYPE, LDDSN, CHKPFREQ and USELCMD parameters are described here. All the other parameters in this syntax diagram can also be specified for the Extract (IXB) function. For a description of these common parameters, see Extract (IXB).
- LOADTYPE
- Required parameter. Specifies:
- Whether or not the Load replaces existing segments in the database.
- Whether or not the load uses a load PCB.
- 1
- Specifies that the Load is not to replace existing segments in the database. If you select this option, the load only attempts to insert the segment. If the insert call receives an II status code, the Load does not replace the existing segment in the database with the load segment.
- 2
- Specifies that the Load is to replace existing segments in the database. If you select this option, the Load attempts to insert the segment, as it does when option 1 is selected. However, if the insert call receives an II status code, the Load replaces the existing segment in the database with the load segment. Note that if a segment has a non-unique key or no key, existing segments in the database are not replaced. The load segments are inserted even when there is an existing segment in the database with the same key.
- 3
- Specifies that the Load uses a load PCB (PROCOPT=L/ LS) to load
the segments into the database. Use this option for an initial load
of a database. Note: This option is only available when you specify PSBTYPE=DYNAMIC and REGNTYPE=DLI.
- LDDSN=lddsn
- Required parameter. The name of the data set that contains the data that you want loaded.
- CHKPFREQ
- Optional parameter. Specifies the frequency of the automatic save function during the Load; that
is, the Load checkpoint frequency. FM/IMS:
- Increments a count by 1 each time the Load inserts or replaces a segment.
- Issues a checkpoint when the count is equal to the Load checkpoint frequency.
The valid range is 1 to 99999.
If you do not specify this parameter, FM/IMS uses- The subsystem default for the parameter (if you have specified the IMSID parameter)
- The installation default for the parameter (if you have not specified the IMSID parameter).
- USELCMD
- Optional parameter. This option is only applicable when some of
the segments you are loading have an insert rule of FIRST or HERE.
Specifies whether or not the Load is to override these insert rules.
- Y
- Segments with no key or a non unique key are inserted as the last occurrence - this is irrespective of the insert rule for the segment type.
- N
- Segments with no key or a non unique key are inserted according to the insert rule for the segment type.
Note: If you are using the Extract (IXB) and Load (ILB) to extract data from one database and load it into another, and you want the twin segments in the loaded database to be in the same sequence as they were in the extracted database, then specify USELCMD=Y.