Process Help |
Process Name |
Menu Path |
Link to Command Table |
SELDEL |
Introduction
Selectively deletes named fields from the input file during a copy to the output file.
How to use
The fields to be deleted are specified as *F1 to *Fn. Any number of required fields may be deleted, but only one is compulsory.
If retrieval criteria are specified they will be ignored if they are on the deleted fields.
If the optional parameter @KEEPALL is zero (default) the output file will only contain one entry for each combination of output field values, provided that the input file is first sorted on these fields. If the input file is not sorted, then the output file will contain one entry for each combination of output field values which occur together in the input file.
The process works by checking the selected field values against the values just written to the output file. If they are identical, the current record is skipped.
Files, Fields and Parameters
Input Files
Name |
Description |
I/O Status |
Required |
Type |
IN |
Input file. |
Input |
Yes |
Table |
FIELDLST |
File to supply selected fields. |
Input |
No |
Undefined |
Output Files
Name |
I/O Status |
Required |
Type |
Description |
OUT |
Output |
Yes |
Table |
Output file with deleted fields. |
Fields
Name |
Description |
Source |
Required |
Type |
Default |
F1 |
Deleted field 1. |
IN |
No |
Any |
Undefined |
F2 |
Optional second deleted field. |
IN |
No |
Any |
Undefined |
F3 |
Optional third deleted field. |
IN |
No |
Any |
Undefined |
F4 |
Optional fourth deleted field. |
IN |
No |
Any |
Undefined |
F5 |
Optional fifth deleted field. |
IN |
No |
Any |
Undefined |
F6 |
Optional sixth deleted field. |
IN |
No |
Any |
Undefined |
F7 |
Optional seventh deleted field. |
IN |
No |
Any |
Undefined |
F8 |
Optional eighth deleted field. |
IN |
No |
Any |
Undefined |
F9 |
Optional ninth deleted field. |
IN |
No |
Any |
Undefined |
F10 |
Optional tenth deleted field. |
IN |
No |
Any |
Undefined |
F11 |
Optional eleventh deleted field. |
IN |
No |
Any |
Undefined |
F12 |
Optional twelfth deleted field. |
IN |
No |
Any |
Undefined |
F13 |
Optional thirteenth deleted field. |
IN |
No |
Any |
Undefined |
F14 |
Optional fourteenth deleted field. |
IN |
No |
Any |
Undefined |
F15 |
Optional fifteenth deleted field. |
IN |
No |
Any |
Undefined |
F16 |
Optional sixteenth deleted field. |
IN |
No |
Any |
Undefined |
F17 |
Optional seventeenth deleted field. |
IN |
No |
Any |
Undefined |
F18 |
Optional eighteenth deleted field. |
IN |
No |
Any |
Undefined |
F19 |
Optional nineteenth deleted field. |
IN |
No |
Any |
Undefined |
F20 |
Optional twentieth deleted field. |
IN |
No |
Any |
Undefined |
F21 |
Optional twenty first deleted field. |
IN |
No |
Any |
Undefined |
F22 |
Optional twenty second deleted field. |
IN |
No |
Any |
Undefined |
F23 |
Optional twenty third deleted field. |
IN |
No |
Any |
Undefined |
F24 |
Optional twenty fourth deleted field. |
IN |
No |
Any |
Undefined |
F25 |
Optional twenty fifth deleted field. |
IN |
No |
Any |
Undefined |
FIELDNAM |
Field in FIELDLST to identify selected fields. |
FIELDLST |
No |
Character |
Undefined |
Parameters
Name |
Description |
Required |
Default |
Range |
Values |
||||||
KEEPALL |
Used to keep or delete records with duplicate successive key field values
|
No | 0 | 0,1 | 0,1 | ||||||
KEYTOL |
KEYTOL is the tolerance value used to test whether numeric key values are equal. It must be greater than or equal to zero. It replaces the previous heuristic comparison method. If KEYTOL is set to a negative value then zero is used. In a macro KEYTOL can be set to absent using -. "@KEYTOL=-" This will revert to legacy behaviour of a tolerance of zero being used. |
No |
0.00001 |
0,+ |
Undefined |
Notes
No additional notes.
Example
!SELDEL &IN(ASSAYS),&OUT(CUAU),*F1(BHID),*F2(FROM),*F3(TO)
Error and Warning Messages
Message |
Description |
Solution |
|
|
|