Glossary

#### Search Results

Search

# Glossary

This glossary explains the terms most commonly used in the Super Natural documentation. This glossary is available online when you press PF1.

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z ]

## A

### Alphanumeric (A) Format

If a field is defined with alphanumeric format, the field value may only be alphanumeric.

Alphanumeric values can be the letters of the alphabet, special characters, numerical digits, blanks or any combination thereof. The following are examples of alphanumeric values:

    06024/71-0 #504

    Ernest Schneckenbecker & Co.

    BEAU300864TTRN20

Alphanumeric field length in characters (bytes) = 1 - 253.

### Array

Another name for a multiple-value field or a periodic group - fields which have occurrences.

### Array Editing

Determines how the occurrences of multiple-value fields and periodic groups are displayed in the Layout Editor.

### Asterisk List Function

The Asterisk (*) List function helps you if you don't know which libraries, files, fields, commands or objects are available for a particular command. Enter an asterisk (*) instead of the relevant name or command to obtain a selection list.

## B

### Batch Mode/Processing

In batch mode, transactions are processed at a time determined by the operating system - not necessarily immediately. Contrast with ONLINE MODE/PROCESSING.

### Binary (B) Format

Binary fields can only contain the following numeric values:

    B1 (0 - 255)

    B2 (0 - 65535)

    B3 (0 - 16777215)

    B4 (-2147483648 - 2147483647)

    B5 - B126 (Any binary value)

Binary field length in characters (bytes) = 1 - 126.

## C

### Calculation Editor

You use the Calculation Editor to enter calculation statements. You construct arithmetic calculation statements using a result field, operators, operands, mathematical functions and certain keywords. You can also assign values to a field and join fields.

### Checklist Function

The Checklist function provides a framework which guides you through adding and modifying transactions. The Checklist window tells you which steps are available, which are mandatory and which are optional. You choose the steps you want to take and the Checklist function takes you from step to step automatically. Using the Checklist function, you only need the `NEXT` commands to navigate within Super Natural.

The Checklist function is intended for users less familiar with Super Natural. Users who are more familiar with Super Natural can invoke the Checklist window as a type of online help.

### Class

There are two classes of field in the Layout Editor: text fields and output fields. You can define the class of a field in the Layout Editor. You enter the content of text fields in the Layout Editor. The contents of output fields are supplied dynamically when the transaction is run.

### Command

Commands are instructions which tell Super Natural what to do with an object, invoke a screen or start a function.

The standard command sequence for Super Natural in English is FUNCTION OBJECT NAME. You can change the command sequence in your user profile.

You can enter commands in the command line or in some screens in the command column. Some commands are also allocated to PF keys.

You can abbreviate commands as long as they remain unique.

Appendix A lists all the commands available in Super Natural and the shortest abbreviations possible for each one.

You can obtain a list of the commands available at any point in Super Natural by entering an asterisk (*) in the command line.

### Command (Cmd) Column

The command column is the column of input fields to the left of a list of objects on which you can perform commands. The column is two characters wide. You can enter the first one or two characters of a command next to an object in order to perform an action on it. The commands you can use are listed in the legend at the bottom of the screen's work area.

### Command Line

The command line is at the bottom of every screen except when you are looking at a report. You can enter commands and command abbreviations in the Super Natural command line.

### Constant

Constants are values which cannot change - the opposite of variables. The following constants are available in Super Natural:

- Alphanumeric

- Date

- Extended Time

- Floating Point

- Hexadecimal

- Integer

- Numeric

- Packed

- Time

Alphanumeric, date, hexadecimal, time and extended time constants must be enclosed within apostrophes ('......').

### Control Break

A control break occurs at the point where the value of the control field changes.

### Control Field

When you define a field as a control field in the Sort/Control column of the Worksheet, the records found by the transaction are sorted as for a sort field. In addition, you can define system functions in the Function column which are calculated either for the control field or for another field when the value or part of the value of the control field changes.

