The select-clause comprises either a Workplan of the type SELECTION or LIST, or selection specifications for the objects, FDTs or applications to be processed.
This section describes the syntax that applies to the select-clause. The keywords and variable values contained in the syntax diagrams represent the parameters that can be used to specify object selection criteria. If indicated, a variable value must be supplied with a keyword.
The select-clause consists of one of the following options:
|
|
(selection-workplan)
|
|
The selection-workplan and list-workplan options are explained in SELECTION or LIST Workplan below.
The use of object-selection depends on the object type, DDM, FDT or application you want to process, for each of which the appropriate syntax and keywords are explained in the remainder of this section.
The delete-instruction-selection options are explained in Delete Instructions for Selected Objects.
A Workplan of the type SELECTION contains a header (TYPE SELECTION) and
a selection from one of the following types of object or file: Natural library
objects, Natural-related objects, Natural system error messages, Natural
command processor sources, external
files (external objects) or Adabas FDTs (Field Definition Tables).
A Workplan of the type LIST contains a header (TYPE LIST) and a
selection list of objects as described in the section
Object List - LIST
Workplan. Such an object list can be used for the
UNLOAD, LOAD or
FIND command only.
For further information on using Workplans, see the section Workplans.
This selection is used to select Natural objects for processing including Natural DDMs, user-defined error messages and shared resources.
The appropriate syntax is shown and explained in the following section.
| object-name | |||||||||
LIBRARY
library-name |
|||||||||
[DBID
dbid FNR fnr]
|
|||||||||
[OBJTYPE
group-type]
|
|||||||||
|
|
SETNO set-number
[SETUSER
set-user] [SETLIBRARY
set-library]
|
|
|||||||
[NATTYPE
object-type]
|
|||||||||
[SCKIND
object-kind]
|
|||||||||
[MODE
object-mode]
|
|||||||||
[FMNUM
error-number-from]
|
|||||||||
[TONUM
error-number-to]
|
|||||||||
[SLKIND
message-type]
|
|||||||||
[LANGUAGE
languages]
|
|||||||||
[DDMDBID ddm-dbid]
[DDMFNR ddm-fnr]
|
|||||||||
[NATVERS
natural-version]
|
|||||||||
|
|
|
||||||||
|
|
|
||||||||
[USERID
user-id]
|
|||||||||
[TID
terminal-id]
|
|||||||||
| [except-clause] | |||||||||
EXCEPT
|
||||
| ( object-name | ||||
[LIBRARY
library-name]
|
||||
[OBJTYPE
group-type]
|
||||
[SCKIND
object-kind]
|
||||
[NATTYPE
object-type]
|
||||
[MODE
object-mode]
|
||||
[SLKIND
message-type]
|
||||
[FMNUM
error-number-from] [TONUM
error-number-to]
|
||||
[LANGUAGE
languages]
|
||||
[DDMDBID ddm-dbid]
[DDMFNR
ddm-fnr]
|
||||
[NATVERS
natural-version]
|
||||
|
|
|
|||
|
|
|
|||
[USERID
user-id]
|
||||
[TID
terminal-id]
|
||||
| ) | ||||
Note:
For the command FINDLIB, only
the following keywords are processed: LIBRARY, DBID
and FNR.
The keywords and valid values for the objects to be processed are described in the following section.
| Keyword | Valid Values | Default Value | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
object-name
|
A valid object name or a range of names. See also Name in Name, Date and Time Specification. |
none | ||||||||||||||||||||||||||||||||||
LIBRARY
|
A valid library name or a range of names.
If See also Name. |
none | ||||||||||||||||||||||||||||||||||
DBID
|
A valid database ID. |
|
||||||||||||||||||||||||||||||||||
FNR
|
A valid file number. |
|
||||||||||||||||||||||||||||||||||
OBJTYPE
|
Types of object are:
or a valid combination. |
* |
||||||||||||||||||||||||||||||||||
SETNO |
Only applies to the unload and find functions and if Predict
is installed. Not applicable to application objects (see also
Selecting Application
Objects).
A one- or two-digit number that identifies the retained set to be
used for the names of the objects to be processed. A retained set is created
with the save set option of the If For detailed information on Predict sets, refer to the Predict documentation. |
none | ||||||||||||||||||||||||||||||||||
SETUSER |
Only applies to the unload and find functions and if Predict
is installed. Not applicable to application objects (see also
Selecting Application
Objects).
The ID of the user who created the Predict set. If no ID is
specified, the value of the system variable
|
*USER |
||||||||||||||||||||||||||||||||||
SETLIBRARY |
Only applies to the unload and find functions
and if Predict is installed. Not applicable to application objects (see also
Selecting Application
Objects).
The name of the library to be searched for a Predict set. If you
do not specify |
|||||||||||||||||||||||||||||||||||
NATTYPE
|
One or more single-character codes for Natural object types:
|
* |
||||||||||||||||||||||||||||||||||
SCKIND
|
The kind of Natural programming objects.
Note: |
A |
||||||||||||||||||||||||||||||||||
MODE |
The programming mode of the Natural programming
objects.
|
|||||||||||||||||||||||||||||||||||
FMNUM |
A start number of Natural error messages.
Valid range: 1 to 9999. |
1 |
||||||||||||||||||||||||||||||||||
TONUM |
An end number of Natural error messages.
Valid range: 1 to 9999. The value must be greater than or equal to the value of
|
|
||||||||||||||||||||||||||||||||||
SLKIND |
The kind of Natural error message text.
|
A |
||||||||||||||||||||||||||||||||||
LANGUAGE |
Up to 8 valid language codes (for example, code 1
for English) of user-defined error messages. An asterisk (*) selects all
language codes.
|
* |
||||||||||||||||||||||||||||||||||
DDMDBID |
The valid database ID (1 to 65535) of a DDM.
|
|
||||||||||||||||||||||||||||||||||
DDMFNR |
The valid file number (1 to 65535) of a DDM.
|
|
||||||||||||||||||||||||||||||||||
NATVERS |
The Natural version of Natural programming objects. You can also specify a range of versions: see Name. |
blank |
||||||||||||||||||||||||||||||||||
DATE
|
The save or catalog date of Natural programming objects, and the date of shared resources.
You can add a time by inserting a blank between date and time. For the format and ranges allowed, see Date and Time in Name, Date and Time Specification. Special terms allowed are |
blank |
||||||||||||||||||||||||||||||||||
FMDATE
|
A start value:
The date on or after which Natural programming objects were
cataloged or saved, and the date of shared
resources. The format is identical to Special terms allowed are |
blank |
||||||||||||||||||||||||||||||||||
TODATE
|
An end value:
The date on or before which Natural programming objects were
cataloged or saved, and the date of shared
resources. The format is identical to Special terms allowed are |
blank |
||||||||||||||||||||||||||||||||||
SIZE
|
The size of Natural programming objects and shared resources (up to 7 digits). |
|
||||||||||||||||||||||||||||||||||
FMSIZE
|
A start value:
The minimum size of Natural programming objects and shared resources (up to 7 digits). |
|
||||||||||||||||||||||||||||||||||
TOSIZE
|
An end value:
The maximum size of Natural programming objects and shared resources (up to 7 digits). |
|
||||||||||||||||||||||||||||||||||
USERID
|
The ID of the user who saved or cataloged the Natural
programming objects.
You can also specify a range of user IDs: see Name. |
blank |
||||||||||||||||||||||||||||||||||
TID
|
The ID of the terminal where the Natural programming objects were
saved or cataloged (provided by the Natural system variable
You can also specify a range of terminal IDs: see also Name. |
blank |
||||||||||||||||||||||||||||||||||
EXCEPT
|
All items that match the selection criteria entered before
EXCEPT are checked against all parameters contained
within the parentheses following the keyword EXCEPT. If they match
all these parameters too, they are not processed.
|
not applicable |
Notes:
OBJTYPE are
ignored. For example: DATE, SIZE and
USERID have no meaning for Natural error messages.
DBID and
FNR are ignored by the
LOAD or SCAN command.
These parameters must instead be specified in the
parameter-setting clause as described for
LOADFNAT... and LOADFUSER... in
Keyword Explanation
of parameter-clause.
This selection is used to select Natural-related objects for processing.
The appropriate syntax is shown and explained in the following section.
object-name
NATPATH
natural-path-name |
||||
|
|
|
|||
|
|
|
|||
[
EXCEPT |
||||
(object-name
NATPATH
natural-path-name |
||||
|
|
|
|||
|
|
|
|||
| ) ] | ||||
The keywords and valid input values for the objects to be processed are described in the following section.
| Keyword | Valid Values | Default Value |
|---|---|---|
object-name
|
The name of a Natural-related object. If
object-name contains blank characters, it must be
enclosed in double quotation marks (" ").
See also Name in Name, Date and Time Specification. |
none |
NATPATH
|
|
none |
DATE
|
The modification date of Natural-related objects.
You can add a time by inserting a blank between date and time. For the format and ranges allowed, see Date and Time in Name, Date and Time Specification. Special terms allowed are:YESTERDAY and TODAY. See Special Dates in Date. |
blank |
FMDATE
|
A start value:
The date on or after which Natural-related objects were modified.
The format is identical to Special terms allowed are: |
blank |
TODATE
|
An end value:
The date on or before which Natural-related objects were modified.
The format is identical to Special terms allowed are: |
blank |
SIZE
|
The size of Natural-related objects (up to 10 digits). |
|
FMSIZE
|
A start value:
The minimum size of Natural-related objects (up to 10 digits). |
|
TOSIZE
|
An end value:
The maximum size of Natural-related objects (up to 10 digits). |
|
EXCEPT |
See EXCEPT in
Natural Library Object and DDM Selection.
|
Note:
The NATPATH clause in the EXCEPT part is
evaluated by the LOAD or
SCAN command only.
This selection is used to select Natural system error messages for processing.
The appropriate syntax is shown and explained in the following section.
ERROR
NATERROR
|
|||||||||
[DBID dbid
FNR fnr]
|
|||||||||
[FMNUM
error-number-from] [TONUM
error-number-to]
|
|||||||||
[SLKIND
message-type]
|
|||||||||
[LANGUAGE
languages]
|
|||||||||
[
EXCEPT
|
|||||||||
| ( | |||||||||
[FMNUM
error-number-from] [TONUM
error-number-to]
|
|||||||||
[SLKIND
message-type]
|
|||||||||
[LANGUAGE
languages]
|
|||||||||
| ) ] | |||||||||
The keywords and valid input values for the Natural system error messages to be processed are described in the following section.
| Keyword | Valid Values | Default Value |
|---|---|---|
DBID
|
Only applies to system error messages on mainframes. A valid database ID. |
|
FNR
|
Only applies to system error messages on mainframes.
A valid file number. |
|
FMNUM
|
A start number of system error messages.
Valid range: 1 to 9999. |
1 |
TONUM
|
An end number of system error messages.
Valid range: 1 to 9999. The value must be greater than or equal to the value of
|
|
SLKIND
|
See SLKIND in
Natural Library Object and DDM Selection.
|
A |
LANGUAGE
|
Up to 8 valid language codes (for example, code 1
for English) of system error messages.
An asterisk (*) selects all language codes. |
* |
EXCEPT |
See EXCEPT in
Natural Library Object and DDM Selection.
|
Note:DBID and
FNR are ignored by the
LOAD or SCAN command.
These parameters must instead be specified in the
parameter-setting clause as described for
LOADFNAT... in Keyword Explanation of
parameter-clause.
This selection is used to select Natural command processor sources for processing.
The appropriate syntax is shown and explained in the following section.
object-name
PROCESSOR
ncp-library-name |
||
|
|
DBID ncp-dbid
FNR ncp-fnr
[file-options]
|
|
[EXCEPT
|
||
| (object-name | ||
[LIBRARY
ncp-library-name]
|
||
| ) ] | ||
[CIPHER
ncp-cipher]
|
|||||
|
|
|
|
ncp-password |
|
|
Note:
For the command FINDLIB, only the
following keywords are processed: PROCESSOR, DBID,
FNR,
CIPHER and PASSWORD or PSW.
The keywords and valid input values for the Natural command processor sources to be processed are described in the following section.
| Keyword | Valid Values | Default Value |
|---|---|---|
object-name
|
The name of a valid Natural command processor source or a
range of names.
See also Name in Name, Date and Time Specification. |
none |
PROCESSOR
|
A valid library name or a range of names.
See also Name. |
none |
DBID |
The valid database ID of the Adabas file where the Natural command processor sources are stored. |
Value of |
FNR
|
The valid file number of the Adabas file where the Natural command processor sources are stored. |
Value of |
CIPHER
|
The 8-digit cipher code of the Adabas file where the Natural command processor sources are stored. | blank |
PASSWORD
or PSW |
The 8-character Adabas password of the Adabas file where the Natural command processor sources are stored. | blank |
EXCEPT |
See EXCEPT in
Natural Library Object and DDM Selection.
|
Note:
DBID, FNR, CIPHER and
PASSWORD or PSW are ignored by the
LOAD or SCAN command.
These parameters must instead be specified in the
parameter-setting clause as described for
LOADNCP... in Keyword Explanation of
parameter-clause.
This selection is used to select external files (external objects) for processing.
The appropriate syntax is shown and explained in the following section.
external-file-name
PATH
external-path-name |
||||
|
|
|
|||
|
|
|
|||
[
EXCEPT |
||||
(external-file-name
[PATH
external-path-name]
|
||||
|
|
|
|||
|
|
|
|||
| ) ] | ||||
The keywords and valid input values for the external files to be processed are described in the following section.
| Keyword | Valid Values | Default Value |
|---|---|---|
external-file-name
|
The name of an external file. If external-file-name contains blank characters, it must be enclosed in double quotation marks (" "). See also Name in Name, Date and Time Specification. |
none |
PATH
|
The name of the path where the external file is located. | none |
DATE
|
The modification date of external files. You can add a time by inserting a blank between date and time. For the format and ranges allowed, see Date and Time in Name, Date and Time Specification. Special terms allowed are |
blank |
FMDATE
|
A start value: The date on or after which external files were modified. The
format is identical to Special terms allowed are |
blank |
TODATE
|
An end value: Special terms allowed are |
blank |
SIZE
|
The size of external files (up to 10 digits). |
|
FMSIZE
|
A start value: |
|
TOSIZE
|
An end value: |
|
EXCEPT |
See EXCEPT in
Natural Library Object and DDM Selection.
|
Note:
The NATPATH clause in the EXCEPT part is
only evaluated by the LOAD and
SCAN commands.
This selection is used to select Adabas FDTs (Field Definition Tables) for processing.
For loading FDTs, see also FDTs in the section Object Specification.
The appropriate syntax is shown and explained in the following section.
FDT
|
||||||||
DBID dbid |
||||||||
|
|
FNR
fnr [CIPHER
cipher]
|
|
|
|
password |
|
|
|
FMFNR fnr-start
TOFNR
fnr-end |
||||||||
The keywords and valid input values for the FDTs to be processed are described in the following section.
This selection applies to applications created and maintained in Natural Studio's application workspace and the libraries or objects that belong to these applications.
The appropriate syntax is shown and explained in the following section.
This selection only applies to the find function.
APPLICATION
APNAME
application-name |
|
[APTYPE
application-type]
|
|
[COMPAPPLICATION
compound-application-name]
|
|
| [ |
EXCEPT
|
(APNAME
application-name |
|
[APTYPE
application-type]
|
|
| ) ] | |
This selection only applies to the find function.
APPLICATION
APLIBRARY
application-library-name |
|||
[BASEAPPLICATION
base-application-name]
|
|||
[
COMPAPPLICATION
compound-application-name]
|
|||
|
|
DBID dbid
[FNR fnr]
|
|
|
| [ | EXCEPT
|
||
(APLIBRARY
application-library-name |
|||
[BASEAPPLICATION
base-application-name]
|
|||
| ) ] | |||
This selection only applies to the find and unload functions.
APPLICATION
APOBJECTS
application-object-name |
|
[BASEAPPLICATION
base-application-name]
|
|
[COMPAPPLICATION
compound-application-name]
|
|
[LIBRARY
library-name]
|
|
| [object-specification] | |
| [ |
EXCEPT
|
(APOBJECT
application-object-name |
|
[LIBRARY
library-name]
|
|
[BASEAPPLICATION
base-application-name]
|
|
| [object-specification] | |
| ) ] | |
The keywords and valid input values for the applications, application libraries or application objects to be processed are described in the following section.
| Keyword | Valid Values | Default Value | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
APNAME |
A valid name of a Natural application or a range of names. See also Name in Name, Date and Time Specification. |
* |
||||||||||
APTYPE
|
|
* |
||||||||||
COMPAPPLICATION
|
Only applies if The name of a compound application to which the specified base application belongs or a range of names. Only base applications that belong to the specified compound application(s) are selected; base applications that do not belong to a compound application are not selected. |
none | ||||||||||
EXCEPT |
See EXCEPT in
Natural Library Object and DDM Selection.
|
not applicable | ||||||||||
APLIBRARY |
The valid name of a library that belongs to a Natural base or compound application or a range of names. See also Name in Name, Date and Time Specification. |
* |
||||||||||
BASEAPPLICATION
|
The valid name of a Natural base application to which an application library or application object belongs. See also Name in Name, Date and Time Specification. |
* |
||||||||||
DBID
|
The valid database ID of an application library. |
|
||||||||||
FNR
|
The valid file number of an application library. |
|
||||||||||
APOBJECT
|
The valid name of an application object that belongs to a base or compound application, or a range of names. See also Name in Name, Date and Time Specification. |
* |
||||||||||
LIBRARY |
A valid library name or a range of names. If See also Name in Name, Date and Time Specification. |
* |
||||||||||
object-specification
|
Indicates that additional selection criteria can be specified for
application objects as shown in the
syntax diagram
for Natural library objects and DDMs: all items listed below |
not applicable | ||||||||||
This selection is used to specify delete instructions for Natural
library objects, DDMs, user-defined error messages and Natural system error
messages. The delete instructions are executed when a work file of internal
format is loaded in the target environment with the
DELETEALLOWED
option specified.
The appropriate syntax is shown and explained in the following section.
Syntax of Delete Instructions for Natural Library Objects and DDMs
Syntax of Delete Instructions for User-Defined Error Messages
Syntax of Delete Instructions for Natural System Error Messages
| object-name | |||||||
LIBRARY
library-name |
|||||||
|
|
OBJTYPE |
|
|
|
|
||
|
|
NATTYPE |
|
|
|
|
||
[SCKIND
object-kind]
|
|||||||
The keywords and valid values for the objects to be processed are described in the following section.
| Keyword | Valid Values | Default Value | ||||||
|---|---|---|---|---|---|---|---|---|
object-name
|
A valid object name or a start value
(value*) for a range of names such as
|
none | ||||||
LIBRARY
|
A valid library name. A range specification is not allowed. | none | ||||||
OBJTYPE
|
A valid object-type code:
|
* |
||||||
NATTYPE
|
A Natural object type. Valid input values are:
|
* |
||||||
SCKIND |
The kind of Natural programming objects.
|
A |
* |
LIBRARY
library-name |
OBJTYPE E |
FMNUM
error-number-from |
[TONUM
error-number-to]
|
[SLKIND
message-type]
|
[LANGUAGE
languages]
|
library-name denotes the name of a single library; a range specification is not allowed.
For explanations of the other elements used in this syntax, see Keyword Explanation of Natural Library Object and DDM Selection.
ERROR
NATERROR |
FMNUM
error-number-from |
[TONUM
error-number-to]
|
[SLKIND
message-type]
|
[LANGUAGE
languages]
|
For explanations of the elements used in this syntax, see Keyword Explanation of Natural System Error Message Selection.
