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: The search result of an object check also depends on the settings of
|
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 A date check can also be defined for a specified object kind (source or
cataloged object): see |
blank |
||||||||||||||||||||||||||||||||||
DATECHECK |
Kind of object (source or cataloged object) to be checked
for the date or date range defined with DATE, or FMDATE and TODATE, respectively.
Valid input values are:
The search result of the object check also depends on the setting of
|
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 A date check can also be defined for a specified object kind (source or
cataloged object): see |
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 A date check can also be defined for a specified object kind (source or
cataloged object): see |
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 detailed information about the Adabas FDTs, see the Adabas on Windows and for Linux and Cloud documentation > Adabas Basics > FDT Record Structure.
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.