### Corporate File

Corporate files are general data files which exist at a user site. The Super Natural administrator defines which user is allowed access to which file. The Super Natural administrator can also authorize users to perform different levels of data maintenance on data stored in corporate files.

## D

### Data Maintenance

Data maintenance is the term used for adding, updating and deleting data using data maintenance transactions. Data maintenance transactions may be carried out for data contained in corporate files or in user files, as long as the user has been assigned the corresponding file access level by the Super Natural administrator.

### Database

A collection of files.

### Date Format

The date format you use in Super Natural is dependent on the Natural parameter DTFORM setting at your site. The following formats are possible where Y=year, M=month and D=day:

    DD/MM/YYYY (European)

    DD.MM.YYYY (German)

    YYYY-MM-DD (International)

    MM/DD/YYYY (USA)

Date field length in characters (bytes) = No length specification.

### Default Title Element

The default Title element supplied by Software AG uses the selection criteria as the report title. The administrator can set a new default title for you or your site. You can modify the default title for the current transaction.

### Delimiter

A delimiter is a special character used in the Layout Editor to represent a particular combination of color, field attribute and class. You can create your own delimiters by modifying your layout settings.

### Descriptor

Descriptors enable Super Natural to search for data in the database without having to read every record. It is more efficient to use descriptors in calculations, logical statements and as selection criteria because Super Natural is able to access them directly, thus requiring less internal processing. The database administrator can use both elementary and multiple-value fields to define descriptors. The following descriptors are available in Super Natural:

- Elementary key field

- Multiple-value key field

- Hyperdescriptor (Adabas only)

- Non-database descriptor

- Phonetic descriptor (Adabas only)

- Subdescriptor

- Superdescriptor

### Display Field

A display field is a field marked with a number in the Display column in the Worksheet.

### Dynamic Attribute (NRM)

You use dynamic attributes to draw attention to certain parts of a field value. (Alphanumeric fields only)

### Dynamic Input Field

Dynamic input fields are a kind of user field which you can use to execute a transaction several times using different values. You can use dynamic input fields in the same way as any other user field. Each time you run a transaction using dynamic input fields, Super Natural asks you to supply a value for each one. This means that you do not have to modify the transaction to see what happens when a new value is used.

Note
You may receive error messages if you run transactions using dynamic input fields in batch mode.

## E

### Editor Area

The part of an editor in which you can make entries and modifications.

### Editor

An editor is a tool for creating, modifying and deleting components necessary for creating transactions. The editors available for a transaction depend on the current transaction modes. Super Natural offers the following editors:

- Calculation Editor

- Logical Conditions Editor

- Selection Editor

- SQL Editor

- PC File Description Editor

- User File Description Editor

- Work File Description Editor

- Layout Editor (part of Natural Report Manager)

See Full-Screen Editor and File Description Editor. There are also separate entries for each editor.

### Edit Mask

Edit masks determine how fields are displayed. Using an edit mask, you can do the following when displaying fields:

- Insert blanks

- Insert characters

- Display the field with leading or trailing characters

- Display numeric fields with a sign before or after the number

- Suppress leading zeros in numeric fields

You can also use edit masks to determine how the date and time are displayed.

### Elementary Field

Elementary fields contain one value per record. For example, the field YACHT-NAME contains only one name per yacht. Compare with MULTIPLE-VALUE FIELD.

### Escape Character

The escape character is the character you enter before line and field commands in the all Super Natural editors. The escape character is indicated in the information line in the Layout Editor. You enter one escape character before a field command and two escape characters before a line command.

### Extended Field Description

Super Natural provides access to extended field descriptions stored in the Software AG data dictionary Predict. This feature is only available at sites where Predict is installed. You can access extended field descriptions from the Information column in the Worksheet or in any Field Selection List window.

### Extended Field Editing (NRM)

