Processing DL/I Subfiles

All SYSMAIN functions except the find and rename functions can be performed on DL/I subfiles if Natural for DL/I is installed.

DL/I subfiles include the following:

  • NDBs = DL/I DBDs (Database Descriptions) defined to Natural.

  • NSBs = DL/I PSBs (Program Specification Blocks) defined to Natural.

  • UDFs = DL/I User-Defined Fields defined to Natural.

Fore more information on NDBs, NSBs, DBDs, PSBs and UDFs, see the Natural for DL/I documentation.

This section describes menu functions and selection list options provided to perform a SYSMAIN function on DL/I subfiles and the syntax that applies when using direct commands.


Fields in the DL/I Subfiles Menu

The DL/I Subfiles menu contains all SYSMAIN functions required for the processing of DL/I subfiles. The fields provided in the menu are described in the following table:

Field Explanation
Code
Specifies the function to be performed as described in Description of Functions:
   
C Copy subfile.
D Delete subfile.
L List subfile.
M Move subfile.
Sel. List
Specifies whether selective processing or automated processing is used:
   
Y Yes.
Selective processing is activated. A selection list is displayed when processing DL/I subfiles. This is the default setting. For the columns, fields and line commands available on a selection list, see Selection Lists for DL/I Subfiles.
N No.
Selective processing is deactivated.
Name The name of the DL/I subfile to be processed or a range of names: see also Specifying a Range of Names.
Type
The type of DL/I subfile to be processed. You must specify either of the following types:
   
D Only NDBs and UDFs are processed. This is the default setting.
P Only NSBs are processed.
Database The database ID (DBID) of a source or a target database.

The source database contains the FDIC system file where the DL/I subfile to be processed is stored. The target database contains the FDIC system file to which the DL/I subfile is to be copied or moved.

Valid database IDs are 1 to 65535.

File The file number (FNR) of a source or a target FDIC system file.

Valid file numbers are 1 to 65535.

The source file contains the DL/I subfile to be processed. The target file is the file to which the DL/I subfile is to be copied or moved.

Name
(next to File)

Only applies to VSAM files.

The DDNAME/FCT entry for the source or target file number.

Replace
Specifies whether a DL/I subfile is to be replaced when using the move or copy function:
   
Y Yes.
A DL/I subfile with the same name which exists in the target environment is replaced.
N No.
A DL/I subfile with the same name which exists in the target environment is not replaced. This is the default setting.
   
See also Using the Replace Option.

Selection Lists for DL/I Subfiles

If selective processing has been activated, a selection list of all DL/I subfiles that meet the specified selection criteria is displayed on a Selection screen.

This section describes the columns and fields contained on a Selection screen and the line commands provided to further process a DL/I subfile:

Columns and Fields

The following columns and fields are displayed on a Selection screen:

Column/Field Explanation
C Input field for line commands (see below).
Subfile The name of the DL/I subfile that meets the specified selection criteria.
Message The message that indicates the processing status of a DL/I subfile. For possible messages, see Status Messages.
Listed Subfiles The type of DL/I subfile: NDB (including UDFs) or NSB.

Line Commands

One of the following line commands can be entered in the C (Command) column of a Selection screen:

Line Command Function
A Process NSB subfile or NDB and UDF subfiles.

Line command A is not available with the list function.

L List NSB subfile or NDB and UDF subfiles.

Direct Command Syntax for DL/I Subfiles

This section shows the syntax that applies when performing a SYSMAIN function on a DL/I subfile by using direct commands in either online or batch mode. For general instructions on using direct commands, refer to Executing Commands.

For explanations of the keywords and variable values used in the syntax diagrams below, refer to Keywords and Variables in Direct Commands. The symbols in the syntax diagrams correspond to the syntax symbols used for system commands. These symbols are explained in System Command Syntax in the System Commands documentation.

The syntax of the where-clause and the with-clause are identical for each command.

This section covers the following topics:

COPY and MOVE

COPY
MOVE

DL1 name [with-clause]

FM where-clause

TO where-clause

Examples:

COPY DL1 SUBFILE1 TYPE D FM DBID 1 FNR 5 TO DBID 2 FNR 5
C DL1 SUBFILE REP FM FNR 6 TO FNR 7 TYPE D
COPY DL1 SUBFILE1 TYPE P TO DBID 3 FNR 7 
MOVE DL1 SUBFILE1 TYPE D FM DBID 1 FNR 5 TO DBID 2 FNR 5
M DL1 SUBFILE1 REP FM FNR 6 TO FNR 7 TYPE D

DELETE and LIST

DELETE
LIST

DL1 name

IN where-clause

[with-clause]

Examples:

DELETE DL1 S* TYPE D
D DL1 TEST* IN DBID 177 FNR 205 TYPE D
LIST DL1 SUBFILE* IN DBID 1 FNR 5 TYPE D
L DL1 SF* TYPE P

where-clause

[WHERE] [DBID dbid] [FNR fnr] [NAME vsam-name]
[CIPHER cipher]

PASSWORD
PSW

password

   

with-clause

[WITH] [TYPE type] [REPLACE] [RCOP]

PROMPT
NOPROMPT

MON
NOMON

[HELP]