You use extended field editing to edit fields individually in the Layout Editor. For example, you may want to have the field NAME shown twice in a list, in pink at the top and in blue at the bottom. You invoke the Extended Field Editing window by issuing the field command `escape character E`.

### Extended File Description

Information about files held in the Software AG data dictionary Predict. This feature is only available at sites where Predict is installed. You can access extended file descriptions from any file selection list window.

## F

### Field

Fields are the smallest logical unit of information within a file. Fields are organized within records contained within files. The following field types are available in Super Natural:

- Elementary

- Multiple-value

- Group

- Periodic group

- User

- Dynamic input (type of user field)

- System variable

- Input

### Field Attribute

Field attributes are the field name, length, format and type.

In Natural REPORT MANAGER, field attributes govern how a field is displayed, e.g., blinking (for screen output only), intensified etc.

### Field Definition

Field attributes are the field name, length, format and type.

### Field (Maximum Number)

The maximum number of possible field references within Super Natural is 676 per default. To satisfy special requirements this limit can be enhanced up to 1196 field references.

For further information, see Technical Information > System Limits in the Administration documentation.

### Field Format

The field format determines which values can be assigned to a field and how long it can be. Each format is identified by a code. The following field formats are available in Super Natural:

- Alphanumeric (A)

- Binary (B)

- Date (D)

- Floating Point (F)

- Integer (I)

- Numeric (N)

- Packed Numeric (P)

- Time (T)

### Field Output Definition

Field output definition governs how a field appears in a report. You can change the field output definition by entering OD in the the Definition column next to the field in the Worksheet or by using extended field editing in the Layout Editor. Definitions defined in extended field editing override those made from the Worksheet.

### Field Reference

Each field is given a two-character reference in the Reference column in the Worksheet. The reference identifies the field's position within the file. You can always use a field reference instead of a field name in the Super Natural editors.

### File

A group of records stored together in the database and treated as a unit.

### File Access Code

File access codes indicate a user's file access level for data maintenance of database files. If a file is not a database file, its file access code indicates whether it is a user file or a superfile. The following file access codes are available:

A - Add (includes read and update)

D - Delete (includes read, add and update)

F - User file

R - Read only

S - Superfile

U - Update (includes read)

### File Description Editor

You use the file description editors to describe file layouts. When you use the transaction modes Data Selection DATA FROM WORK FILE and DATA FROM PC FILE, you must describe the layout of the work file or PC file you want to read. When you add a user file, you must define its layout. The following file description editors are available:

- PC File Description Editor

- Work File Description Editor

- User File Description Editor

File description editors consist of columns where you can enter the file description.

### File Layout

When a file is defined, the number of fields it contains, their lengths, names and formats are determined before any data can be put in it. This structure of the file (irrespective of data) is known as file layout. When you use the transaction modes Data Selection DATA FROM WORK FILE and DATA FROM PC FILE, you must describe the layout of the work file or PC file you want to read. When you add a user file, you must define its layout. You use the file description editors to describe file layouts.

### Flattening

For the purposes of updating data (data maintenance) or changing data for a report, multiple-value fields and periodic groups must be flattened. This means that each individual occurrence is presented as a separate record.

You can choose between flattening before or after processing and no flattening by modifying your transaction options.

### Floating Point Format (F)

You use floating point format to represent numeric values accurately which would otherwise be too long. The values in fields with floating point format consist of a mantissa (number) and an exponent.

### Full-Screen Editor

You use full-screen editors to tell Super Natural which data you want from the database, to specify calculations which take place when the transaction is run and for logical condition processing. The following full-screen editors are available:

- Selection Editor

- SQL SELECT Editor

- Calculation Editor

- Logical Conditions Editor

Full-screen editors are empty when you invoke them for the first time.

## G

### Group

A group connects related fields by giving them a group name. E.g. the group PERSON represents the fields; LAST-NAME, FIRST-NAME, INITIAL, SEX, AGE, FAMILY STATUS, NUMBER OF DEPENDENTS and PERSONNEL NUMBER.

A group can contain elementary fields and multiple-value fields. Groups can be contained or nested within other groups.

You can only use groups in the SEQ column of the Worksheet. If you mark a group with a number in the SEQ column, all the fields belonging to the group already listed in the Field Name column are automatically numbered.

If a group contains multiple-value fields, you can limit the number of occurrences to be displayed in reports by modifying your Transaction Options.

## H

### Header Character

Special character which you use to enter the header of a field automatically in the Layout Editor.

### Hexadecimal Value

You can use the hexadecimal counting system to represent numbers, letters, and special characters. The following are examples of hexadecimal constants:

    H'F1F2F3'  (equivalent to the numeric constant 123)

    H'C1C2C3'  (equivalent to the alphanumeric constant 'ABC')

You can also use hexadecimal constants to enter values which cannot be entered as standard keyboard characters:

    H'00'      (equivalent to the value 'no value')

### Hyperdescriptor

Hyperdescriptors are user exits in Adabas and function like subdescriptors and superdescriptors in Super Natural. Ask your administrator how to use hyperdescriptors at your site.

## I

### Information Sections A and B

When you invoke the Layout Editor from the Layout Overview screen for the first time, it consists of three sections, the editor area and the information sections A and B. Information sections A and B display information about the transaction fields and field delimiters you can use. You can choose whether you want to display transaction field and delimiter information in Section A or in Section B and you can use both A and B to display different parts of the same list.

### Input Field

The term input field field is used in two separate cases:

- An input field is a field on a screen in which you can enter information.

- Input fields are fields from PC or Work files which you create and use with the Data Selection modes PC FILE and WORK FILE. The format of the input fields must be the same as the format of the fields in the work file or PC file.

### Integer Format

Fields of integer format can only have the following values:

    I1 (-128.........+127)

    I2 (-32768......+32767)

    I4 (-2147483648............+2147483647)

As integers are whole numbers, decimals are not allowed!

## J

### Justification

Placing of string to far right (right justification) or far left (left justification) of space available. By default, the values of alphanumeric fields are left justified within the field length and numeric fields are right justified.

You can choose to display the values of numeric fields with left justification using Layout Settings and Extended Editing in Natural Report Manager.

## K

### Key Field (Called Descriptor in Adabas and Natural)

See Descriptor.

## L

### Layout

The layout determines the appearance of your report. You can edit the default layout generated by Super Natural in the Layout Editor.

### Layout Editor

The Layout Editor is part of Natural Report Manager. You use the Layout Editor to edit and create layout elements.

### Layout Element

You can edit and create the following report layout elements in the Layout Editor:

- Preface

- Title

- Header

- List

- Groups

- Appendix

- Footer

When you run a transaction, the layout elements always appear in a logical order. Title and footer (if defined) appear on every page and the other elements are sorted in the order listed above.

### Layout Setting

You can change the default layout settings for the current report by issuing the `SETTINGS` command. There are default settings for the following areas:

- General

- Newpage

- Format

- Delimiter

### Link Field

The fields in the primary and secondary files which provide a logical connection between the files when linking them. The link fields must have a logical relationship to each other and must have the same format.

### Logical Conditions Editor

You enter logical condition statements in the Logical Conditions Editor. You use logical condition statements to specify conditions under which arithmetic and/or assignment operations are to be executed. Logical condition statements must contain an IF statement and a THEN statement and can additionally contain an ELSE statement. You can specify multiple logical condition statements for a single transaction. The following are examples of typical logical condition statements:

    IF  < COMPANY-ID = '26'
    THEN < NEW-CRUISE-PRICE = CRUISE-PRICE * 0.9
    ELSE < NEW-CRUISE-PRICE = CRUISE-PRICE

    IF  < COMPANY-ID = '26'
    THEN < COMMENT-FIELD = '10% DISCOUNT'

You can also use the keywords ACCEPT and REJECT to accept or reject records if certain conditions are fulfilled.

### Logical Operator

You use logical operators to combine selection criteria statements. The following logical operators are available:

- AND

- OR

- OR=

- THRU

### Lookup Link Field

The lookup link field can be one of the following:

- Field in the primary file

- Field in the secondary file

- Field in a lookup file

- User field

The lookup link field is used to provide the link between the file in which it is contained and the lookup file via the lookup field. The lookup link field and lookup field must be of like format and represent a logical relationship.

### Lookup Field in the Lookup File

The field in the lookup file which provides a logical connection to the primary, secondary or another lookup file when using the Lookup function. The lookup field in the lookup file must be of like format and have a logical relationship to the lookup link field in the primary, secondary or other lookup file.

## M

### Mathematical Function

You can use the following mathematical functions in the Calculation Editor:

#### ABS(operand)

Calculates the absolute value of the operand.

#### ATN(operand)

Calculates the arc tangent of the operand.

#### COS(operand)

Calculates the cosine of the operand.

#### EXP(operand)

Calculates the exponential of the operand.

#### FRAC(operand)

Calculates the fractional part of the operand.

#### INT(operand)

Calculates the integer part of the operand.

#### LOG(operand)

Calculates the Natural logarithm of the operand.

#### SGN(operand)

Calculates the sign of the operand (-1, 0, +1).

#### SIN(operand)

Calculates the sine of the operand.

#### SQRT(operand)

Calculates the square root of the operand specified with SQRT. If the operand is negative, it is treated as positive. The maximum number of digits that can appear before the decimal point of the operand is 22.

#### TAN(operand)

Calculates the tangent of the operand.

#### VAL(operand)

Takes a numeric value from an alphanumeric operand and puts it into a numeric result field. The content of the operand must be the character representation of a numeric value. Leading or trailing blanks are ignored. Decimal points and leading sign characters are processed. If the result field is not long enough, decimal digits are truncated.

#### PERCENT(operand)

Calculates the percentage of the field for each record found in relation to the sum of all the values of the field found.

### Multiple-Value Field (MU)

A multiple-value field can have up to 191 occurrences per record. When using Adabas with the MUPEX function (see Adabas documentation), Super Natural supports up to 999 occurrences. For example, the field LANGUAGES contains as many values as the languages a person speaks. Each value within a multiple-value field is called an occurrence and can be dealt with separately. See Referencing Occurrences.

You can specify the maximum number of occurrences to be displayed in reports by modifying the transaction options in your user profile.

## N

### Natural Report Manager

Natural Report Manager is a tool available within Super Natural which generates a default layout for each report. Using the Layout Editor, you can edit report layout and create layout elements

### Newpage

You can set parameters which define page break handling in the Layout Editor by invoking layout settings.

### Null Values

Null values are zero for numeric fields and blank for alphanumeric fields.

### Numeric Field

Numeric fields are fields of the following formats:

- Binary (B)

- Floating Point (F)

- Integer (I)

- Numeric (N)

- Packed (P)

### Numeric Format (N)

Fields of numeric format can contain the following values: numerals, the special characters "+", "-", and the decimal character. The character which is used as the decimal character depends on the Natural settings (DC parameter) at your site. The following are examples of numeric values:

    1000
    -15
    +0.0258

Numeric values can have a total of 29 numerals (the decimal character and "+"and "-" signs are not included in the field length). There can be a maximum of seven numerals after the decimal character.

## O

### Occurrence

An occurrence is a value of a multiple-value field or the value of a field contained in a periodic-group. For example, the field C-AREA-CODE which is part of the periodic group COMPANY-PHONE may have the value 0431 as its first occurrence and 030 as its second occurrence.

### Online Mode/Processing

In online mode, the transactions submitted by the user are processed immediately. Contrast with Batch Mode/Processing.

### Operator

The following operators are available in Super Natural:

    EQ or =

    NE or ^=

    GT or >

    LT or <

    GE or >=

    LE or <=

    ST

    THRU

    NOT

    AND

    OR

    OR=

    +

    -

    /

    !

    *

    ACCEPT

    REJECT

You use operators in the Selection Editor, the Calculation Editor, and the Logical Conditions Editor. Not all of the operators are available in all the editors.

## P

### Packed Numeric (P) Format

Packed Numeric values do not take up as much space internally as numeric values. Values in packed numeric format are represented in numeric format on your screen and in reports.

Values in packed numeric format can have a total of 29 numerals (the decimal character and "+" and "-" signs are not included in the field length). You can have a maximum of seven numerals after the decimal character.

### PC File Description Editor

When you are adding a reporting transaction with the transaction mode Data Selection set to DATA FROM PC FILE, you must use the PC file description editor to describe the file layout of the file you are using.

Enter the names of the fields to be read from the PC file, their format and length in the relevant columns.

### Periodic Group (PE)

A periodic group contains a series of elementary and/or multiple-value fields which occurs more than once.

The values contained within a periodic group are structured like records. These records within records are called occurrences. A periodic group can have up to 99 occurrences. When using Adabas with the MUPEX function (see Adabas documentation), Super Natural supports up to 999 occurrences.

You can specify the maximum number of occurrences to be displayed in reports by modifying the transaction options in your user profile.

### PF Key (Program Function Key)

Some commands are allocated to PF keys. To issue a command using a PF key, you just press the PF key and do not have to press ENTER. The PF key allocations which are available for a particular screen are listed in the PF key lines.

### PF Key Lines

The PF key allocations which are available for a particular screen are listed in the PF key lines. You can change the position and appearance of the PF key lines by modifying your user profile.

### Phonetic Descriptor

You can define phonetic descriptors to perform a phonetic search. A phonetic search searches for values which sound like the phonetic descriptor. Phonetic descriptors cannot be displayed on a report.

### Predict

Predict is Software AG's data dictionary. See EXTENDED FIELD DESCRIPTION and EXTENDED FILE DESCRIPTION.

### Protected Field

If a field is protected, you cannot make any entries in it.

### Prototype Program

A program written in Natural (Reporting Mode) that can perform the same functions as a Super Natural transaction. Because it does not contain code specific to Super Natural, a prototype program can be used like any other Natural program.

## Q

### Qualifier

The number or letter identifying a field in an information section of the Layout Editor.

## R

### Record

A set of fields treated as a unit in a file. All records in a file contain the same set of fields. Records contain information which is related e.g., in the SAG-TOURS-E-YACHT file, all the information about a given yacht.

### Referencing Occurrences

If you want to deal with the different occurrences of multiple-value fields or periodic groups separately, you must give each occurrence a reference number enclosed within parentheses (()).

#### Example

    C-ADDRESS-ADDITION(1)

This refers to the first value of the multiple-value field C-ADDRESS-ADDITION which is contained within the group COMPANY-ADDRESS.

#### Example

    PHONE(2)

This refers to the second occurrence of the periodic-group field PHONE.

If you want to reference an occurrence of a multiple-value field within a periodic group, you must use two reference numbers separated by a comma (,) as shown below:

    fieldname (occurrence # periodic group,occurrence # multiple-value field)

The first number indicates which occurrence of the periodic group it is in and the second number indicates which value of the multiple-value field it is.

#### Example

    SEASON-START (1,2)

This refers to the second value of the field SEASON-START which is in the first occurrence of the periodic-group field CH-SEASON

Referencing occurrences is especially useful in calculations.

### Report

The result of a transaction whatever the transaction mode.

## S

### Scale

The scale is part of the Layout Editor information line and displays the name of the element you are editing or the text All Elements. The scale also shows which columns are displayed. The columns are identified by a three-figure number at intervals of 20 columns. The column itself is underneath the second figure of the number.

### Selection Column

Screens or windows showing lists of objects or functions for selection contain a column of input fields to the left of the list. The column is one field wide and you can select an object or function by marking it with a non-blank character or with the cursor position. Some of the input fields may be protected. If you mark any item with a non-blank character, the cursor position is ignored.

### Selection Criteria

The information entered in the Selection Editor which controls which records in a file are to be selected.

See Selection Editor.

### Selection Editor

Entries made in the Selection Editor control which records in a file or files are to be selected. To tell Super Natural which data you want from the database, you enter selection criteria in the Selection Editor.

Selection criteria consist of one or more statements combined with either the logical operator AND or OR.

### Show Area

You can choose to display a layout element in the top half of the Layout editor screen. This part of the screen is then called the show area.

### Special Break Condition

By defining special break conditions, you can make control breaks occur when the first n characters of a control field change. For example, you may want a control break to occur each time the first two character of the field COMPANY-NAME change.

### SQL SELECT Editor

Users of DB2 and SQL/DS can enter selection criteria in the SQL SELECT Editor using SQL SELECT statements.

### Subdescriptor

A descriptor created from a portion of an elementary field.

### Subfield

A portion of a field which may be defined for access purposes only.

### Superdescriptor

A descriptor created from up to five fields (or parts thereof) which may or may not be descriptors. A superdescriptor can only be displayed in a report if Adabas Version 5 is installed.

### Superfile

A transaction created by the Super Natural administrator which the user accesses from the File Selection screen. A superfile can be modified and/or run by a Super Natural user. Superfiles have the function code "S" on the File Selection screen.

### System Function

System functions calculates statistics which can be displayed either when the value of a control break field changes or at the end of a report. The following system functions are available:

- Average

- Count

- Maximum

- Minimum

- Null Average (null values ignored)

- Null Count (null values ignored)

- Null Minimum (null values ignored)

- Sum

- Total

Note
Null values are zero for numeric fields and blank for alphanumeric fields.

### System Variable

System variable fields show information which comes directly from the system.

You can obtain a selection list of system variables by entering two asterisks (**) in the Field Name column in the Worksheet. Appendix B lists and describes all the system variables available in Super Natural.

## T

### Text Field

Field marked in the DIS column of the free-format screen with a T1 through T99 notation, indicating that it is to be displayed vertically without a header.

### Transaction

The basic activity in Super Natural. In a transaction, data may be read from a file to produce a report (reporting transaction) or data may be added to, updated in or deleted from a file (data maintenance transaction). When a transaction is run, it produces a report.

## U

### User Field

User fields are not contained in a database file. User fields are defined by the user for a particular transaction. User fields are most commonly used in calculations, logical condition processing and SQL. See also Dynamic Input Field.

### User File

Files created by a Super Natural user. User file data is kept physically separate from data in corporate files. Users may be authorized by the Super Natural administrator to access files created by other users, although usually with limited file access (e.g., permission to read another user's user file, but not to maintain data).

### User File Description Editor

Used for designing the file layout of user files. You can use the layout of an existing file as a template and/or define your own field descriptions.

## V

### Value

The contents of a field, or the contents of a specific occurrence of a field, e.g., the attribute MASTERCARD for the field CREDIT-CARD.

## W

### Work File Description Editor

When you are adding a reporting transaction with the transaction mode Data Selection set to DATA FROM WORK FILE, you must use the Work File file description editor to describe the file layout of the file you are using.

- Enter the name of the fields to be read from the work file, their format and length in the relevant columns.

### Worksheet

The Worksheet provides the basis for creating reports. You use the Worksheet as follows:

- To select the fields you want to use from the file or files you have chosen

- To determine how the data is displayed in the report (sequence, sort criteria, control breaks, output definition etc.).

Different versions of the Worksheet appear according to your user default settings and the transaction mode you are using.

## X

## Y

## Z

### On this page

- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z